All 14 new SQL Server 2012 Functions in one quick guide, from TRY_CONVERT and PARSE to DATEFROMPARTS and CHOOSE, each linked to my post and Books Online.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
A quick introduction to the EOMONTH function in SQL Server Denali: get the last day of the month for a date, one of seven new date and time functions.
SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()
SQL Server 2012 adds seven new datetime functions, such as DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH. A quick look at building dates from their parts.
Surrogate Keys and Natural Keys
Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.
Moving Averages in T-SQL
Moving averages in T-SQL use ROWS BETWEEN for rolling windows, but date gaps and duplicate dates decide what the result actually means.
SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction
A quick introduction to the FORMAT function in SQL Server Denali: locale-aware formatting of dates and numbers, built on the .NET Framework and CLR.
SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction
SQL Server 2012 adds the String Function CONCAT(), which joins two or more values into one string. Examples show how it handles numbers, dates and NULLs.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.