Blogs

Three Places to Get Information On New Updates for SQL Server

There are many consistently hot topics around SQL Server. One such topic is, “How does a DBA obtain the latest information on updates?” In this post, I will discuss three places that I frequent for information on SQL Server updates. The first link I …

Continue reading

Moving Database Files to Another Drive

You may occasionally have the need to relocate database files. What are some reasons that may prompt the need for this type of change? First, someone might have discovered that the database files are on the same drive as the operating system. For a …

Continue reading

Setting Min and Max Server Memory Setting

Configuring the min and max server memory settings for SQL Server has a number of things to consider prior to making changes. Before we jump into those considerations, let’s learn what the min and max server memory options do. What does the min …

Continue reading

Three Reasons to Use Windows Groups to Manage SQL Server

Ever come across a SQL Server that had 5, 10, or more individual logins for users in it? I have a few times and it made me wonder if whoever had done such a thing realized how much harder they were making the administration of the server by doing …

Continue reading

3 Additional Tips for Using SQL Server Management Studio

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 …

Continue reading

You Really Should Stay Current on Cumulative Updates

 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 …

Continue reading

3 Reasons Not to Install Databases On the C Drive

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 …

Continue reading

3 Tips for Using SQL Server Management Studio

 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 …

Continue reading