Today is my birthday, so no second technical post from me today. I’m out with friends having a blast.
(I’m actually at home with my wife playing video games, as most of these blog posts are written well in advance, but it sounds good to say that I logged in to day and wrote this.)
Why on earth to people want to go changing the rights on the system objects. Continued »
SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.
It took me a little less time than I expected to get an acceptable build put together. Continued »
I’ve made some good progress on the Standalone SQL Agent that I’ve been working on. Continued »
Marc Salsberry has posted some pictures from the SoCal Code Camp on his facebook page.
If you know of other pictures please post links here or on Twitter with the #socalcodecamp tag.
A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.
I’m curious about how various people are handling source control in their environment for the database? SSIS, SSRS, etc are all easy. They plug directly into the normal source control providers. But how do you handle SQL object changes like table changes, and stored procedure changes?