SQL301
De-duping by temp table
Last time, we learned that manually removing duplicate rows from a table could be a long and manual process. Especially when you have as many duplicates as I
Latest
SQL301
Manually Deleting Stinks!
Go ahead and set up your TroubledTable by running the Create Troubled Table T-SQl Script. Now take a look at your duplicate rows. SELECT email, COUNT(*) FROM
SQL301
Design Patterns Session
On February 6, I'm going to tele-present a session on T-SQL design patterns to the Brazil SQL Server Users Group. During this session I'll cover three common
career development
New Job Postings for 12/20
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.Sr Business Objects Xir3
sqlmcm
How Much Logging Goes on for a Clustered Index Drop?
A week back @fatherjack put out a question on #sqlhelp that immediately drew my curiousity. He wanted to know how much his log file would grow if he dropped his
The Latency Budget: What Changes When Your Database Is 12ms Away Instead of 0.2ms
Here's a concrete number: moving a SQL Server database from a LAN to Azure SQL in the same region typically added 10–30ms of round-trip latency per query. That sounds small. Let me show you what it actually costs in an application that wasn't designed for
career development
New Job Postings for 12/15
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.Sr #dotNET
personal
Lessons Learned
I recently had a epic failure on my workstation. It was bad. My machine simply stopped working, and when I rebooted everything looked fine, until I saw it blue
New Site
I'd like to welcome you to my new site, ShannonLowder.com. I've moving all of my content to this site to present a more professional image. My old site,
microsoft sql
Who Shrank Roger Rabbit
It all started Thursday afternoon, about 1500. I was walking back from Starbucks with my afternoon pick-me-up, when a co-worker mentioned we have this process
sqlmcm
88-970: My Study Guide
Since I know I'm going to go for the SQL MCM next year, I'm going to start collecting all of my study materials here, on my blog. Hopefully that way it can jump
Writing Code for a Network You Don't Own: Retry Policies and Connection Resiliency
SQL Azure will drop your connection. Not because something is wrong — because it's a shared service running on infrastructure that moves, fails, patches, and recovers automatically. If your application isn't written to handle transient connection failures, you're going to have a bad time in