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
401 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
410 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
419 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,336 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
710 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,750 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
521 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
647 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
594 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers