Function to pad Bigint with leading zeros or other single characters
Function to pad bigint with leading 0's or other single character
2019-10-31 (first published: 2019-10-23)
416 reads
Shane Clarke
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
391 reads
Function to Round or Truncate DateTime
This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value
2017-05-31 (first published: 2017-05-23)
588 reads
Function to calculate and return age in text to closest minute between
Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes
2016-08-12 (first published: 2012-05-17)
1,716 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
1,354 reads
Blogs
Schema evolution solved using Delta Lake & Databricks
By Gerard
Don’t know about you, but one of my least favourite data pipeline errors is...
Understanding Azure Geo-Redundant Storage
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
Prompt in ADS
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
Forums
Updating Statistics
Comments posted to this topic are about the item Updating Statistics
SQL Server performance issue after an upgrade
Comments posted to this topic are about the item SQL Server performance issue after...
The Evolving DBA
Comments posted to this topic are about the item The Evolving DBA
Ask SSC