Farewell Brook Ranne
For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29,...
2014-04-15
682 reads
Andy Warren
SQLServerCentral Editorial: Doing What It Takes To Get The Job Done
I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to...
2014-04-15
435 reads
Writing a Question Of The Day–More Notes
Today I wrote another question based on an error message. I included the error message in the question this time...
2014-04-15
479 reads
It’s Not All About The Keys–Question Of The Day
My latest question is live today, called It’s Not All About The Keys. It’s a three pointer, if score matters...
2014-04-14
431 reads
2014-04-14
2,253 reads
Quarterly Goals
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
526 reads
Simple And Amusing Question Of The Day
I was working on a script today to check the range of some values and trying to take the time...
2014-04-11
569 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
561 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
497 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
596 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