DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
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.
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
User Mapping Issues
I have a server that is version 12.0.6214.1 and here is my issue. I...
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
Ask SSC