2024-10-14
529 reads
String Function
A Beginner’s Guide to SQL String Functions
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
2019-12-18
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)
3,191 reads
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)
1,055 reads
Blogs
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Forums
Using Heaps
Comments posted to this topic are about the item Using Heaps
Shades and Reflecting on SQLBits and the Bright Future of Data
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers