Monthly Archives: August 2015
-
The default instance has a name
11August 31, 2015 by Kenneth Fisher
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but …
Continue reading -
The 30 minute rule
9August 26, 2015 by Kenneth Fisher
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
Continue reading -
The tail of the log
Leave a commentAugust 24, 2015 by Kenneth Fisher
A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I …
Continue reading -
SSMS’s Clipboard Manager
13August 19, 2015 by Kenneth Fisher
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask …
Continue reading -
Pulling data from the error log
8August 17, 2015 by Kenneth Fisher
The other day I was asked to pull a list of errors from the SQL Server log into a table …
Continue reading -
Getting and storing a high precision datetime
5August 13, 2015 by Kenneth Fisher
Earlier today I was working on a project where I was recording some time stamps. In order to get as …
Continue reading -
Database Master Keys can have more than one password.
3August 11, 2015 by Kenneth Fisher
Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first …
Continue reading -
A pattern to match correctly on a value or a NULL
3August 5, 2015 by Kenneth Fisher
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this …
Continue reading -
SQL Crossword
6August 3, 2015 by Kenneth Fisher
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF …
Continue reading
SQL Studies 