Introduction to TPC Database Benchmarks Let's talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I'll give you a brief introduction to TPC benchmarks and, in future articles, I'll be telling you how to extract specific pieces of valuable information from the published benchmark results. But let's get started with an overview … read … [Read more...]
Read the New TPC Database Benchmarking Series
Filed Under: Administration, Challenges, Databases, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, Oracle, Performance, SQL Server 2012
The All-New ‘Database Lifecycle Management” is available on MSDN
The initial release of Database Lifecycle Management is now available on MSDN. The site is something called "curated content". This means it's a single consolidated location to look up lots of disparate articles and content, all in one easy to search location. This “curated content view” contains the best content, video, and community-centric information from Microsoft, including topics like: SQL Server Data Tools · Get started with sample projects, code samples · Video demos by Gert Drapers (blog) · Script common data portability tasks using Sqlpackage.exe · Link to the SSDT … [Read more...]
Filed Under: Administration, Architecture, Challenges, Cloud, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, Video Tagged With: Azure, Backup & Recovery, Best Practices, DBA, Developer, SQL Server 2012, Virtualization
SQL Intersection!
The best emotion to describe how I'm feeling is 'astounded'. I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference. Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection. Check out this list of speakers: Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [blog | twitter] Andrew J. Kelly, Mentor, SolidQ [blog | twitter] Bob Ward, Principal Architect Escalation Engineer, Microsoft [blog | twitter] Brent Ozar, Brent Ozar Unlimited [blog | twitter] Conor Cunningham, Principal … [Read more...]
Filed Under: Administration, Challenges, Cool Technologies, Databases, Hardware, IO, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: AlwaysOn, Best Practices, DBA, Developer, High Availability, Monitoring, Performance, SQL Server 2012
Demo Mastery for the Technology Evangelist
In the same way that the finest presentations involve much more than the simple relaying of information, the finest software demos are much more than just presenting features. REMEMBER: The goal of a demo is to INSPIRE the audience to use the software/technology, not to teach them every nuance of software/technology. I've spent the last 10 years learning how to give good presentations and to give good software demonstrations. Here are several tips to take your software demonstration from informative to masterful: 1. Know your audience Whenever you start a demo, make sure you have a good … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, Opinion, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Best Practices, Career, DBA, Developer, Presentations, Professional Development, Training
The Zombie PerfMon Counter That Never Dies! Quick Tip
The PerfMon Counters That Just Won't Die One of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away. (Some day, politicians will realize this. We can easily fact check their consistency). Because of longevity of content posted to the Internet, a lot of performance tuning topics become "zombies". We shoot 'em in dead, but they keep coming back! In other words, those old recommendations were a suggested best practices for long ago, for a specific version of SQL Server, but are now … [Read more...]
Filed Under: Challenges, Databases, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Best Practices, DBA, Developer, DMV, Monitoring, Troubleshooting
Two New Slide Decks. Plus, the Week in Colorado.
I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver. At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers. Denver, in fact, was standing room only and had nearly 30 first time attendees. Great news! I also want to give a special shout-out of thanks and appreciation to Chris Shaw (Twitter | Blog) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to … [Read more...]
Filed Under: Administration, Challenges, Cool Technologies, Databases, IO, On-Line Resources, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, CodePlex, DBA, Developer, Leadership, Performance, SQL Server 2012, SQLSaturday, Tools & Scripts, Troubleshooting, Video
A Fond Farewell to Quest Software
The week of the 4th of July is a happy week for Americans. Most families get out for a parade, a fireworks display, a picnic in the park, a movie where Will Smith puts the beat down on a bunch of aliens, or an afternoon at the pool or lake. We celebrate the contributions of our service men and women. We honor veterans. We drink a lot of beer. We reflect on the founding of our nation and the meaning of “Independence Day”. My own reflections over the Independence Day holiday took me in a new and rather unexpected direction. After ten-and-a-half immensely rewarding years at Quest Software, … [Read more...]
Filed Under: Challenges, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Goals, Leadership, MVP, Professional Development, Quest Software, Writing
Recorded Webcast Available: Extend SCOM to Optimize SQL Server Performance Management
Join me and Eric Brown, Quest Software senior product manager for SQL Server monitoring tools, as we discuss the server health-check capabilities of Systems Center Operations Manager (SCOM) in this previously recorded webcast. We delve into techniques to maximize your SCOM investment as well as ways to complement it with deeper monitoring and diagnostics. You’ll walk away from this educational session with the skills to: Take full advantage of SCOM’s value for day-to-day SQL Server monitoring Extend the capabilities of SCOM to proactively manage SQL Server performance Troubleshoot … [Read more...]
Filed Under: Administration, Challenges, Databases, SQL Server, SQLServerPedia Syndication, Video Tagged With: DBA, Monitoring, Quest Software, SCOM, SQL Server 2012, System Center, Troubleshooting, Video
Review the New Migration Guide to SQL Server 2012 Always On
I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall. Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide to SQL Server AlwaysOn. Read it and then pass along any feedback: HERE Enjoy, -Kev -Follow me on Twitter! … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: High Availability, SQL Server 2012, White Paper
Build Your Own Microsoft Operations Manager Pack
Operations Manager Management Pack Development Kit I just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit. Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel. But I digress... So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007. It provide the you with all of the info need to design and build a management pack … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Monitoring, Performance
