Interested in Self-Service Analytics at the PASS Business Analytics Conference?

I don’t know if you’re planning to attend the PASS Business Analytics Conference. But you'll be missing a ton of great content especially for data, analytics, and business intelligence professionals. There's still plenty of time to register and, if you use my discount code – BABS2B – you'll get $150 off the conference registration fee.  There will be more than 60 sessions at the event by BA/BI experts from Intuit, Microsoft, SurveyMonkey, Wells Fargo, and more. Last year’s inaugural event was quite the shindig, bringing in around 900 business analysts, data scientists, architects, and BI and … [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...]

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

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

What’s the Data Modeling Standard for Business Intelligence Systems?

I had the good fortune to overhear some of my good friends and fellow MVPs discussing the process of data modeling for business intelligence systems.  So what are the industry standard approaches for modeling dimensional data modelling? The short answer is that Kimball's dimensional modeling is the most widely adopted standard for any sort of data warehouse. Inmon is also well respected. But the consensus is to stick with Kimball, especially if you're looking for something an enterprise standards team is going to recognize as "standard". The book on my shelf and which I most … [Read more...]

Hear the SQL Server 2012 story on DotNetRocks

I was privileged to have a chat with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers!  Here's the abstract: Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation starts out talking about the new features that developers will love, like windowing - no need for cursors anymore, you can request a window of records from a set and move easily window-to-window. Kevin also talks about the new column store index that is especially … [Read more...]

Cheaters Never Win, Even in TPC Benchmarks

In this column, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING. Keep in mind that I use the term “cheating” in a joking manner with my tongue planted firmly in my cheek.  But I’m also half-serious.  One of the of the things that is great about the TPC benchmarks is that each of the vendors are required to fully describe all of the shortcuts, tweaks, and special operating configurations they use in order to achieve their spectacular performance numbers.  In a sense, the Transaction Processing Counsel requires that all benchmarked platforms declare all of … [Read more...]

Use TPC Database Benchmarks to Save Money

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 database benchmarks that are extremely useful and informative. I also described last month how the TPC provides several different types of benchmark tests. For example the TPC-C and TPC-E benchmarks are extremely useful for measuring transaction throughput. … [Read more...]

Read the New TPC Database Benchmarking Series

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