SQL Lunch #32: SSIS Design Patterns, with Andy Leonard
Don't miss SQL Server MVP Andy Leonard on the SQL Lunch, Monday, October 11th.
#32-SSIS Design Patterns 1c: Variables, Events, and...
2010-10-08
796 reads
Patrick LeBlanc
Speaking at the Houston Techfest
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes...
2010-10-07
402 reads
SQL Lunch: Change of Schedule
There has been a slight change to this weeks SQL Lunch meeting. Our scheduled speaker cannot present this week, therefore...
2010-10-05
411 reads
SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
420 reads
Maintain Change Data Capture Configuration when restoring a database
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,337 reads
SQL Saturday #57 (Houston) Call for Speakers and Registration is Open!!
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
711 reads
SSIS: Assign a value to Variable using Dataflow Script task
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
522 reads
Where do you get your motivation and drive?
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
648 reads
MDX Puzzle #7 - Solution
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
595 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers