Third Party Applications and Other Acts of Violence Against Your SQL Server

I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ticketing apps. I'm not talking about monitoring and tuning applications since they, by their very nature, need a different sort of access to your back-end server resources. (Full disclosure: both Tom and I currently work for different tools vendors. But we're both … [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...]

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...]

Wait Statistics in SQL Server

When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular resource, activity, or process.  Since wait statistics are categorized by type, one look will quickly tell the variety of problem that needs your attention, assuming you know meaning for Microsoft's lingo for each wait type. (As an aside, wait stats were implemented in the earliest days of relational database computing because the early RDBMSes ran on … [Read more...]

Now Playing on SSWUG TV!

Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the image to see my new weekly video series on SSWUG.org! Now I'm adding a new video format to the mix, in partnership with my friend Steven Wynkoop and SSWUG.org.  I've been a frequent speaker in the SSWUG virtual conferences over the past several years and, we thought, why not … [Read more...]

Windows Azure and SQL Database News

This morning Microsoft released some great updates to Windows Azure.  These new capabilities include: SQL Server AlwaysOn Support: General Availability support with Windows Azure Virtual Machines for High Availability and Disaster Recovery Notification Hubs: General Availability Release of Windows Azure Notification Hubs (broadcast push notifications for Windows 8, Windows Phone, iOS and Android) AutoScale: Schedule-based AutoScale rules and richer logging support Virtual Machines: Load Balancer Configuration and Management Management Services: New Portal Extension for Operation … [Read more...]

New on DBTA.com: Database Benchmarking Tools, the final article in the database benchmarking series

In the last several articles on Database Trends & Applications, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Pictured (L-R): Scott … [Read more...]