I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.
SQL SERVER – Security Risk of Public Role – Very Little
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.Â
SQL SERVER – PRINT Statement and Format of Date Datatype
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
Microsoft SQL Server and Ransomware Viruses
What if your files got affected by this plague (Ransomware)? It is unlikely that you can decrypt the files, even after paying a ransom.
SQL SERVER – Building Date and Time with DATETIMEFROMPARTS()
Today we will have very simple learning about Building Date and Time with DATETIMEFROMPARTS(). We will build the DateTime using a function.
SQL SERVER – How to Shrink tempDB Database?
In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.