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)
453 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)
406 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)
608 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,717 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,414 reads
Blogs
Reviewing 2019 Career Goals
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Forums
Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)
Hi I have SQL Server FCI running in my DC site following are cluster...
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE
Hello experts, A client is reporting the following error when his application tries to...
Connectivity to Oracle 12.2 instance via OLE DB ?
I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults....
Ask SSC