SQL Server Performance Virtual Workshop
Register Now to save your spot
Really looking forward to the upcoming SQL Server Performance Virtual Workshop – I’ll be teaching this workshop and going through all sorts of information from monitoring to TSQL gotchas to indexing and more. You can take a look at the full outline of the course on the site (link below this paragraph) and you can even earn a completion certificate for going through the workshop and passing the quiz at the end. We’ve also made the course available both online and as a DVD. Hope to see you there! This is not a webcast, it’s several hours of detailed information about SQL Server Performance Management. It’s all online.
[Course Information and Outline] [Register]
Featured Article(s)
Combine Named Sets and Calculated Members in Analysis Services, Pt. 1
Combine Named Sets with Calculated members to meet client and employer business requirements. Join BI Architect Bill Pearson as he leads hands-on exploration of Named Set / Calculated Member combinations in Analysis Services.
NEW Idera SQL toolbox
Idera’s SQL toolbox is an advanced collection of must-have tools for SQL Server DBAs and Developers. With tools for SQL Server database backup, virtual data recovery, data and object comparison, and more than 20 administrative tasks, SQL toolbox provides the tools DBAs and Developers need to save hours of time performing day-to-day tasks. PLUS, the SQL toolbox is a great value at over $600 off the price of purchasing the tools individually. Download a free 14-day trial of SQL toolbox now!
Data to Drive Decisions
It’s a dream come true, being able to provide business intelligence that helps drive decisions and provide good, solid, insightful information.
I was reading this post from Seth Godin and am seeing once again that the issue of providing that data certainly is not an issue unique to the world of DBAs and architects.
In fact, I think there’s an important lesson to be had in the post, and in the work we do. Specifically, we need to be thinking about providing information to back up the information we provide. Bear with me here, but I think this may be one of the key points in getting the reports and data accepted by the very users that request that information in the first place. Seth’s point about people first having access to lots of data, and second not necessarily acting on that data even when they believe it is a good one.
As you build out reports and other data tools, make sure you’re providing the means to validate and understand that data. Take a step back and make sure the someone using the information is able to drill down into the data to see where the numbers and information is derived from in the database. I think there’s a need for "data transparency" as much as people are calling for corporate transparency these days. Data transparency would talk to the ability to absolutely trust the information presented because the information backing it up is unassailable. This is where you want to be; you want information to be unquestionably correct.
Think about this as you build out solutions for your user base. It could literally make the difference between a successful project and one that people may accept, but not trust.
Featured Script
spTableToVbClass
Creates the skeleton code for a VB6 class (*.CLS) file, based on the fields for the given db table. The class includes a pai… (read more)
Featured White Paper(s)
How to Achieve 40:1 Backup Compression with LiteSpeed® for SQL Server’s SmartDiff
SQL Server can do differential backups, which capture only the parts of the database that have changed since the last full ba… (read more)