A change in date format shows up when you apply LEFT to GETDATE: the date goes from year first to month name first. This puzzle explains the implicit conversion behind it, how language settings change the text, and how to get the date you want on purpose.
SQL SERVER – Understanding How to Play With Row Constructor
A code review surprised me with an unusual use of the Row Constructor. Here is what the code did and how you can play with row constructors yourself.
SQL SERVER – Find Week of the Year Using DatePart Function
The DATEPART function returns a week number according to its week definition. I choose that convention before using calendar logic.
SQL SERVER – Puzzle – Solve Splitting Strings Puzzle
A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
MySQL – LEAST and GREATEST Comparison Operators
Comparing values across many columns is a common chore. Here is how the MySQL LEAST and GREATEST comparison operators find the smallest and largest value.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server you get the number of rows affected with @@ROWCOUNT. In MySQL, you can find the total number of rows with FOUND_ROWS().