Category Archives: SSMS
-
SQL Homework – September 2017 – Create a home lab
Leave a commentSeptember 5, 2017 by Kenneth Fisher
As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something …
Continue reading -
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
4April 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
