Video: Ensure Optimal Performance When Deploying SQL Server 2005

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]

DBTA: What’s the Fuss about Data Deduplication?

Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means  to eliminate redundant data, either through hardware or software technologies.  To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input.  That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server.  Through data deduplication … [Read more...]

TN Summit 2010 – Surviving the Data Avalanche

Here's the link to my revamped presentation on Surviving the Data Avalanche The Abstract for this presentation is here. The slides for this presentation are here. … [Read more...]

DBTA: The Big Keep Getting Bigger

In this season of recession and financial meltdowns, a common question seems to be, "How big is ‘too big to fail'?" Titans of the financial industry made big bets with lots of risk and, when they didn't pan out, American society overall has to pay the price.  But, that aside, the very scale of our financial system, by just about every metric, has reached amazing heights, be that number of financial transactions per second, number of traders, number of funds traded, amount of money changing hands—you name it. [READ MORE] … [Read more...]

Video: SQL Server Disk Optimization

Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming. In this presentation, Kevin will address these challenges and explore methodologies to help … [Read more...]

Video: Disk Tuning and Optimization for SQL Server

This video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Video created Dec. 18, 2006. … [Read more...]

Data Deduplication Technology – New Article on DBTA

I've been seeing more and more questions from customers about data deduplication technologies. I guess that's because I can't open a blog, website, or email related to technology without some vendor or another pushing the wonders of data deduplication.  Consequently, I thought I'd take a few minutes to describe what the technology is all about.  I'll sum up my thoughts on the the value of deduplication technology by saying "It depends".  Read my article entry at Database Trends & Applications magazine here. If someone in your company is pushing you to examine this very expensive … [Read more...]