A quick DATEADD Function quiz: guess what adding one month to a late January date returns before you run it in SSMS. Date math has a few pitfalls.
SQL SERVER – Puzzle – Why Divide by Zero Error
Why does SELECT 10000/(17/17/17) return a divide by zero error? A new puzzle, similar to my decimal rounding one but with a different approach.
SQL SERVER – Puzzle – Why Decimal is Rounded Up?
Why decimal is rounded up in one script and not in the other when both divide 10000 by 17? Try this holiday puzzle before you read the comments.
SQL SERVER – A Question on SSMS Prompt about Connect to Server
A fun Sunday question for you about the Connect to Server prompt in SSMS and when it shows the Azure Storage option. Do you know the answer?
SQL SERVER – Contest Winner – What Next on SQL in Sixty Seconds – Poll Result
The poll for the next SQL in Sixty Seconds videos is closed, and most readers want performance tuning. Here are the results and the contest winner.
SQL Puzzle – A Quick Fun with Bit Wise Operator
A quick Friday SQL puzzle on the Bit Wise Operator: SELECT 10 & 10 returns 10, so why do 10 & 0 and 1 & 100 both return zero?
SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?
A reader asks why you need the -Force flag to stop services with PowerShell but not to start them. I do not know the answer, so I am asking you.