SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...
2016-04-06
16,345 reads
Koen Verbeeck
SQLSaturday Belgium: slidedeck
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...
2016-03-24
495 reads
Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,088 reads
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
811 reads
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its...
2016-02-24
685 reads
Speaking at the first Belgian SQLSaturday!
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
494 reads
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...
2016-02-19 (first published: 2016-02-12)
1,718 reads
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
612 reads
Book Review – Expert Performance Indexing
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in...
2016-02-11 (first published: 2016-02-02)
2,069 reads
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
854 reads
Blogs
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...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
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
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
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