Category Archives: SSMS
-
SSMS’s Dark Theme
3April 4, 2018 by Kenneth Fisher
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading -
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
6April 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
