-
Extending your metadata with Extended Properties
9May 18, 2015 by Kenneth Fisher
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
Continue reading -
Test first; Mileage may vary;
2May 14, 2015 by Kenneth Fisher
I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a …
Continue reading -
TSQL Tuesday #66: Monitoring
2May 12, 2015 by Kenneth Fisher
If a user is going to call me about problem, I’d much rather know about it ahead of time. In …
Continue reading -
Notes on Presenting
9May 6, 2015 by Kenneth Fisher
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of …
Continue reading -
Building a job to monitor other jobs
5May 4, 2015 by Kenneth Fisher
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
Continue reading -
Running Powershell scripts remotely.
2April 29, 2015 by Kenneth Fisher
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of …
Continue reading -
What SQL version is my SSIS package?
29April 27, 2015 by Kenneth Fisher
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how …
Continue reading -
Backup before you restore
4April 22, 2015 by Kenneth Fisher
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back …
Continue reading -
The hidden security of msdb
3April 20, 2015 by Kenneth Fisher
To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
Continue reading -
Adding, altering or removing multiple columns from a table
2April 16, 2015 by Kenneth Fisher
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 