Running SQL Server on my Mac with Docker
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-14 (first published: 2020-05-01)
409 reads
Daily Coping 1 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-01
24 reads
Learner’s Guide to SQL Server Query Tuning
Following on from my Learner’s Guide to SQL Server Performance Triage, I’m tackling Query Tuning. In this guide, I’m experimenting with an outline style rather than expanding each paragraph....
2020-05-18 (first published: 2020-05-01)
1,005 reads
Query Store capture note: All does not mean what you think it means
As many of you know, Query Store is a wonderful tool for identifying query regressions, which in turn makes it an equally wonderful tool for migrations involving an upgrade...
2020-04-30
31 reads
Azure Data Factory trigger tip
This tip comes from my DBA days working with SQL Agent Job schedules. If you’ve ever worked on a server where many people created job schedules you’ll know exactly...
2020-05-19 (first published: 2020-04-30)
328 reads
Clumio’s Rapid Recovery is amazing for SQL Server
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
383 reads
Daily Coping 30 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-30
24 reads
SSMS Quick Tip
Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...
2020-05-14 (first published: 2020-04-30)
994 reads
Upcoming Webinar – SQL Server Business Continuity – May 21
I’m proud to announce a new webinar that I’ll be presenting at 1pm Eastern on Thursday, May 21st, in conjunction with MSSQLTips and SIOS called “SQL Server Business Continuity...
2020-05-12 (first published: 2020-04-29)
129 reads
Understand SQL Server Editions and Components
SQL Server editions:- · Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the...
2020-04-29
352 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
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...
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