I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...
2019-05-29 (first published: 2019-05-15)
2,115 reads
In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...
2019-05-28 (first published: 2019-05-15)
314 reads
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
16 reads
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
342 reads
In order to vote you have to have filled out your profile on PASS.org. Rather than guess, take a minute to login and go to https://www.pass.org/MYPASS.aspx?viewctl=MyProfile. If you’re eligible...
2019-05-14
11 reads
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-14
16 reads
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-14
9 reads
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-31 (first published: 2019-05-14)
263 reads
This month we have a very interesting topic from Matthew McGiffen. He gets back to the roots of the party with code by asking a question on puzzles. It’s...
2019-05-14
45 reads
I recently realized that I’m in the early stages of burnout. This isn’t an unfamiliar place for me, but it is new for me to recognize the early signs...
2019-05-14
17 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers