April 2009 - Posts

A Language for Software Architecture by JD Meier in The Architecture Journal

J.D. Meier is a Principal Program Manager for Microsoft’s Patterns & Practices team.  He’s a great writer & a clear thinker.  J.D.’s Sources of Insight is devoted to getting results & balancing life. His latest-&-greatest publication Read More...

Posted 28 April 09 09:41 by Jimmy May | 0 Comments   
Filed under News, Best Practices, Engineering Discipline, Fundamentals, Architecture

Wait Stats by Joe Sack

Wait stats rock. As I shared recently with friends, when it comes to SQL Server performance, wait stats are the #1 arrow in my quiver, the first tool out of my toolbox, the Vera of guns (see the Firefly episode Our Mrs. Reynolds to divine that reference). Read More...

Posted 27 April 09 11:15 by Jimmy May | 2 Comments   
Filed under Best Practices, Performance, SQL Server, Tools, /faster, Wait Stats
Attachment(s): Joe Sack wait stats.sql

Wait Stats Introductory References

Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new here. However, if you’re a n00b, this is a great place to start. History As I commented here on SQL MVP Jason Massie’s blog , I first became aware of the Read More...

Posted 26 April 09 06:23 by Jimmy May | 3 Comments   
Filed under Training, Performance, Fundamentals, SQL Server, /faster, Wait Stats

MSDN Blog Box Beefed Up and SProcs Tweaked For New! Improved! User Experience

A few weeks ago Cindy Gross brought this tweet to my attention from SQL Server MVP Jason Massie : statisticsio : I should pdf the essential posts from @ aspiringgeek and sqlcat because everytime I really need them blogs.msdn.com is crawling. http://twitter.com/statisticsio/statuses/1377928792 Read More...

Posted 16 April 09 12:26 by Jimmy May | 4 Comments   
Filed under News, Geekly, Miscellaneous, Performance

SQL Server 2008 SP1: Available Now at an Internet Near You

The long-awaited SQL Server 2008 SP1 was just released, available at an Internet near you right NOW : SQL Server 2008 Service Pack 1 The SP includes CUs 1, 2, & 3 (not 4), including “Key improvements in SP1 include Slipstream, Service Pack Uninstall Read More...

Posted 09 April 09 05:01 by Jimmy May | 1 Comments   
Filed under News, SQL Server

Search

This Blog

• Home
• Email

Tags

• /faster
• Architecture
• Best Practices
• Career
• CPU
• Discipline
• Disk I/O
• Disk Partition Alignment
• DMOs/DMFs/DMVs
• Effectiveness
• Engineering Discipline
• Fundamentals
• Geekly
• Humor
• Hyper-V
• Indexes
• L'Chaim!
• Me
• Memory
• Miscellaneous
• News
• Office Productivity
• Outlook
• PerfMon
• Performance
• Personal Productivity
• Productivity
• Replication
• Scalability
• Speaking
• SQL CAT
• SQL Server
• SQLIOSim
• Table Partitioning
• Tools
• Training
• T-SQL
• VSTS
• Wait Stats
• xperf/ETW/WPA/WPT

Archives

• November 2009 (2)
• October 2009 (1)
• September 2009 (4)
• August 2009 (1)
• May 2009 (5)
• April 2009 (5)
• March 2009 (9)
• February 2009 (3)
• January 2009 (1)
• December 2008 (4)
• November 2008 (3)
• October 2008 (4)
• September 2008 (2)
• June 2008 (1)

Best of Blog

• SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
• Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
• PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)
• Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars

Speaking

• ITT 2008 Commencement
• PASS 2008

Syndication

• RSS 2.0
• Atom 1.0