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.
Tame Those Strings! Part 10 - Finding Carriage Returns
Expanding on his series of string manipulation in T-SQL, Steve Jones takes a look at how you go about removing those unseen characters from your strings.
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.
More Layers - iPod
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers