WASD

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

One of the things I love most about Windows Azure SQL Database (WASD) is that you don’t have many options when it comes to performance tuning. WASD makes you focus on code and design in order to maximize performance. I would estimate that 98% of all performance issues are due to sub-optimal code and database design(…)

How To Avoid Butchering Your Windows Azure SQL Database Designs

How To Avoid Butchering Your Windows Azure SQL Database Designs

I met a man once who told me how he wanted to be a butcher but his hands weren’t steady enough. So, he decided to become a dentist instead. The man, of course, was my dentist. And he said those words as he started up his drill. Good times. I often think about that dentist(…)

Live Webinar Next Week! – Expert Database Design Tips for SQL Server and Azure

Live Webinar Next Week! – Expert Database Design Tips for SQL Server and Azure

Next week I am taking part in a webinar along with Karen Lopez where we will discuss database design tips for SQL Server and Windows Azure SQL Database. This is not the debate format we have done previously, this is meant to be more of a discussion format. I’ve spent a good chunk of time(…)

Windows Azure SQL Database Strategies

Windows Azure SQL Database Strategies

I’ve been working with Windows Azure SQL Database (WASD) on and off for about three years. This past year I’ve been a bit more involved. I did the technical review of Pro SQL Database for Windows Azure last year. I also delivered a precon seminar along with Dandy Weyn (blog | @ilikesql), Grant Fritchey (blog | @gfritchey) and(…)

Why Windows Azure SQL Database May Be Right For You

Why Windows Azure SQL Database May Be Right For You

Grande. Bold. No room. It’s my standard order when at Starbucks. Despite there being thousands of ways to have my coffee prepared I prefer the simplest. It’s probably why I enjoy working with Windows Azure SQL Database (WASD) so much. The number of configuration options we have with WASD is limited. By limiting the options(…)

Top 7 Things You Want To Do In Windows Azure SQL Database, But Can’t

Top 7 Things You Want To Do In Windows Azure SQL Database, But Can’t

I’m a huge fan of Windows Azure SQL Database (WASD), I really am. I know there are other fans out there as well. With each passing day we help transport more of the old-school DBAs into the 21st century by showing them what Azure has to offer. Unfortunately there are always a few folks that(…)

Load More