Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can find the answers easily. Let us learn about SQL Server Continue reading SQL SERVER – How to Download SQL Server Native Client?
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
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?
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 (220.127.116.11)
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