Browse by Tags

All Tags » SQL Server   (RSS)
A Rendezvous With Destiny: PASS 2009 (#sqlpass)
Rendezvous With Destiny Forty-five years ago, Ronald Reagan aka Ronaldus Magnus spoke to Americans of our rendezvous with destiny . In a few short days the SQL Community will rendezvous in Seattle for the PASS 2009 Summit . This time last year, eager Read More...
Posted 30 October 09 09:04 by Jimmy May | 2 Comments   
Filed under , , , , , , , ,
SQLIOSim Parser by Jens Suessmeyer & Yours Truly
New! Improved! v.3.3.0 Now Available on CodePlex ! Preamble SQLIOSim Parser shreds the results of SQLIOSim.log.xml in seconds, allowing easier & more accurate interpretation of the output of SQLIOSim. SQLIOSim is a tool written by CSS Engineer Bob Read More...
Posted 27 September 09 10:32 by Jimmy May | 4 Comments   
Filed under , , , , , , , ,
Aspiring Geek Speaks This Week Yet Again: Perpetual Technologies (PTI) Back-to-School with Microsoft and Oracle Event
Yesterday I flew to Minneapolis to speak at PASS MN on disk partition alignment . I left for the airport immediately afterward to get home to Indianapolis in order to speak at Perpetual Technologies, Inc. ( PTI ) 2nd Annual Back to School with Microsoft Read More...
Posted 16 September 09 09:47 by Jimmy May | 0 Comments   
Filed under , , , , ,
Attachment(s): SQLIOParserWin_0.2.3.0.zip
Aspiring Geek Speaks This Week: PASS Minnesota
Greetings, my current colleague & former MVP Lara Rubbelke ( blog | twitter ) was gracious enough to invite me to speak this week at PASS Minnesota aka PASS MN . I’ll be reprising my spiel on Disk Partition Alignment , the Best Kept Secret in SQL Read More...
Posted 14 September 09 10:14 by Jimmy May | 0 Comments   
Filed under , ,
sys.dm_db_index_operational_stats: Kick Your Assumptions: Part 1
A two-part tale in which your humble correspondent interrogates databases & Very Smart Persons (VSPs), & is forced to kick his ass- umptions regarding a popular DMF. Executive Summary Documentation for the DMF sys.dm_db_index_operational_stats Read More...
Posted 03 August 09 09:17 by Jimmy May | 0 Comments   
Filed under , , , , , ,
SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al.
Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT team has just published a new whitepaper for which I had the opportunity to provide a technical review. The author is SQL CAT best practices maven Sanjay Read More...
Posted 29 May 09 02:07 by Jimmy May | 1 Comments   
Filed under , , , , ,
New Article on SQL CAT: Initializing a Transactional Replication Subscriber from an Array-Based Snapshot by Benjamin Wright-Jones
Preamble I had the opportunity to perform a tech review of a very cool article by Benjamin Wright-Jones : Initializing a Transactional Replication Subscriber from an Array-Based Snapshot The array of geekly luminaries who contributed include SQL CAT members Read More...
Posted 15 May 09 12:19 by Jimmy May | 0 Comments   
Filed under , , , ,
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 , , , , ,
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 , , , , ,
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 ,
Disk I/O Case Study: Classic Case of SAN Over-Subscription
SAN Over-Subscription There are a variety of challenges related to I/O performance. One common problem is "SAN Over-Subscription", which is characterized by the the following symptoms: High disk latency and Low IOPs & Throughput As MS PFE & fellow Read More...
Posted 15 March 09 09:21 by Jimmy May | 2 Comments   
Filed under , , , , , , ,
Architecture Journal: Green IT in Practice: SQL Server Consolidation in Microsoft IT
I'm a lucky guy. Besides the fact that I'm healthy, alive, & living on the planet earth "in interesting times" as the fortune cookie says, I had the opportunity to contribute to an article which appeared in the Green IT issue of The Architecture Journal: Read More...
Posted 10 March 09 11:12 by Jimmy May | 1 Comments   
Filed under , , , , ,
Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)
While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of excellent presentations. One of the best was delivered by Mike Ruthruff (& not just because he shilled for my presentation on disk partition alignment Read More...
Posted 01 March 09 11:44 by Jimmy May | 3 Comments   
Filed under , , , , ,
Attachment(s): Mike_Ruthruff_SQLServer_on_SAN_SQLCAT.zip
VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)
My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally. Now it's time to spread my wings a bit & learn about Visual Studio Team System (VSTS) web testing. Spread Your Wings! http://www.youtube.com/watch?v=JtsJDTyY95g Read More...
Posted 23 February 09 05:00 by muysal | 1 Comments   
Filed under , , , , ,
SSMS Query Results: “Include column headers when copying or saving the results"
In my work with external customers, I collaborate with some excellent DBAs & Architects. But I've noticed many of them are not aware that you can capture column headers from query results to grid in SSMS. When a very bright engineer I work with—not Read More...
Posted 22 February 09 10:40 by Jimmy May | 4 Comments   
Filed under , , , ,
More Posts Next page »

Search

This Blog

Syndication

Page view tracker