When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,573 reads
The Scary DBA
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,933 reads
YouTube Channel Update: 27 April 2018
Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...
2018-04-27
467 reads
Presentation Tools
Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...
2018-04-23
294 reads
Execution Plan Shortcoming in Extended Events
I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...
2018-04-26 (first published: 2018-04-16)
1,568 reads
Privacy and Protection, By Design
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
429 reads
GDPR, Database Backups, and the Right to be Forgotten
I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...
2018-04-20 (first published: 2018-04-09)
3,417 reads
Buggy Whips 2.0
I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...
2018-04-02
271 reads
YouTube Channel Update: March 30, 2018
Hey everyone!
Here’s the latest stuff on my new YouTube Channel. Please let me know if these videos are helpful. Also,...
2018-03-30
387 reads
Query Store and Automated Cleanup
Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...
2018-03-26
444 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