Do You Know These Free Events?
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...
2012-04-23
708 reads
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...
2012-04-23
708 reads
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...
2012-04-19
1,502 reads
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,165 reads
There are a few design choices that can make your SSIS packages run super fast when loading data from table...
2012-04-10
5,036 reads
Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...
2012-03-16
839 reads
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,216 reads
Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and...
2012-03-09
729 reads
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you...
2012-03-06
1,841 reads
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
978 reads
Problem
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error...
2012-02-29
5,613 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
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
Comments posted to this topic are about the item New SQL Server 2022 Functions
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