Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve.
SQL SERVER – ISNUMERIC Function and Interesting Result
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
SQL SERVER – Performance and Recompiling Query – Summary
I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)
I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.
How to Copy Files in SQL Server? – Interview Question of the Week #257
Question: How to Copy Files in SQL Server?
Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.
Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple: