Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-05-17
16 reads
If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
2019-06-03 (first published: 2019-05-16)
1,003 reads
I realized yesterday I posted this quickly after testing only against SQL 2016 version. So I decided to also test against SQL 2014 and 2012 versions to make sure...
2019-05-16
72 reads
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event last week, the major announcements in the data platform and AI space were: Machine Learning...
2019-05-30 (first published: 2019-05-16)
317 reads
New Pluralsight Course – Managing the Kubernetes API Server and Pods
My new course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! Check out the trailer here or if you...
2019-05-16
14 reads
New Pluralsight Course – Managing the Kubernetes API Server and Pods My new course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! Check out the trailer here or if you...
2019-05-16
52 reads
Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are designed...
2019-06-03 (first published: 2019-05-16)
1,419 reads
The purpose of this query is to find identical duplicate non-clustered indexes i.e. indexes on same table with same columns in same order. If you have a need to...
2019-05-30 (first published: 2019-05-15)
889 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling...
2019-05-15
126 reads
Tuesday is the day when SQLDay starts. The doors are opened from 8am but the show begins with a keynote at 9am. This year the keynote talk was done...
2019-05-15
18 reads
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
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