{"id":2637,"date":"2013-10-09T13:12:13","date_gmt":"2013-10-09T20:12:13","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/kimberly\/?p=2637"},"modified":"2013-10-09T14:15:57","modified_gmt":"2013-10-09T21:15:57","slug":"physical-database-design-considerations","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/physical-database-design-considerations\/","title":{"rendered":"Physical Database Design Considerations and a bit of freediving"},"content":{"rendered":"

Something that always amazes me is that people think SQL Server is easy. And, I’d like to (at least partially) blame Microsoft marketing for that. Over the years they’ve propagated this notion of SQL Server being a simplified database environment even “zero-administration” at one point (anyone remember that marketing nightmare?). And, while there are MANY things that are simplified – it’s by no means SIMPLE. And, simply put, it’s just like EVERY OTHER TOOL you’ve ever used. If you want to use it effectively, you need to learn how to use it properly.<\/strong><\/p>\n

\"Photo<\/a>
Photo (of me w\/some beautiful mantas) taken by Deron Verbeck<\/strong> of WHOA<\/strong> (www.wild-hawaii.com<\/a>). They’re a group with whom I always go out when I’m in Kona, HI. If you want to see marine wildlife and get out on the water with very knowledgeable folks (on a fantastic boat) – this is the company to pick!<\/figcaption><\/figure>\n

Over the weekend I took a class in freediving (like snorkeling, but my goal is to dive\/photograph animals [mostly cetaceans – who really<\/em> don’t like bubbles] “on a single breath”). But, it’s not just about holding your breath. There are breathing techniques for slowing down your heart rate and making yourself more comfortable in the water. There are skills for coming back up out of the water after a long breath hold (it’s called recovery breathing<\/em> and it’s meant to help reduce\/prevent shallow water black-out [Samba] and full black-outs). And, there’s a HUGE emphasis on safety\/buddy dives.\u00a0Even with just a two-day class, I was diving deeper and holding my breath longer than I ever thought possible. I believe in classes. I believe in safety. I believe that you can never stop learning. I believe in IMMERSION (in more ways than one :).<\/p>\n

My main point: It’s always better to know how to do something properly EARLY so that you can avoid problems later.<\/strong> Luckily, with SQL Server, it’s [usually] not that critical\/dangerous (but, what about hospital systems, transit systems, safety\/911 systems, etc…).<\/p>\n

My point, the more you know about the RDBMS, the better you’ll be able to design for it. The better your applications will scale. The longer life your applications will have and the longer you’ll be able to use the hardware that you buy.<\/p>\n

Get more information on Physical Database Design<\/h2>\n

These are the points that I’ve been making in a couple of my most recent releases and I wanted to make sure you knew they were available:<\/p>\n

For FREE and available for download<\/strong> – my interview on DotNetRocks<\/a>. I love these guys. They’re great friends of ours (did you know that Richard MC’ed our wedding?). But, it’s so much more than their being friends\/friendly. They’re absolute geeks and they can really do killer interviews. Check out show 913: (yes, nine-HUNDRED thirteen): Physical Database Design with Kim Tripp<\/a>. I’ve also done a few other shows with them. If you want a few more shows, check out this post: Getting ready for DotNetRocks tonight (in NYC)<\/a>.<\/p>\n

My class<\/strong> on Pluralsight<\/a>: SQL Server: Why Physical Database Design Matters<\/a>. And, you can even get a 10-day\/200 hour trial subscription HERE<\/a>.
\n<\/a><\/p>\n

You always want to keep learning and there are lots of great options – including conferences. If you’re attending either SQL PASS in Charlotte<\/a> next week OR SQLintersection in Vegas <\/a>at the end of the month – please stop by and say hi. We’re looking forward to seeing a lot of you over the next few weeks.<\/p>\n

Cheers,
\nkt<\/p>\n

PS – Here are a few additional links if you’re interested:<\/p>\n