24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for...
2014-08-07
1,250 reads
James Serra's Blog
SQL Server Agent job steps vs SSIS
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL). ...
2014-07-22
1,315 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,207 reads
PASS BA Conference 2014: Sessions Recordings Now Available
All PASS Business Analytics Conference 2014 recordings are now available. If you purchased the online sessions, to view, log on to your myPASS...
2014-06-19
874 reads
Presentation slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday. The abstract for my session is below...
2014-05-25
994 reads
Presentation slides for Houston SQLSaturday
Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info). Here are the abstracts and PowerPoint links:
Best...
2014-05-12
918 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics conference. The abstract is below. I...
2014-05-09
934 reads
SQLSaturday in Houston
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
781 reads
Hadoop and Data Warehouses
I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution. Hadoop should...
2014-05-12 (first published: 2014-05-06)
5,344 reads
Presentation Slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas. The abstract is below. Great...
2014-05-04
1,150 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