Category Archives: SSMS
-
Modifying the “New Query” template.
Leave a commentJune 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.
1June 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 -
Yet one more quick and easy performance tuning setting
Leave a commentJune 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 -
Using Solutions in SSMS
3March 11, 2015 by Kenneth Fisher
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
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 -
Escaping from a runaway Logon trigger
1May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading -
The default autogrowth settings do NOT come from the Model database.
1April 28, 2014 by Kenneth Fisher
I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
Continue reading -
:CONNECT in SSMS
7March 13, 2014 by Kenneth Fisher
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from …
Continue reading
