Developer training starts the day school ends. A degree opens the workshop door, but the craft is learned at the bench, with real code, real mistakes and someone beside you. Here is why companies and developers should both care.
SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
My SEQUENCE puzzle part 3 involves some service related steps, so run it only on a test machine, never on production. Can you guess the next value?
SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 2 of fun with SEQUENCE: the same script as before, but without MINVALUE. Now guess the next value SQL Server 2012 returns after the cycle.
SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?
SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117
NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.
Standard Reports in SSMS: SQL in Sixty Seconds #016
Standard Reports in SSMS put activity, space and performance information a few clicks away. This post adds T-SQL queries for the same questions, tested on SQL Server 2025, and shows the permission error a reader without VIEW SERVER PERFORMANCE STATE receives.
SQL SERVER – SmallDateTime and Precision – A Continuous Confusion
SmallDateTime and precision confuse a lot of people. I explain what the precision really is, using a Facebook question from Raghavendra.