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
Filed Under: IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Performance, Query Tuning, SQL Server 2005, Troubleshooting, Video, Web Development
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...]
Filed Under: Challenges, Cool Technologies, Databases, Interviews, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, Oracle, SQL Server 2005, Video
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...]
Filed Under: Conferences, Interviews, PASS, Professional Development, SQL Server, SQLServerPedia Syndication, Video Tagged With: Career, Video, WorldView
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...]
Filed Under: Challenges, Opinion, Professional Development, SQLServerPedia Syndication, Video Tagged With: Career, Management, Plays Well With Others, Professional Development, Video
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...]
Filed Under: Challenges, Databases, Presentations, SQLServerPedia Syndication, Tool Time, Video Tagged With: Data Modeling, Database Architect, Database Design, DBA, Normalization, Tools, Video
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...]
Filed Under: Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, Database Mirroring, DBA, High Availability, SQL Server 2008 R2, Tools & Scripts, Video, Windows Clustering
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...]
Filed Under: Challenges, Opinion, Performance, Professional Development, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, DMV, Internals, Performance, SQL Server 2000, SQL Server 2005, Video
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...]
Filed Under: BigData, Challenges, Databases, IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Trends, Video Tagged With: Best Practices, DBA, Internals, Performance, SQL Server 2008 R2, Video
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...]
Filed Under: Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Quest Software, Tools & Scripts, Video
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...]
Filed Under: Administration, Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2005, Tools, Tools & Scripts, Video
