-
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 -
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 -
Adding new users & groups in windows
4May 20, 2015 by Kenneth Fisher
I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 