Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Man of Mystery

Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Senior Lead Consultant at Catapult Systems. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.

Come For The Education Stay For The Networking

OMG! SQLSATURDAY #97 IS HERE!

I am really excited about SQLSaturday #97! In just a few short hours we will be opening the doors to a crowd of people wanting to learn about SQL Server.

We have a crazy good lineup of speakers and a truly awesome group of sponsors Read more

2 comments, 325 reads

Posted in SQL Man of Mystery on 1 October 2011

SQLSaturday #97 Speaker Selection Process

Hard Choices

First, thank you for submitting to speak at SQLSaturday #97 in Austin, TX. Myself, Richard Heim and Mike Byrd had a good time reading and discussing all the abstracts.

Now that we have rapped up the selection process let me say it was no easy chore. I’d love… Read more

0 comments, 322 reads

Posted in SQL Man of Mystery on 8 September 2011

Plucking Wallflowers

Wallflowers Bloom

My friend Tim Mitchell wrote an awesome personal account a while back and shared it again recently. It’s a tale I have seen and heard all to often. A tale of a really smart guy who just lacks the courage and confidence to step forward and participate in… Read more

0 comments, 236 reads

Posted in SQL Man of Mystery on 2 September 2011

Building A New Storage Test Server

We’re Gonna Need A Bigger Boat

Not to sound too obvious, I test IO systems. That means from time to time I have to refresh my environment if I want to test current hardware. Like you, I work for a living and can’t afford something like a Dell R910 Heck,… Read more

2 comments, 1,177 reads

Posted in SQL Man of Mystery on 25 August 2011

Why You Should Attend SQL Saturday 97

Reposted from :http://sqlaj.wordpress.com/2011/08/19/why-you-should-attend-sql-saturday-97/

By AJ Mendo

Free Training

Part of the mission statement of SQL Saturday (read the full statement here) is to provide a day of free training to SQL Server Professionals and those new to SQL Server an event that combines training and networking as well… Read more

1 comments, 391 reads

Posted in SQL Man of Mystery on 22 August 2011

What It Means To Me To Be A Volunteer

Hi my name is Wes, and I am a volunteer

I am not unique. There are others like me, who give time, money or both. I am not the biggest giver. There are some who dedicate their lives to helping others. I couldn’t stop being a volunteer even if I… Read more

0 comments, 634 reads

Posted in SQL Man of Mystery on 10 August 2011

I’m A Part Of Things Greater Than Myself, The POSSE Is Here.

Something Is Missing…

Some of you know I have a deep passion for the SQL Server community. I’ve always been extremely focused on local community building. As we started really planning for our SQLSaturday (SQLSaturday #97) I started to realize there was a gap between the user group… Read more

2 comments, 329 reads

Posted in SQL Man of Mystery on 3 August 2011

SQLDIY: Index Usage Statistics

There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how much your indexes are used, how they are used or if they are used at all! I’ve put together this stored procedure to gather a ton of useful information on… Read more

0 comments, 645 reads

Posted in SQL Man of Mystery on 12 July 2011

SQLDIY: Index Fragmentation Levels

Indexes, indexes, indexes my kingdom for an index! Well, something like that. Indexes are the single most important structure in our relation database world. So, it is understandable that I do everything I can to gather information, monitor their health and maintain them to the best of my ability. One… Read more

0 comments, 614 reads

Posted in SQL Man of Mystery on 7 July 2011

Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2

Adding In Others For Contrast

In our first part we introduced Pliant and the LS 300 drive. In part 2 we get down to the details. To give a better idea where you stand with the setup described last time I’m throwing in two other storage setups. A RAID… Read more

0 comments, 1,989 reads

Posted in SQL Man of Mystery on 6 July 2011

SQLDIY: Statistics Information Including Last Update

One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the optimizer relies on statistics to determine the best execution plan it is imperative that you keep an eye on them and maintain them just like you would indexes. One of… Read more

0 comments, 378 reads

Posted in SQL Man of Mystery on 5 July 2011

SQLDIY: Gathering A Data Dictionary

In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in SQL Server. This is a little different from the rest. You can still do quite a bit with the information provided but to leverage this to the fullest requires a… Read more

0 comments, 507 reads

Posted in SQL Man of Mystery on 1 July 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, 522 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, 576 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, 611 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, 1,081 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, 215 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, 527 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 Cube
 

On 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, 232 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, 183 reads

Posted in SQL Man of Mystery on 13 June 2011

Newer posts

Older posts