SQL Server Administration through SQL Server Management Studio

Goal

To create an interface that contains the up to date information and know how when it comes to manage SQL Server databases using SSMS and to prepare for further certification or just to refresh the knowledge or improve them with something new.

My way of achieving it

By duplicating the SQL Server Management Studio interface using static information and using Tool Tips. Before anything else I want to mention that:

  • I am not a programmer
  • The information is taken from other DBAs that were kind to share it online

When I started to learn SQL Server it was obvious ( and I am speaking only about the database engine) that it will be hard to always remember anything and this became more clear throughout my jobs since every company has its own vision and they are doing things in their own way. On top of these, most of the time, depending on the position and the job description we are loosing the knowledge and the know how that we learned during a SQL Server certification or during a job where we had to do only performance troubleshooting or during a job which required only database maintenance and user creation and so on. Because of this I decided to start making this simple application in C sharp in order to use it as a repository of knowledge and best practices when it comes to SQL Server.

The main purpose of this application is to

  • help someone that just started to learn SQL Server by having some of the information at one click
  • for more experienced DBA it might be just a repository containing the experience he accumulated throughout his jobs. Every ToolTip can have a legend section  where we can put  how we solved a similar issue or what was the root cause.
  • for others might be just a place containing the answers that we have to provide when speaking, solving SQL Server problems.

Below is a video that I made showing some of the things. Ignore how the application looks it is just to show how good would have been if Microsoft would have provided an argument when starting SSMS that will allow some ToolTips and some best practices.

Below you can watch some of the things that I manged to create and do till now.

 

Leave a Reply

Your email address will not be published. Required fields are marked *