There are many applications which are developed using an older version of SQL Server. As there are new releases happening, there are features, command, and syntax which are marked as deprecated features and might get removed in future version of Continue reading How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
One question I always ask all of my customers before I start Comprehensive Database Performance Health Check is that if they have taken backup of their server. The answer to this question honestly does not matter to me during consultancy Continue reading SQL SERVER – Identify Version of SQL Server from Backup File
During recent Comprehensive Database Performance Health Check, I had a very interesting situation I encountered where we found a stored procedure which was a root cause of the slowness. What we needed to do is to change the code and test Continue reading SQL SERVER – Creating Temporary and Global Temporary Stored Procedures
The increasing size of SQL Server databases, alongside the growing complexity of SQL Server estates, is making more organizations realize the need for a tool that enables proactive monitoring. Let us try to answer a question – What is the ROI Continue reading What is the ROI of a SQL Server Monitoring Tool?
One of my clients was trying to recover from a disaster and wanted to attach the MDF and LDF files. While trying to do that, they encountered an error. In this blog we would learn about how to fix the Continue reading SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.
There are many different datetime related functions such as DAY, MONTH, YEAR, DATEDIFF, etc available in SQL Server. For example, YEAR function can be used to extract year value from a date. Let me show you a simple example DECLARE Continue reading SQL SERVER – Puzzle – How Does YEAR Function Work?
We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (firstname.lastname@example.org)! We appreciate the time and effort you spend on these previews which make Continue reading Released: Public Preview for SQL Server Management Packs Update (22.214.171.124)
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan. Where Do You Get Execution Plans? There are a lot of sources for execution plans. You can capture them using Continue reading Every Single Execution Plan is an Estimated Plan
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I get the opportunity to do a precon at a SQLSaturday event. Well, I’ve got three coming up. All three are Continue reading Precons in Richmond, Philadelphia and New York
The 4th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.To learn more about the release Continue reading Cumulative Update #4 for SQL Server 2017 RTM