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...]
Efficiency and Effectiveness at Work [Video]
Filed Under: Challenges, Opinion, Professional Development, SQLServerPedia Syndication, Video Tagged With: Career, Management, Plays Well With Others, Professional Development, Video
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...]
Filed Under: Databases, IO, On-Line Resources, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts
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
Video: Microsoft Master Certification Program
On this vblog entry on www.sqlserverpedia.com I describe and discuss the Microsfot MCP (Master Certification Program). I hope this helps anyone that is interested in this program. Enjoy and I look forward to your feedback! Posted September 09, 2008. … [Read more...]
Filed Under: Opinion, Professional Development, SQL Server, SQLServerPedia Syndication, Video Tagged With: Career, DBA, Professional Development, SQL Server 2008 R2, Training
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
Video: Worth the Wait Why SQL Server 2008 is Great
Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable. Originally Posted on YoutTube November 12, 2008. Follow me on Twitter! … [Read more...]
Filed Under: Administration, Databases, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, Quest Software, SQL Server 2008
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
