Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
495 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
Speaking at SQLSaturday #33 in Charlotte
I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather...
2010-03-04
560 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
331 reads
T-SQL Tuesday #3: Database Relationships
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
446 reads
Speaking about Indexing
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is...
2010-02-08
338 reads
Speaking at SQLSaturday #30 in Richmond
I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather...
2010-01-25
351 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
407 reads
Service Broker Basics - Part Deux
Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that...
2010-01-12
470 reads
Service Broker Basics
I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not...
2010-01-06
530 reads
[OT] Happy New Year
Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes...
2009-12-31
1,336 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