Top 10 DBA Mistakes on SQL Server (Now with Prizes!)

  Hear one of my most popular session via streaming media at SQLSentry.TV! Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t mean that database administration on SQL Server is problem free.  And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago.  Why not learn from those who first blazed the trails of database administration, so that we don’t make … [Read more...]

Amazingly Useful SQL Server Articles on SQLPerformance.com

Me and Aaron Bertrand, SQL Sentry flagbearers. One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line: Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ( b | t ). Helping tune tough SQL Server transactions on Answers.SQLPerformance.com for free. Streaming videos at SQLSentry.TV. In addition, our monthly eNews newsletter keeps you up to date on all the latest happenings on all of these websites. Please subscribe! … [Read more...]

Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

  Join me for a day of Real World Database Configuration and Tuning for Microsoft SQL Server SQL Saturday Silicon Valley 2014 Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT) Mountain View, CA Click HERE to register Now! Seating is very limited!   This full-day training event combines a thorough overview of fundamental architectural concepts of the SQL Server relational engine followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. … [Read more...]

One Preparation that makes SSMS Crash Dumps Easy to Survive

  Uh oh! So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity to recover your lost SQL scripts once you reopen SSMS, as shown above.  (Image above courtesy of Aalam Rangi). But let's say that closing the program represents a big issue for you due to lost time, productivity, etc. You want to go … [Read more...]

What Does a Good Mentor Do for You?

These would be good mentors - me plus Adam Machanic, and Klaus Aschenbrenner Not long ago, John Sansom (Twitter | Blog) kicked off a SQL Community Project #DBAJumpStart by asking 20 successful and experienced SQL Server professionals this exact question: "If you could give a DBA just one piece of advice, what would it be?" I wrote up my Advice for the Aspiring DBA post here, while John collected the entire set of responses here within the DBA JumpStart collection. Part of my advice, indeed of several of the contributors, was to find and build a strong mentor-protege relationship.  But what … [Read more...]

You’re Leading in More Ways Than You Realize

The following is an excerpt from Kevin and Joe Webb's (Blog | Twitter) monthly IT Pro eNewsletter.   You're Leading in More Ways Than You Realize It's that time of year again. The sights and sounds of modern-day gladiators clashing on the gridiron field. If you're a football fan, there is no better time of year. In football, the quarterback is the de facto leader of the offense of team. Late in the game it is to him that the team looks to snatch a last minute come-from-behind victory from certain defeat. That's a lot of weight to put on one man's shoulders. Yet the … [Read more...]

What’s the Hidden Issue in the Recent PASS Bylaw Changes?

The 2004 PASS Board of Directors On December 19, 2013, the PASS board of directors (BoD) proposed a small and targeted set of bylaw changes in response to CA relinquishing the BoD seats they were entitled to as a Founding Partner in the professional association. How Did CA Get Involved with PASS? You might be wondering "How did a company that doesn't seem to make a lot of SQL Server tools get a seat on the board of this huge, international SQL Server professional association?" It's a bit of a shaggy-dog story, so I'll sum it up quickly. Back in the late 1990's, there was a large and … [Read more...]

One Piece of Advice for the Aspiring Junior DBA

This post is part of the SQL Community Project #DBAJumpStart by John Sansom (Twitter | Blog). "If you could give a DBA just one piece of advice, what would it be?" John asked 20 successful and experienced SQL Server professionals this exact question. I share my own thoughts with you below and you can find all our answers together inside DBA JumpStart, a unique collection of inspiring content just for SQL Server DBAs. Be sure to get your free copy of DBA JumpStart. =-=-=-= John Sansom recently asked me and 19 other bloggers “What’s the one bit of advice you’d give a junior database … [Read more...]

Now Playing: RunAsRadio

I had the privilege last week of talking with Richard Campbell (t), Microsoft MVP and host of the very popular RunAsRadio podcast, a sister-show to the worldwide phenomena known as .NET Rocks!.  Here's the write-up Richard used to describe the show: Richard talks to Kevin Kline about what's coming in SQL Server 2014. Yes, the database continues to evolve and Kevin digs into many of the new features. The conversation also jumps into the NoSQL movement and it's many forms, including making simple data storage easier for developers as well as the creation and management of big data solutions. … [Read more...]

Coming to the PASS Summit?

Are you coming to Charlotte next week for the PASS Summit?  Let's connect!  When ever it's open, I'll be in the Exhibit Hall at the SQL Sentry booth unless I'm delivering a session or something of that nature.  Here's the sessions I've got on the calendar - Tue, Oct 15: First-timers Get to Know Your Community with Kendal Van Dyke (Blog | Twitter), 2:45-3:45 and 4:00-5:00 PM First-timers Orientation Panel Discussion (moderator), 6:00-6:45 PM Opening Ceremonies and Quizbowl, until 8:00 PM Wed, Oct 16: Keynote, Blogger’s table Session: Convince Me - Persuasion Techniques That … [Read more...]