In an earlier post I listed three tips for using the SQL Server Management Studio user interface. I want to offer three additional tips for SSMS. I think you will find that these ideas will bring additional efficiency and functionality to your use of …
I have encountered a Log Shipping error that I want to detail as an encouragement for staying current on SQL Server cumulative updates. First, a little background. The environment is SQL Server 2014 Standard edition with a physical machine as the …
We’re probably all familiar with the fact that SQL Server by default will install not only the program binaries but all your databases on the C drive as well. Accidental DBA’s, i.e. System Administrators and Developers who inherited the maintenance …
You’ve been using SQL Server Management Studio for a long while now, but you mostly only using the New Query window to write T-SQL and the Object Explorer to do management tasks for an instance. You know it can do more, but you are a busy data …