Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]
Video: Magic Formula for SQL Query Tuning
Video: Interview – Part 3 Cross-Platform Issues
Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software. Posted January 31, 2008. … [Read more...]
Video: Interview – Part 1: Quest Software
Heather Eichman interviews Kevin Kline, the former President of PASS and strategy manager for the SQL Server business unit at Quest Software. Originally Posted on January 24, 2008. … [Read more...]
Efficiency and Effectiveness at Work [Video]
In this vblog entry on www.SQLServerPedia.com shows SQL Server expert Kevin Kline discussing his views on how to be both efficient and effective in your day to day and career - aimed at the SQL Server professional, but good for anyone. Originally posted August 08, 2008. … [Read more...]
Video: Data Modeling in the SQL Server Space
Join SQL Server MVP and President of PASS, Kevin Kline as he: * Identifies the issues that can arise from relying only on modeling tools * Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical * Describes how to correctly identify and resolve serious problems * Provides best practices to resolve issues Posted June 14, 2007. … [Read more...]
Microsoft SQL Server High-Availability Videos and Q&A Log
You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt. Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the Quest Software Pain of the Week webcast site. Archives of other videos are here. We're … [Read more...]
Video: SQL Server Memory Troubleshooting
Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today's podcast. You can view this video in higher quality or your favorite portable formats at: http://sqlserverpedia.com/blog/sql-se... Video published December 24, 2008. … [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...]
Video: SQL Performance Optimization
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should. You will learn how to: * Identify the root cause of bottlenecks that hinder performance of your SQL Server environment * Diagnose and fix T-SQL errors in development before code goes into production * Learn new best practices for project planning and … [Read more...]
Videos: Strategies for Addressing Common SQL Server Challenges
As a busy SQL Server DBA you face an increasing number of daily challenges: Managing fast growing data volumes and database environments Diagnosing and resolving performance issues Effective backup and recovery Monitoring and tracking database changes Balancing current resources against future capacity needs Inefficiencies in any of these areas can lead to performance degradation, unauthorized database changes, and unplanned, extended downtime. Webcast originally presented by renowned SQL Server expert Kevin Kline and learn valuable strategies for addressing these challenges … [Read more...]