Subscribe to this blog
SQL Man of Mystery
Archives: June 2011
The Austin Fall Classic, SQLSaturday is Comming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have finalized our location and spot on the SQLSaturday list. After a rough start to the year I’ve managed to get my core team together and in action, settle my… Read more
0 comments, 401 reads
Posted in SQL Man of Mystery on 30 June 2011
The Austin Fall Classic, SQLSaturday is Coming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have finalized our location and spot on the SQLSaturday list. After a rough start to the year I’ve managed to get my core team together and in action, settle my… Read more
0 comments, 426 reads
Posted in SQL Man of Mystery on 30 June 2011
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the long haul I try and gather as many data points as I can. You can capture database sizes but when your database blows up in size its nice to be… Read more
1 comments, 468 reads
Posted in SQL Man of Mystery on 29 June 2011
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means what you think it means. - Princess Bride
If you are like me, you are constantly reading up on the latest hardware. Each site has it’s own… Read more
0 comments, 670 reads
Posted in SQL Man of Mystery on 29 June 2011
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure compiles both data and log file usage. This is a fundamental aspect of tracking growth over time and being proactive about growing your databases yourself instead of letting the auto… Read more
1 comments, 137 reads
Posted in SQL Man of Mystery on 28 June 2011
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait statistics. As with most of the DMV’s provided in SQL Server 2005/2008 sys.dm_os_wait_stats is a cumulative view. To add to my series SQLDIY: Manage and Monitor SQL Server Yourself here… Read more
1 comments, 387 reads
Posted in SQL Man of Mystery on 27 June 2011
SQLRally, SQL Saturday and The Summit
“Gotta say it was a good day…”
-Ice CubeOn The SQL Saturday Circuit
I’ve been speaking at all the regional SQLSaturday events I can go to. I kicked off the year with SQLSaturday #57 in Houston. Then did a turn around to SQLSaturday #63 in Dallas, my second one… Read more
1 comments, 144 reads
Posted in SQL Man of Mystery on 17 June 2011
Speaking at SALSSA June 15th 2011:Understanding Storage Systems and SQL Server
I am very exicted to be speaking at the San Antonio PASS chapter SALSSA! It’s been way to long and I look foward to catching up with Jim Steiner the coordinator. I will be giving my favorite talk Understanding Storage Systems and SQL Server. It has been updated and… Read more
0 comments, 109 reads
Posted in SQL Man of Mystery on 13 June 2011
Materials from SQL Server, Storage and You Part III
Thanks again to everyone who attended. Technical problems aside I had a great time and there were some great questions!
If you have a question please feel free to contact me, I’ll do my best to answer it.
0 comments, 179 reads
Posted in SQL Man of Mystery on 8 June 2011
Secrets Of SQL Server: SQL Server, Storage And You Part 3 Solid State Storage
My last in the series on storage and SQL Server is today Wed, Jun 8, 2011 3:00 PM EDT (2:oo PM CST). You can register here if you want to take a deeper look into solid state storage. If you want a solid primer into flash based storage devices this… Read more
0 comments, 219 reads
Posted in SQL Man of Mystery on 8 June 2011