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
Shannon Lowder
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
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
sql
70-450: Complete!
After another month of studying, I finally took the 70-450. I'm happy to say I passed! I did learn one thing from the exam: I should spend more time with
Certification
70-450: IO Throughput
Today I'm getting back to studying for the 70-450. To follow up the last few articles I'm still in the first bullet point from the official guide. Designing a