A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study group to anyone going after SQL Server certifications. After some back and forth, it turned out there were a number of people interested. For ease of scheduling, I kept the old MCM study group time and … Continue reading Minnesota SQL Server Study Group
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Analyze This – Analyze Your Indexes – Part 6 (4/29/2009) – Improved performance of index analysis query. Searching for Plans (5/3/2010) – Query to find … Continue reading Re-blog – April 29-May 5
Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many things can go wrong with a database server that are NOT related to a disk drive? Here are my 9 items… Unchecked parallelism Unmanaged security Code that works, not performs Disbelief in clustered indexes … Continue reading Meme Monday – "I got 99 problems but a disk ain't one"
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: The Power of N (4/22/2010) – Viewing data in other character sets. What is the size of your index? (4/23/2009) – The title kind of … Continue reading Re-blog – April 22-28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Analyze This – Your Indexes Analysis – Part 1 (4/19/2009) – Query that combines existing index statistics and missing indexes into a single output. Analyze … Continue reading Re-Blog – April 15-21
I’ve been counting down the days until I get the score from my second attempt at the SQL Server MCM written exam. When I last took it, I knew there were some areas that I didn’t know the answers. But for the vast majority of the exam I felt good. In fact, I felt that … Continue reading MCM: To pass, or not to pass
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Wait Stat Report (4/13/2010) – Report that can be used to do your own wait stat analysis. FileSystemHelper SQL Server CLR – Codeplex (4/14/2010) – … Continue reading Re-Blog – April 8-14
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. Ones that I thought were pretty decent that have been lost to the time. Some of them have pretty decent content, in my opinion, and don’t deserve to live solely in the moment that they … Continue reading Re-Blogging Posts
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally? What’s SQL Rally? I’m glad you asked. SQL Rally is a new two day PASS conference. It’s a great cross between the PASS Summit and a SQL Saturday. For a couple days, you can come together with a … Continue reading I Got Registered!
Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino. As I mentioned in the session, I wanted to post the content from my session – [download id="5"]. Along with including a few links that people might find useful. First, we skipped talking about XQuery – if you want … Continue reading TechFuse Follow-Up
Strate SQL 