Blog Archives

Top 10 SQL Server best practices for DBA newbies

In this blog post, I would like to discuss the most important SQL Server best practices. I thought I might start off with 10 best practices I reckon would be any DBA’s most important maintenance best practices. And these are only the basics. I’m not an SQL expert like many of the MPVs and other professionals who have devoted their entire career to SQL Servers; however, I just wanted to share with you some common best practices.

I’ll discuss some security basics, data and log file management, tempDB management, the importance of SQL Server documentation, changing autogrowth default settings, why regular backups mean the world to your company’s data and why patching your SQL Servers is crucial.

Posted in SQL, Uncategorized Tagged with: , ,

In search of free SQL Server inventory tools

I have imagined this article to be some sort of outline of available solutions for SQL administrators. Now, in this blog post discusses various free solutions for detecting and inventorying Microsoft SQL Server instances. I’ve found a few, so check them out in the blog post!

Posted in SQL Tagged with: