SQL 2016 – Clone Database with Query Store
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016...
2017-03-31 (first published: 2017-03-20)
2,369 reads
Blog Posts
SSIS Catalog Logging Tables
Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging...
2017-03-31
890 reads
SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,525 reads
Thoughts on PASS Summit Speaker Selection Changes
Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from...
2017-03-31
815 reads
Applying SQL Service Pack on Encrypted Drives
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
710 reads
Basics of Probability
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,517 reads
Check Those Settings
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,287 reads
Looking Back at the SQL Clone Launch(es)
Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along...
2017-03-30
1,048 reads
Your physical memory configuration can slow down your servers
Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on...
2017-03-30
717 reads
A First Look At Normalization
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
322 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