SQL in the City Summits coming this spring
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and...
2019-03-27
154 reads
Blog Posts
SQL Server on Linux – feature change in Pacemaker 1.1.18
Heads up for SQL Server on Linux folks using availability groups and Pacemaker. Pacemaker 1.1.18 has been out for a while now, but it’s worth mentioning that there was...
2019-03-27
42 reads
Capture/Replay a Sample Workload on the Distributed Replay Utility
Part I: Capture a Workload Make a backup of the database(s) in question, as it will be necessary for the replay. Using the TSQL Replay template, fire up Profiler...
2019-03-26
115 reads
Joining on NULLs
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
22 reads
Joining on NULLs
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
21 reads
Joining on NULLs
It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...
2019-03-26
63 reads
Persisting databases with named volumes on Windows with docker compose
With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com I was reading his latest blog post Using...
2019-03-26
389 reads
Scalar UDF Inlining in SQL Server 2019 – Simpler functions
I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...
2019-03-26 (first published: 2019-03-11)
672 reads
Using Kubernetes Deployments for Updating SQL Server
In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this...
2019-03-26 (first published: 2019-03-12)
858 reads
An Experiment with Deadlocks
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
250 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers