How Do You SKU?

I’d like your opinion here. Follow my logic here for a moment as I walk through a couple rhetorical questions.  Have you ever had a friend developed an application entirely on SQL Server Developer Edition?  (Not that YOU would ever do such a thing, but maybe you know someone who has. Right?) And has your friend’s IT department actually deployed said application only to discover that they’re only licensed for Standard Edition in their production environment?  And then was your friend’s IT management team is horrified to learn that they’ve either got to go through the very expensive process … [Read more...]

Have You Heard About Project Lucy?

Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file It’s 1oo% web-based - you don’t have to download or maintain anything and updates roll out seamlessly, all the time It really helps - just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on … [Read more...]

Video: Where are good SQL Server resources?

Kevin discusses resources online that he uses and considers to be excellent destinations for SQL Server professionals. Kevin will discuss each site he uses in detail - check it out! Posted August 15, 2008. … [Read more...]

Video: Magic Formula for SQL Query Tuning

Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]

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: 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...]

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...]

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...]

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: Maximize SQL Server Performance with SQL Tuning

This presentation is a bit old, but largely still applicable.  It will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL. Posted March 27, 2007. … [Read more...]