Tag Archives: microsoft sql server
-
Multiple Windows Groups with different default databases
2May 28, 2015 by Kenneth Fisher
A question came up at work the other day, mostly as a mind game, but you never know it might …
Continue reading -
Default database
4May 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 -
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 -
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 