DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,255 reads
String Function
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
874 reads
Blogs
SQL Server Containers Are Boring
Not really, but sort of. The beauty of containers, at least in a dev/test...
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you...
It’s interesting how an OR short circuits.
I recently did a post on the case expression short circuting and received a...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Always on AG and SQL Upgrade
Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...
Migration from server to server
I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...
Ask SSC