Category Archives: Settings
-
SSMS Setup
9November 16, 2015 by Kenneth Fisher
Every time I install a new version of SSMS I make a handful of changes to the default setup. For …
Continue reading -
Generating scripts for previous versions of SQL
1October 21, 2015 by Kenneth Fisher
I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
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 -
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 -
Port numbers and SQL Server
Leave a commentMarch 30, 2015 by Kenneth Fisher
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
Continue reading -
Why not NOLOCK?
10March 18, 2015 by Kenneth Fisher
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
Continue reading -
Database default locations
4September 29, 2014 by Kenneth Fisher
One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
Continue reading
SQL Studies 