SQL Server supports SQL Mail for email notifications, and traditionally I’ve used SQL Mail to keep myself apprised of various server issues.
Slack is a great alternative to email, and a lot of folks make extensive use of slack. I thought it would be nice to receive notifications from SQL Server in a slack channel, and so started looking into …
To create a CLR stored procedure in SQL Server….
I used this nice blog posting by Scott Sutherland as a starting point:
https://blog.netspi.com/attacking-sql-server-clr-assemblies/
If you are using SQL Server 2017 it will be necessary to sign your CLR assembly.
If you are doing this in a development environment, you may wish to create a public/private key pair:
https://docs.microsoft.com/en-us/dotnet/framework/app-domains/how-to-create-a-public-private-key-pair
Once you’ve …
One of the things that I really like about Microsoft products (and one of the reasons for their success) is the very well documented and very capable APIs that Microsoft provides. Dynamics is no exception.
Here are some helpful links that describe how to access the Microsoft Dynamics APIs, if you wish to create applications that query or report on …
I’ve been doing quite a lot of work with C# reflection recently. Reflection is nifty stuff. It’s cool to have code that can inspect itself, execute itself dynamically.
I’ve been using reflection to create applications that use “plug-ins”. For example, the user might have a management GUI that allows them to select one of several similar but not identical assemblies. …
I love how easy it is to use HTML5 for animation. Recently I discovered another cool feature of the HTML5 graphics API: Clipping.
Clipping is a little like photoshop paths. You use the HTML5 api to draw shapes and then you can use clipping to show content only inside the boundaries of that path.
In a …
Not all programming work requires the same set of aptitudes and skills. Here is my take at some groupings:
My oldest son and I just completed a three day course in “mold making and resin casting” at the Northhampton Community College Fab Lab. It was a great experience. I signed us up because my son had been 3D printing fidget spinners. He had sold a couple that he made to friends, but they were relatively expensive to make …
I’ve been following the trials and tribulations of Uber for quite a while. Uber was initially celebrated as disruptive and a game changer, a company that would radically transform American transportation. However, even in the beginning there were complications. Heavily licensed and inspected taxi cab drivers were up in arms at competition from an upstart free from the mandates that …
I’ve just posted an updated version of my SQL Script Mover utility on codeplex, here: https://sqlscriptmove.codeplex.com
This is a utility for extracting schema from a sql server database. It supports views, stored procedures, functions, tables, triggers and DDL triggers.
…
Here are some thoughts on optimizing stored the performance of stored procedures.
In no particular order:
Clustered Indexes
Make sure your tables have clustered indexes.
It’s amazing to me that folks create tables without clustered indexes. A clustered index is the physical order of data in the table and it’s my understanding that it is difficult for SQL to reclaim …
Copyright © 2019 | WordPress Theme by MH Themes
