Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my latest failure. If you’re new to these posts, check out my posts on failing, retaking, and then passing the SQL Server MCM Knowledge exam. Took the Lab A couple weeks back, after some prodding from … Continue reading Not. Quite. There. This Time I Failed the Lab
Category: SQLServerSyndication
Re-blog – May 6-12
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: This blog entry brought to you by the procedure "sp_MSForEachDB" (5/9/2006) – Information on how to use sp_MSForEachDB. How to Sort SSMS Project (5/10/2006) – … Continue reading Re-blog – May 6-12
Minnesota SQL Server Study Group
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
Re-blog – April 29-May 5
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
SQLRally–Don’t Forget Your Business Cards?
SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up your SQL Server skills. You’ve probably looked at the schedule and picked out a few sessions that are a must see. Networking But are you prepared to take advantage of the opportunity to network with … Continue reading SQLRally–Don’t Forget Your Business Cards?
Meme Monday – "I got 99 problems but a disk ain't one"
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"
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: 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
Re-Blog – April 15-21
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
MCM: To pass, or not to pass
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
Re-Blog – April 8-14
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
Strate SQL 