For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...
2020-07-28 (first published: 2020-07-16)
737 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
10 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
20 reads
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
23 reads
An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at...
2020-07-15
224 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-15
16 reads
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-07-23 (first published: 2020-07-15)
469 reads
No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...
2020-07-24 (first published: 2020-07-15)
643 reads
It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...
2020-07-23 (first published: 2020-07-15)
1,063 reads
I’ve now been printing surgical mask straps aka “Ear Savers” since April 5th. It has been a wild journey getting started and obtaining all the supplies needed such as...
2020-07-14
18 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