Tag Archives: microsoft sql server
-
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 -
Modifying the “New Query” template.
13June 11, 2015 by Kenneth Fisher
TLDR; Search for and modify the sqlfile.sql file. During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET …
Continue reading -
A walk-through of creating the Activity Tracking template using Extended Events.
5June 9, 2015 by Kenneth Fisher
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started …
Continue reading -
Clean up all (most) of the orphans on an instance
3June 3, 2015 by Kenneth Fisher
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
Continue reading -
Yet one more quick and easy performance tuning setting
1June 1, 2015 by Kenneth Fisher
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
Continue reading
SQL Studies 