Query Monitoring and the GDPR
I’ve been reading the General Data Protection Regulation (GDPR) and discussing the ramifications of the beginning of enforcement with lots...
2018-03-28 (first published: 2018-03-19)
2,770 reads
The Scary DBA
Execution Plans and the GDPR
What? Execution plans and the GDPR? Is this it? Have I completely lost it? Well, no, not on this topic,...
2018-03-12
837 reads
Every Single Execution Plan is an Estimated Plan
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.
Where...
2018-03-14 (first published: 2018-03-05)
1,810 reads
YouTube Channel Update
Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...
2018-03-02
312 reads
Precons in Richmond, Philadelphia and New York
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...
2018-03-09 (first published: 2018-02-28)
1,663 reads
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,133 reads
GDPR: Your Hair Is Not On Fire
Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...
2018-02-26
473 reads
Wait Statistics on a Query
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,683 reads
Youtube Channel Update
Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...
2018-01-29
282 reads
You Need a New Hobby
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
293 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers