Category Archives: SSMS
-
Default SQL Agent Reports – Top Jobs
1July 24, 2017 by Kenneth Fisher
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several …
Continue reading -
Default Database Reports – Disk Usage by Table
1July 19, 2017 by Kenneth Fisher
Every now and again you need to know how big a table is. Or several tables. Or all of the …
Continue reading -
Default Instance Reports – Configuration Changes History
Leave a commentJuly 17, 2017 by Kenneth Fisher
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
Continue reading -
Default reports in SSMS
1July 13, 2017 by Kenneth Fisher
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are …
Continue reading -
SSMS Tips: Copy Full Path
Leave a commentApril 24, 2017 by Kenneth Fisher
When you right click on a tab you’ll see a number of different options. You can set up new horizontal …
Continue reading -
Hiding tables in SSMS Object Explorer
Leave a commentApril 3, 2017 by Kenneth Fisher
Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
Continue reading -
Changing what SSMS opens on startup
Leave a commentFebruary 1, 2017 by Kenneth Fisher
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
Continue reading -
:OUT :OUT darn results!
3December 19, 2016 by Kenneth Fisher
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the …
Continue reading -
Using Snippets
Leave a commentOctober 17, 2016 by Kenneth Fisher
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
Continue reading -
Pinned Tabs
3September 27, 2016 by Kenneth Fisher
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
Continue reading
