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...]
TN Summit 2010 – Surviving the Data Avalanche
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
SQLRally Precon Voting
I have submitted a pre-conference session to present at the PASS SQLRally, May 11, 2011 in Orlando, FL. My session is entitled Leadership and Team Management Skills for the Database Professional. If you've ever attended my 1-hr professional development session at the PASS Summit, which has scored highest in the professional development track, then you've seen a preview of what we'll be covering over the course of the full day. During the session I will discuss how most IT leaders earned their promotions based on technical competency, not on leadership or managerial skills. Technical … [Read more...]
Filed Under: Conferences, Opinion, Presentations, Professional Development, SQLServerPedia Syndication Tagged With: Career, Management, Professional Development, Training
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
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...]
Filed Under: Administration, Challenges, Hardware, IO, Opinion, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tool Time, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts, Video
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...]
Filed Under: Challenges, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming, Video Tagged With: Best Practices, DBA, Developer, SQL Server 2005, Tools & Scripts, Transact-SQL Programming, Video
The State of the Internet Operating System
Tim O'Reilly has written a two part post on his thoughts on the internet operating system. If you're not familiar with Tim, you should be. Part one is here. Part two is here. … [Read more...]
Filed Under: Cloud, Cool Technologies, Interviews, Opinion, Presentations, SQLServerPedia Syndication, Trends, Video, Virtualization Tagged With: news analysis, Video, Web Development
See You in St Louis, and then London, Amsterdam, Copenhagen, Stockholm, and York, UK
Good grief, there's a lot of travel in my immediate future. <sigh ... deep breath> It'll be exhausting and it'll be hard to lose so much time with the family. But if I'm able to avoid travel mishaps, it'll be fun. Meet Me In St. Louis I'll be speaking in St. Louis, MO on Tuesday, September 14th for their mid-day meeting. The details, as I have them, are: Tuesday, September 14, 2010 1-4pm Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO … [Read more...]
Filed Under: Conferences, Databases, Presentations, Professional Development, SQL Server, SQLServerPedia Syndication Tagged With: DBA, Developer, Events, SQL Server 2008 R2, Training
Free Poster – SQL Server PerfMon Counters
You Needs It! You Wants It! We all know how hard troubleshooting SQL Server can be. There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor. The only problem with SysMon, or more commonly "PerfMon", is that it takes a lot of knowledge and experience to know which objects and counters to examine. I've put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes. You Can Has It Fer … [Read more...]
Filed Under: On-Line Resources, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, SQL Server 2008 R2, Tools, Training, Troubleshooting
Video: Worth Upgrading to SQL Server 2005
Why companies should upgrade their databases to SQL Server 2005. Please forgive posting this old video. Many of the tips are still worth paying attention to since SQL Server 2005 features and technologies are the foundation of subsequent releases. Posted December 19, 2006. … [Read more...]
Filed Under: Opinion, Presentations, Professional Development, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, SQL Server 2005
