Category Archives: SQLServerPedia Syndication
-
SSMS 2015
4July 16, 2015 by Kenneth Fisher
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10 …
Continue reading -
TSQL Tuesday #68: What is my configuration?
2July 14, 2015 by Kenneth Fisher
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just …
Continue reading -
What is the database property “Compatibility Level”
7July 8, 2015 by Kenneth Fisher
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in …
Continue reading -
Adding a new keyboard shortcut in SSMS.
7July 6, 2015 by Kenneth Fisher
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. …
Continue reading -
Blocking and deadlocking on purpose
3July 1, 2015 by Kenneth Fisher
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
Continue reading -
Zero to Speaker pt 2
6June 29, 2015 by Kenneth Fisher
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS …
Continue reading -
Which user function do I use?
3June 24, 2015 by Kenneth Fisher
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
Continue reading -
Copying a TDE database from one instance to another
12June 22, 2015 by Kenneth Fisher
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
Continue reading -
Pass TV
3June 17, 2015 by Kenneth Fisher
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an …
Continue reading -
Rename a database
3June 15, 2015 by Kenneth Fisher
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s …
Continue reading
SQL Studies 