-
Learning Regular Expressions
5September 2, 2015 by Kenneth Fisher
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term …
Continue reading -
The default instance has a name
2August 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
3August 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
The tail of the log A little while back I was feeling overwhelmed by the number of blog posts ideas …
Continue reading -
SSMS’s Clipboard Manager
10August 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
6August 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
Leave a commentAugust 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
Live, Learn, Share
