So you have assigned weekend DBA role and you need to take care about your company SQL servers as well. I will focus here on checking the change logs for the SQL server analysis services, it some other blog post we will pay attention to the SQL server database service…
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…
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…
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…
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!
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 of our tool, and on so many levels, that we…
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 that time, we have shipped many other products in the…
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 that we use for testing. Finding that database can be…