[Video] How to Compare SQL Servers in your environment with SQLDocKit

Thanks so much to those of you who were able to join us for last week’s SQLDocKit webinar! In case you missed it or just need a refresher, here’s a summary of the key points.

Frane Borozan, SQLDocKit product owner, hosted the webinar and explained how to compare SQL Servers with the SQLDocKit Compare Wizard feature. We started the discussion by going over the most popular features and benefits of using SQLDocKit in SQL Server administration.

Finally, Frane headed over to the demo where he guided the attendees through the SQLDocKit Compare Wizard and what it is that you can compare.

Some of the key segments we discussed are as follows:

  • What is SQLDocKit?
  • How does it work?
  • Features overview
  • Demo: How to compare SQL Servers

Get a better understanding of your SQL Server environment

What is the most troubling thing when it comes to SQL Servers? You have no idea how many you have running in your domain. It can be a Kafkaesque experience; I’ll give you that. And you can find out manually, but you have to put some elbow grease into it.

SQLDocKit – The great visibility cloak

Luckily, you don’t have to do anything manually anymore because SQLDocKit was developed to auto-discover all SQL Servers in your environment. In fact, from a single console, the tool auto-detects all SQL Servers and SQL Server instances on Windows Servers. If you have SQL Servers hosted in Azure, you gather valuable information for those too.

Once you install SQLDockit it retrieves information about SQL Servers in detail, including the type of authentication configured on the server, CPU, memory, security settings, different users, connections, databases, etc. If you have a lot of databases and you’re unsure how much storage to assign to different SQL Servers, check how your databases are behaving over time. You can detect orphaned databases (ones without users) or whether a database was disabled or deleted for some reason. You can also detect unused databases, as well as SQL Server BI, integration and reporting services. SQLDocKit gathers basic data for Windows Servers hosting SQL Server instances such as installed patches, cumulative updates, lists of local admins, etc.


Oh, and another awesome thing is that SQLDocKit supports SQL Servers hosted on Linux. We added this a few weeks ago.


You can install SQLDocKit anywhere, either on a Windows Server or on a regular workstation. It’s not invasive and doesn’t take up a lot of memory.

SQLDocKit Compare Wizard

Frane guided us through the application, to show how the Compare Wizard works, what Snapshots are and how you can use them for various comparisons.

All data are stored in a snapshot, which contains the entire SQL Server inventory at a particular point in time. When you use the Compare Wizard, you compare two snapshots and detect what changes have been made.

  • Create snapshots containing SQL Server settings.
  • Compare snapshots: Whether it’s the same SQL Server over time or different ones in different environments.
  • Detect any differences.

This gives you easy answers for why one server is working properly and the other isn’t.

SQLDocKit has a simple and intuitive Compare Wizard. You can drill down in each server to reach all its settings – for example, you can see that a certain database is missing on one server and there on the other. Or that someone added a new user to that database. The Compare Result report can be easily exported in a PDF or Excel spreadsheet.

Demo

Someone changed the authentication mode from Mixed to Windows Authentication, and you have no clue who did it? Someone changed the configured memory value from 18GB to 8GB? Check out the video, and see how to track changes to figure out what’s going on in your environment.

Here are the topics covered in this demo:

  • How to compare two different SQL Servers
  • Analyze the results and detect the differences
  • How to take a Snapshot

Table of contents

04:40 Agenda
05:45 SQLDocKit Overview
17:15 Demo by Frane Borozan
30:50 Q&A

SQLDocKit 30-day Free Trial

SQLDockit is built for every environment and company type, thus it has two licensing options, in-house and consultant. If you want to see more from SQLDocKit and its capabilities, contact us, and we’ll organize a personalized demo. In the meantime, download SQLDocKit for a 30-day free trial, and tell us how you like it. If you have any suggestions, tell us in the comments section below.