Find identical duplicate indexes - Revised
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
Microsoft Build event announcements
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
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
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
Turning a Corporate Color Palette into a Data Visualization Color Palette
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
Find identical duplicate indexes
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
Proposed SQL Server defaults: max server memory
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
SQLDay 2019 – Day 2
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
Moving to Serverless for Azure SQL DB
After the announcement of Serveless Azure SQL Datbase at //build/, I decided to give it a try. I have some Basic databases, so what would Serverless mean for me?...
2019-05-31 (first published: 2019-05-15)
930 reads
Scripting SQL Server objects with dbatools – Beyond default options
Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...
2019-05-29 (first published: 2019-05-15)
2,189 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
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