Blog Archives

7 Things You Should Do When You Inherit An SQL Server

I’ve decided to put together this blog post as a beginner’s guide to dealing with an inherited SQL server environment. You should read this if you’re going to be put in charge of the SQL servers in your company, for example if you’ve just been hired as the new DBA or if you’re a consultant or maybe a Windows admin tasked with the job of being a DBA as well.

Posted in SQL

SQL Server security best practices

I’m going to use this blog post to name 5 SQL Server security best practices that should be your top priority in keeping your SQL Server environment safe. You are, maybe, a newbie DBA who is looking for the best practices in maintaining a SQL server environment or you are just a first-aid Windows systems engineer who also administers other Windows services. As a DB admin, you need to take care of SQL server security and protect the integrity of your organization’s data.

Posted in SQL Tagged with: ,

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:

Introducing SQLDocKit – the SQL documentation tool

It has been five years since we released SPDocKit. Our initial idea was to create a simple documentation tool for SharePoint admins. Since then, we have made a great deal of progress. We have improved and upgraded so many aspects

Posted in SQL, Windows general

SysKit 2016 – Ultimate Server Monitoring Tool

Back in 2009, when Toni and I co-founded Acceleratio, Terminal Services Log was our first and most important application. Over the years, thousands of clients have used our software to monitor many more thousands of their servers across the globe. During

Posted in Active Directory, RD Gateway, Remote Desktop Services, SQL, Windows general, WMI

SQL – list all database sizes order by size

We have several internal Microsoft SQL servers, most of them are test servers with millions of small and big databases. Sometimes I need to find big database because I know that database if full of client generated or auto-generated logs

Posted in SQL Tagged with: