Search Results for: fundamentals

SQL in the City, US Tour 2013, Recap

Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just wanted to give you a quick assessment of how the events went from my point of view. Overall, each and every one of these events was awesome. I can safely say that because each and every one of these events provided something special, the opportunity to network with our peers and with the developers and project managers at Red Gate (who are also our peers, but not usually available to us). I both took part in the networking and stood back and watched it happen. I love seeing a bunch of data pro's sitting (or standing) in a circle exchanging war stories, ideas, questions, thoughts or suggestions. It means you…
Read More

Laws You Break at Your Peril

Laws of Thermodynamics TANSTAAFL Gods of the Copybook Headings All magic comes with a price Winter Is Coming My adult years started with a pretty thorough education in physics thanks to Uncle Sugar and the Navy Nuclear Power School. The laws of thermodynamics were carved into our brains (along with Baumgart's Law*). Experience has taught me that all these other statements are more or less riffs on the concepts put forward by the fundamentals of the laws of thermodynamics. They're just applications of the same within social spheres. In short, if you have a physical engineering background, you tend to be a realist. But note, I'm not a pessimist. I just recognize a simple thing. No matter how positive my thoughts are, no matter my belief in the righteousness of…
Read More

Never, Ever Use Clustered Indexes

This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I get the concept that if a table has a clustered index, then that index actually becomes the table. When you create a clustered index on a table, the data is now stored at the leaf level of the Balanced Tree (b-tree) page distribution for that index, and I understand that retrieving the data using a seek on that index is going be extremely fast because no additional reads are necessary. Unlike what would happen with a non-clustered index on a heap table. Yes, I get that if I store my data in a heap, the only way to access the data is through the Index Allocation Mapping (IAM)  pages that…
Read More

Learning Powershell

I've been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware of the fact that I've posted a few PowerShell scripts in the past.  So why was I attending a fundamentals class? Because I didn't know what I was doing. I knew going into the class that I needed a better grounding in the fundamentals of Posh, but after the first day of Don's excellent class, I realized that I had been working with PowerShell and didn't have a clue how it really worked. Don's class is excellent and I could spend a lot of time talking about just that (which I'm sure would make Don happy). However I want to concentrate on something that he said during class that really…
Read More

PASS Summit 2009 Day 3

The day started off with a mixed bag. First we had an honestly tearful farewell with Wayne Snyder saying goodbye to Kevin Kline, leaving the board for the first time since PASS was founded. This was followed by a painfully dull session with Dell all about their commitment to bread & butter DBA concerns. That was followed by Dr. DeWitt doing a deep dive into the history and the future of computing, showing and teaching in ways that only the very best can achieve. It was a fantastic performance, entertaining, enlightening, amazing... Just flat out incredible. It's the kind of understanding that you wish you could get about most things, most of the time. Unfortunately, it came to an end. Today I finally got to hit a lot of sessions. First…
Read More

Things you know now…

Brent Ozar has passed on another doozie. His list is pretty good. Since I'm much more a tactical guy than a big picture strategic guy, my advice to me in the past is going to be more tactical in nature. Learn the Rules of Normalization Yeah, eventually I picked up  on them, but not before I built about six or seven systems I would be profoundly embarassed to show anyone today. I realize that pointing at the fundamentals is just shy of a non-answer to the question, but the fact of the matter is, I was a bit of a cowboy. Still am. The beauty, and curse, of being a cowboy is, you tend to bypass things. Sometimes, you're riding by trouble you just don't need. Other times, you're hell bent for…
Read More

VSTS 2008 Database Edition GDR CTP 16

CTP 15 utterly hosed the virtual device I had it on. I tried uninstalling, but it just wouldn't come off clean. I finally have rebuilt the virtual and reinstalled everything except VSTSDB GDR. Having learned my lesson (the hard way as usual), I started a differential on my virtual for the install of CTP 16 so that I can roll back and install the release candidate and the release as they come out without having to go through that whole rebuild thing again. While Gert & crew are still making some changes, the fundamentals are still there so my presentation at PASS should work fine as currently defined. The only problem I ran into was that I couldn't get the database to deploy by simply clicking on the deploy menu…
Read More