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.
2008-02-04
9,107 reads
Articles
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.
2008-02-04 (first published: 2007-02-13)
12,978 reads
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.
2008-02-04
40 reads
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.
2008-02-04
47 reads
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.
2008-02-04
50 reads
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.
2008-02-04
2,802 reads
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.
2008-02-04
4,540 reads
More Layers - iPod
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
37 reads
More Layers - MP3
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
38 reads
More Layers - WMV
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
41 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
Alamat Kontak Bank BCA KCP Sabang Telp:08218154392
WA CS (08218154392) Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng,...
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Alamat Kontak Bank BCA KCU RUNGKUT Telp:08218154392
WA CS (08218154392) Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers