After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112
Question: Why to Use SQL Server Configuration Manager Over Services applet (services.msc)?
SQL SERVER 2016 – DBCC Command Enhancement with MAXDOP
When you want to be successful, you need to run alone and fast. But if you want to run longer, you want to run together. I have personally seen multiple instances where this statement holds true to every word. When working with customers and in various consulting engagements, I have seen it is not enough to just solve the problem. It is important to enable the team working on the project and make them aware of the reasons why it did happen in the first place. I always felt the art of working together will take us a long way. Even in performance engagements, I try to get the team involved as I go through the process of solving their problems. Let us learn in this blog post DBCC Command Enhancement with MAXDOP.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
I have observed this question in the interview question few days ago. I had a fun time to see candidates failing to answer this question. The most common answer candidate gave us was that they will right click on the server and see the properties. Well, that option will not give all the details which actual question intended. Let us see the question:
Question: What is the best way to see all the options set for your SQL Server programmatically?
Answer: