Data Cleansing with the SSIS Data Flow
A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.
2009-10-21 (first published: 2009-10-19)
5,648 reads
Articles
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
2009-10-21
1,724 reads
Using The Transfer Jobs Task in SQL Server Integration Services
Database Administrators can use the Transfer Jobs Task to transfer one or more SQL Server Agent Jobs between different SQL Server instances
2009-10-21
2,013 reads
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
2009-10-20
528 reads
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
2009-10-20
131 reads
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
2009-10-20
525 reads
Kimball University: Six Key Decisions for ETL Architectures
Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.
2009-10-20
4,926 reads
SQL Server Consolidation
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the consolidation iceberg - and it might not actually save you as much as you think. Thomas LaRock takes us deeper.
2009-10-20
1,968 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-20
2,666 reads
Using XML to pass and return values to procs
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
2009-10-19
10,409 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers