2024-10-14
532 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,302 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,068 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Gajah Mada Tegal Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Gajah Mada. 41A & 41B, Mintaragen, Kec. Tegal Tim., Kota Tegal, Jawa...
BCA KCP Pasar Cibinong No.Telp:087757645171
Whatsapp:087757645171 Ruko Mayor Oking Blok B. 1, Jl. Mayor Oking No. 35, RT 002/001,...
BCA KCP Kreo Ciledug No.telp:083834809483
Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec. Larangan, Kota Tangerang, Banten...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers