Welcome to the webinar session where we discussed our new tool, SQLDocKit. In case you missed it, we bring a recap of the introductory webinar in which Sara and Toni guide you as you “Get to Know SQLDocKit.”
For starters, let us introduce ourselves.
Acceleratio is a software development company from Zagreb, Croatia. We specialize in developing various tools and solutions that help SharePoint administrators, Office 365 administrators and consultants, and system administrators to monitor their Windows Remote Desktop Services, Citrix server and software. With 7 years in the business, we’ve acquired more than 2000 satisfied clients worldwide and won their trust with our three products: SPDocKit, SysKit, and CloudKit 365.
Now, if you’re wondering whether you’re on the right page when it comes to SQL Server auto-detection or how any of this might be of use to you, here’s what you need to know:
IT management is a critical when it comes to financial management.
SQL represents a great deal of company resources.
Successfully keeping track of your resources leads to decreased revenue loss.
If there were only a tool that would manage those resources in just a few minutes. Well, luckily, now there is, and it’s called SQLDocKit.
On today’s webinar agenda, we’ll cover SQL Server housekeeping, SQL Server and IT inventory management, a brief SQLDocKit overview, and then Toni’s SQLDocKit demo. Afterwards, we’ll share some of our plans for the future of our product with you. Be sure to check our Q&A section at the end of the webinar, or scroll down if you’re inquisitive and want the answers to your questions right away!
Table of contents
SQL Server and IT inventory management
When discussing SQL Server and IT inventory management, we would like to focus on our demo SQL Server environment. Microsoft SQL Server is an everyday, go-to enterprise database solution. With SQL come a lot of responsibilities, like complex licensing with multiple editions, which is now simplified with the latest release. The issue is that it’s a challenge to manually oversee your entire SQL Server environment with all these editions. Things tend to get out of hand pretty quickly and without a warning.
For example, there’s a slim chance that a SQL admin will be able to figure out which team deployed which server instance and where. Not to mention how many databases they have, which editions are being used, or who the database owner is. At some point this leads to maintenance problems and costs your company way more resources and money than it should. Now, before the realization of the state of your SQL Server environment hits you like a ton of bricks, let’s talk about our solution.
Your solution to SQL Server environment nightmares
SQLDocKit is a Windows-based application developed for database administrators and consultants to ease their daily routine around server instances.
The idea behind SQLDocKit was born not long ago—to be precise, the winter of 2016. After pondering the success of our previous documentation tool, SPDocKit, which was designed for SharePoint admins, we came up with the idea of developing a similar tool for SQL admins. Instead of documenting and managing SharePoint farms, we targeted the SQL Server environment. The idea gained even greater momentum when our system admin left the company and we were left in the dark about what was going on in our own SQL Server environment.
The question we were faced with was: how can you even start managing SQLs when you don’t have a clue where they are? That’s how the first feature of SQLDocKit was born–the ability to autodetect all SQLs and instances deployed in one environment. Once that feature was completed, we gradually added others, and now SQLDocKit has a wide range of tricks up its sleeve:
- Topology and inventory
- License compliance
- Validation to best practices
- Tracking and comparing changes
Inventory and reports
The Autodetect feature crawls through the entire domain and auto-discovers all SQL Servers and their instances; then it can create different reports, based on your company’s needs. All of those reports can be exported to a DOCX or PDF file containing server info, instances, databases, and databases files. They can be delivered to you via email after, saved to a SharePoint site, or stored on your File Share system. In addition to these reports, you can generate full SQL inventory documentation.
SQLDocKit reports can be divided into Usage reports (Disk, DB, Logs, Storage Metrics) and Cleanup reports (Orphaned and Unused DBs).
With Best Practices, you can compare environment configuration settings to the ones suggested by community best practices, and at the same time be alerted to any potential misconfigurations. Some of these reports include valuable information about:
- Hardware requirements
- ModelDB and TempDB
In cases where you don’t agree with the suggested threshold values, you can customize thresholds and configure them to meet your company’s unique demands.
Snapshots and Compare
SQLDocKit generates reports based on information gathered from snapshots that contains all the configuration settings. Snapshots can be taken manually or adjusted to be taken automatically. Once you have two snapshots from different points in time, they can be compared, allowing you to track any changes made in the period in-between the two selected snapshots. Of course, if things go south you can easily notice and pinpoint why and where it all went to smithereens. The feature is enhanced with the Mark as a good configuration option, making sure you don’t lose sight of properly configured settings.
What makes SQLDocKit great is the fact that you can even compare different SQL Servers. This is an especially helpful feature when you have live, production, or test environments and need to make sure they are compliant with your company requirements.
Before heading out to the demo section of this webinar, let’s check out the requirements for SQLDocKit.
SQLDocKit is an agentless tool and needs to be deployed on one application server or workstation in your domain. No agents need to be installed on the monitoring SQLs. SQLDocKit supports all versions and editions of Microsoft SQL. To use SQLDocKit you must have adequate permissions.
To see SQLDocKit in action, skip right to 16:15, where Toni Frankola, the co-founder and CEO of Acceleratio, will guide you through the demo on a demo Windows Server 2012 R1. Join Toni on a detailed, step-by-step video tour of SQLDocKit features and capabilities.
To our pleasant surprise, we’ve wrapped up this webinar with quite a few questions. Here’s what we were discussing in the Q&A section: