Last month, I began a series of articles describing database application benchmarking. In the first article, I told you about different ways that you can construct your own database application benchmark. However, you don’t have to reinvent the wheel. The Transaction Processing Council (www.tpc.org) has already created a large number of ...

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

It's an old story you've probably heard before.  Provide a free version of your software product with strict limitations on performance or other specific capabilities so that folks can give it a try without risk, while you minimize the chance of cannibalizing sales of your commercial products.  Microsoft has take this strategy ...

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

2012 was, simply stated, a year that kicked my butt.  When I wasn't struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are normally on my Christmas ...

I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...

I have two new articles up on Database Trends & Applications magazine.  I'd love to get your thoughts and feedback!Welcome to the Weird, Wild World of SQL Server LicensingNot long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first ...

Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time.  Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...

Ok, I have to admit the painful truth. I'm reliably slow to the finish line. This year, I got my slides into PASS HQ by the skin of my teeth, the weekend before the event was to begin.  Although I could say with a straight face ''I uploaded my slides!''.  I have to be honest that I wasn't surprised when many of my attendees said that ...

Click this link to register: http://www.houseofbrick.com/education/sqlserverbootcamp/Registration. Presented by my buddy, David Klee at House of Brick, one of the nations top VMWare consultancies specializing in Oracle and SQL Server deployments. David has a great write-up of this boot camp ...