How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165

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

Declarative Programming: Is It A Real Thing?

By Federico Pereiro – Freelance Software Engineer @ TopTal Declarative programming is, currently, the dominant paradigm of an extensive and diverse set of domains such as databases, templating and configuration management. In a nutshell, declarative programming consists of instructing a program on what needs Continue reading Declarative Programming: Is It A Real Thing?

SQL SERVER – Creating Temporary and Global Temporary Stored Procedures

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

SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.

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.

Released: Public Preview for SQL Server Management Packs Update (7.0.3.0)

We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make Continue reading Released: Public Preview for SQL Server Management Packs Update (7.0.3.0)