Ending My Time as PASS President
With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....
2020-01-10 (first published: 2019-12-30)
449 reads
The Scary DBA
Fritchey Family Christmas Movies
MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....
2019-12-23
11 reads
Why Don’t People Use Columnstore Indexes?
I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why. Now, before I explain my answer, please, let me...
2020-01-01 (first published: 2019-12-16)
1,367 reads
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
331 reads
State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....
2019-12-06
45 reads
Tracking CPU Use Over Time
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
656 reads
Containers: Upgrading SQL Server from 2017 to 2019 RTM
Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...
2019-12-05 (first published: 2019-11-25)
314 reads
Your First Jupyter Notebook
In April, I said I was going to start learning Jupyter Notebooks. It’s November. Let’s get going with your first Jupyter Notebook. A quick aside before we start. I...
2019-11-28 (first published: 2019-11-19)
702 reads
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...
2019-11-20 (first published: 2019-11-11)
615 reads
You Are A Coder
So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...
2019-11-04
35 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