-
Default database
Leave a commentMay 26, 2015 by Kenneth Fisher
What? The default database is one of the options when creating a login in SQL Server. This is the initial …
Continue reading -
Adding new users & groups in windows
1May 20, 2015 by Kenneth Fisher
I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
Continue reading -
Extending your metadata with Extended Properties
5May 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
1May 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
8May 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?
Leave a commentApril 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
3April 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
SQL Studies
Live, Learn, Share
