Drop It Like It’s Hot (Part 2 of the Rename/Drop Objects Process)
Dread the drop no more! Part 2 of the rename/drop process.
2019-05-06 (first published: 2019-04-22)
460 reads
Can a Certificate’s Private Key be Imported / Restored From a Binary Literal / Hex Bytes ?
(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...
2019-05-03 (first published: 2019-04-22)
540 reads
Enable a Named Instance to Connect on 1433
My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I...
2019-04-26 (first published: 2019-04-22)
2,001 reads
Data Breaches: All Your Fault
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-05-03 (first published: 2019-04-22)
506 reads
Power BI Governance 101 at SQL Saturday 820 in Jacksonville, Florida on May 4
Coming up in just a couple of weeks, I’ll be presenting my session, Power BI Governance 101, at SQL Saturday #820 in Jacksonville, Florida on May 4th. The event...
2019-04-22
46 reads
Shrinking a large database with limited outage windows
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
2019-05-06 (first published: 2019-04-22)
1,612 reads
Using the same Azure DevOps build steps for Terraform with different Pipelines with Task Groups to build an Azure Linux SQL VM
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build...
2019-05-02 (first published: 2019-04-22)
459 reads
So, my first SQL Saturday presentation had some issues
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
6 reads
So, my first SQL Saturday presentation had some issues
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
10 reads
STEP-BY-STEP: HOW TO CONFIGURE A SQL SERVER 2008 R2 FAILOVER CLUSTER INSTANCE ON WINDOWS SERVER 2008 R2 IN AZURE
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL...
2019-05-02 (first published: 2019-04-19)
1,041 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