Most of the writing about cloud latency and connection resiliency focuses on application developers. It's their connection pools that drain and their N+1 queries that explode. But data engineers running ETL pipelines against cloud endpoints had their own version of the same problem, and the failure modes
For most of my career before 2012, deploying a database schema change meant running a SQL script. Maybe you wrote it yourself. Maybe someone emailed it to you. Maybe you'd been collecting changes in a text file since the last release and you were about to run all
microsoft sql
Last time, we discussed three methods for inserting data into a destination table that has a recursive relationship. In this article we're going to cover how
SQL301
Earlier this week the question came up on how can we insert data into a table that has a hierarchical data structure. If you're not familiar with a hierarchical
career development
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.Jit Sequencer Aerotek
SQL301
This is the last article for my upcoming design patterns session. Today we're going to look into speeding up your queries by replacing cursors, a row-by-row
career development
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.Linux/novell/groupwise
SQL301
Up to this point in our design patterns sessions we've concentrated on removing duplicates from our troubled table. Now, let's look into preventing those
microsoft sql
Ok, today we wrap up our design patterns for removing duplicates from tables by turning to common table expressions (CTE's). When I start talking CTE's some
The Wright Brothers didn't invent flight. Plenty of people had been throwing themselves off cliffs and hilltops before Kitty Hawk. What they invented was controlled, repeatable, powered flight — a system for making it work every time. Henry Ford is the same story. Karl Benz patented the first true
On-prem SQL Server lives at a fixed IP address on a fixed machine. Your connection string points at a name or IP, and that name or IP resolves to the same hardware until someone physically moves something. This assumption is so reliable that most .NET developers in 2010 never thought
career development
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#dotNET #DEVELOPER in