If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
680 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
11 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
35 reads
I’m giving another webcast through MSSQLTips.com. This one is on May 9, 2019, at 3 PM EDT. It’s called Auditing SQL Server from the Ground Up. You can register...
2019-05-01
52 reads
Deadlocks are usually detected and resolved automatically by SQL Server by killing one of the SPIDs involved in it. You may have an alert setup to notify you and/or users...
2019-05-14 (first published: 2019-05-01)
556 reads
As you may all know, having up to date index statistics is the key to make sure the query optimizer can choose the most optimal execution plan for any...
2019-05-01
181 reads
I have a shorter post this week, but I reckon it’s an interesting story. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server...
2019-05-01
57 reads
Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
787 reads
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...
2019-05-10 (first published: 2019-05-01)
156 reads
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
30 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