Exotic Joins in T-SQL and How They Translate in SSIS
This is a short article on how to translate an exotic join or range lookup in SSIS (Integration Services) from Nick Maroudas.
More Layers
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
Compensation - iPod
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
Compensation - MP3
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
Compensation - WMV
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
Data Access Tracing in SQL Server 2005
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine.
Determining SQL Server database storage requirements
Determine accurate storage requirements for a SQL Server database with these methods. Calculate how to set storage requirements for a database application.
Introduction to SSIS in SQL Server 2005
DTS was one of the true innovations in SQL Server 7. SQL Server 2000 greatly enhanced this tool and SQL Server 2005 makes it truly a programming environment, well beyond the ETL functions of DTS in SQL Server 2000. New author Vinod Kumar gives a brief introduction to this new environment.
More Layers - iPod
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers