Date formats change from country to country. This SQL in Sixty Seconds video shows two ways to display datetime in a specific format in SQL Server 2012.
SQL SERVER – Using RAND() in User Defined Functions (UDF)
Using RAND() in a user defined function throws Msg 443, invalid use of a side-effecting operator. Here is a simple workaround that lets a UDF use a random value.
SQL SERVER – Removing Leading Zeros From Column in Table
Most people ask how to keep leading zeros in SQL Server. This time a reader wanted to remove leading zeros and white space from a column, so here is a script.
Automating SQL Server Patching With PowerShell
Automating SQL Server Patching with PowerShell means staging a verified package, running Setup quietly, checking logs, and stopping on failure.
Restoring a TDE Protected Database on Another Server
Restore a TDE protected database on another SQL Server by moving its certificate and private key, then verify encryption state.
SQL SERVER – Rename Columnname or Tablename – SQL in Sixty Seconds #032 – Video
Picked the wrong name for a column or a table? This SQL in Sixty Seconds video shows how to rename a column and a table in SQL Server.
Storing UTC and Local Time Side by Side
Store UTC and local time consistently, preserve offsets, handle daylight saving changes, and filter timestamps with clear boundaries.