SQL Server 2012 (“Denali”): SSIS Logging
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,217 reads
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,217 reads
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
945 reads
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,009 reads
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
595 reads
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,954 reads
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,067 reads
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,565 reads
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,089 reads
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,829 reads
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,947 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item 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; GOSee possible answers