Your data is the lifeblood of your company. As your business grows, your databases will grow and the demands on your database servers will increase. As the demands increase, you can begin to experience declining performance. Simply put, if your SQL Server is not busy, you can get by with a lot of inefficient or even incorrect configuration settings. However, a higher load will expose those shortcomings and performance will suffer. I specialize in helping small IT departments effectively manage their SQL Servers. Although I am currently managing over 70 SQL Servers on a daily basis as part of a large IT team, I have worked for several companies that have had only a handful of SQL Servers and even fewer IT employees. I understand the time, experience and workload challenges such departments are under. I am adept at helping the “involuntary DBA” – that person who has no formal training with SQL Server, but is nevertheless responsible for keeping it running, simply by virtue of the fact that he or she is in the IT department. I can tune your servers for optimum performance and explain why I do the things I do in clear, easy to understand terms. As a consultant, I view my job as not just to fix your SQL Server issues, but also to educate you and your staff about SQL Server so you can take on some of that responsibility yourself in the future. (Of course, if you prefer not to take on that responsibility, that’s fine also. I love repeat customers and am more than happy to schedule regular periodic checkups!) I can also set up automated maintenance plans to ensure your servers keep running at optimum performance. I am also Microsoft Certified on SQL Server.
SQL Server Health Checks
When you engage my services, I’ll send you a questionnaire to learn more about your environment – things like the number of SQL Servers you have, what your backup strategy is, what I/O subsystems your SQL Servers are using, etc. When I receive that back, we can set up a remote connection to your network, where I’ll run a script on your SQL Server that will check over 80 areas that can affect performance, reliability, and security. (The script is extremely lightweight and can be run on production systems without any performance hit.) You’ll get a detailed report of each check with links you can visit to find out more information. Of course, that probably won’t be necessary because you’ll also get a conference call with me to explain the results, what they mean, and what steps to take for improvement. You can make those changes on your own or engage my services further to make them for you. I’ll also review your backup and maintenance plans, if you have any. If you do not, I’ll create them for you so that your SQL Servers continue to operate at peak performance. Contact me to set up an appointment today.
I’ve developed a couple of online training courses:
Microsoft SQL Server 101 – This course is designed for new DBAs and involuntary DBAs or anyone who needs to learn the basics of SQL Server. The course can be found here at Udemy.com and includes demos and sample scripts. Use this link (or enter the coupon code 15OFFBLOG) and get a 15% discount! This course is over 4 hours long and can be taken at your own pace.
Understanding Data Compression in SQL Server – This course delves into how SQL Server’s data compression feature works and how and when to implement it. The course can be found here at Udemy.com. It includes demos and sample scripts. Use this link (or enter the coupon code 15OFFBLOG) and get a 15% discount! This course is approximately 1.5 hours long and can be taken at your own pace.
SQL Server Maintenance Plans – This course will teach you all about SQL Server’s maintenance plans and what they can (and can’t) do. The course can be found here at Udemy.com. It includes demos and sample scripts. Use this link (or enter the coupon code 15OFFBLOG) and get a 15% discount! This course is almost 2 hours long and can be taken at your own pace.
Sample videos from my courses can be found on my YouTube channel here.
“Shaun Stuart is the best MS SQL DBA that I have ever had the honor and privilege to work with and get to know. He has fantastic communication skills that allow him explain technical issues in a manner that presents the subject in great detail while ensuring that the message is understandable by all. He is an out of the box thinker that has developed many creative solutions that really helped us improve the management of our databases and SQL Servers.” – Jim Moulton, Director of IT & PMO, eInstruction
“Shaun did an impeccable job… He’s definitely not just a DBA. He’s a quiet guy, and I would highly recommend him.” -David Favier, Manager, IT Solutions, Rainbow Studios
“I have taken all of the courses that Shaun has offered thus far and can say without reservation that I have enjoyed his courses more than any of the others that I’ve taken. Shaun has a way of presenting complex information in a clear and concise manner that I appreciate very much. I will definitely be keeping my eyes open for more courses from Shaun.” – K.S.
“Two years ago, my employer sent me to a 5-day SQL Server Administration class at a “Microsoft partner” training vendor costing several thousand dollars. While that class is/was more oriented towards Microsoft certification exam 70-462, this course does a better job of getting you up to speed quickly as a new SQL Server DBA, and at a tiny fraction of the price. Shaun Stuart does a great job covering the essentials of what you should know in several hours of videos, which is impressive.” -J.W.
“Excellent Course for someone who is coming from Oracle background and new to SQL Server. Highly recommended!!!” – P.B.
“The presentation of the video is very clear,Shaun has a very clear voice and very humble and amazing while speaking or explaining about Data compression. Guys rather than going through ten books to acquire the knowledge on Data Compression why not go for a video course where everything is explained in a sequential manner giving the maximum knowledge and explained within a minimum time frame.” – V.K.G.