Extended Events: Live Data Explorer, Grouping
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
93 reads
The Scary DBA
Containers and DevOps
Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...
2020-03-27 (first published: 2020-03-20)
300 reads
Missing #SQLFamily? Check This Out.
I am an introvert. Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my...
2020-03-19
14 reads
Extended Events: Live Data Explorer, Getting Started
One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...
2020-03-24 (first published: 2020-03-16)
252 reads
Extended Events: system_health and a Long Running Query
Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...
2020-03-16 (first published: 2020-03-09)
559 reads
A Rose By Any Other Name
There is only one kind of execution plan within SQL Server. I’ve said this several times on this blog. Now, I’d like you to go and read this excellent...
2020-03-11 (first published: 2020-03-03)
326 reads
Query Store, Plan Forcing, and DROP/CREATE
I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...
2020-03-09 (first published: 2020-03-02)
406 reads
Are You Still Worried About Data in the Cloud?
There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if...
2020-03-03 (first published: 2020-02-27)
555 reads
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...
2020-02-24
27 reads
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...
2020-02-24
55 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...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
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