Question: How to Create Primary Key Without ANY Index?
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
In the last puzzle, user had to write the shortest code to produce 0. I have received around 700 valid answers and while reading through the answers, I had a blast. I personally learned quite a lot from just administrating the quiz. Since that puzzle, I have received quite a few emails requesting to come up with next puzzle.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
Question: How to Enforce Password Policy of Windows to SQL Server?
SQL SERVER – How to Enable Backup Compression On by Default
In this blog post we will discuss how to Enable Backup Compression on by default.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
What are Ghost Records and How to Clean Them Up?
I loved this question when I received it last week in my SQL Server Performance Tuning Practical Workshop.
SQL SERVER – Select Unique Data From a Column Exist in Two Different Table
If you have not understood what I am going to talk in this blog post by just reading the title, I think you are a normal human like me. Just the other day I received an email from a blog reader with subject line as “Select Unique Data From a Column Exist in Two Different Table”.
SQL SERVER – Simple Explanation of AT TIME ZONE Feature
Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit slow. However, let us understand how this function really works in a few simple words.Â