Laptop Cattle
I traveled to Cambridge recently for some meetings at Redgate Software and to attend SQL Bits. I arrived on Tuesday,...
2017-04-06
725 reads
Blog Posts
Murder Data
The Murder Accountability Project is worth a look. It’s a reminder that gathering good data is hard, but once you...
2017-04-06
500 reads
Using Pester with Get-DbaLastGoodCheckDb from dbatools
In my last post I showed Get-DbaLastGoodCheckDb from dbatools. This module is a community based project written by excellent, brilliant...
2017-04-06
544 reads
[Video] JSON Usage and Performance in SQL Server 2016
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
10 reads
ADO Connection Resiliency
It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection...
2017-04-05
674 reads
Among Giants
Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field. I never once...
2017-04-05
335 reads
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
437 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
176 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
473 reads
Creating a list of random numbers
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,348 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