Quest Software http://www.quest.com 3091 http://www.linkedin.com/in/brentozar Chicago, IL Brent Ozar http://www.brentozar.com 4.84 /avatars/3091/thumb/stream.26216.0 2010-02-26T15:05:39+00:00 319 2188 SQL Server's Dynamic Management Views (DMVs) have some limitations. They don't reset until your SQL Server service restarts, and they don't give you good trending information. SQL Server 2008's new Management Data Warehouse improves on the DMVs, but we're not all on 2008, and we don't all use Enterprise Edition. Learn how to get better information from the DMVs with your existing servers by playing doctor. http://sqlserverpedia.com/wiki/DMVs http://www.quest.com/virtualtrainingbroz 2010-02-26T15:05:39+00:00 2010-03-03T15:00:00+00:00 4.78 2010-02-26T15:03:49+00:00 319 2187 SQL Server is constantly watching queries and taking notes about what indexes could have made the queries - and which ones aren't helping at all. Learn how to use the Dynamic Management Views (DMVs) to build better indexes and dump the ones you don't need. http://sqlserverpedia.com/wiki/DMVs http://www.quest.com/virtualtrainingbroz 2010-02-26T15:03:49+00:00 2010-03-03T14:00:00+00:00 4.77 2010-02-26T15:02:05+00:00 319 2186 SQL Server gives us signs about what's going on inside the database engine. Learn to use the Dynamic Management Views (DMVs) to find out what's happening and how you can make it faster. http://sqlserverpedia.com/wiki/DMVs http://www.quest.com/virtualtrainingbroz 2010-02-26T15:02:05+00:00 2010-03-03T13:00:00+00:00 4.8 2010-02-08T21:31:00+00:00 2107 SQL Server can run great in virtual environments like Microsoft Hyper-V and VMware vSphere, but you can dramatically increase the odds of success if you know which knobs to tweak. Just like SQL Server, virtualization software doesn't always work best with the default settings, and knowing which settings change SQL Server performance is key. In this session, Brent will explain: - Why virtual CPUs, memory, and storage are different - Hidden gotchas that often hurt virtual performance - How to stress test your virtual server to find limits Chicago, IL http://virtualization.sqlpass.org 2010-02-08T21:31:00+00:00 2010-02-09T11:00:00+00:00 4.95 2009-10-20T19:04:36+00:00 216 1602 Learning Performance Monitor and Profiler are the first step in performance tuning. Brent Ozar will show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends. Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results. Attendees will learn why Perfmon is like a Nissan GT-R’s dashboard, how to interpret the best Perfmon counters, and how to use free tools like ClearTrace and data mining to take your tuning to the next level. http://sqlbits.com/ 2009-10-20T19:04:36+00:00 2009-11-21T07:00:00+00:00 2009-11-20T11:31:55+00:00 216 1851 Colin Chapman was a true Formula 1 pioneer whose innovations included the aerodynamic wing spoiler. Enzo Ferrari once said, "Aerodynamics are for people who can't build engines." The Stig, well, he never says anything out loud, but his actions speak volumes. In this session, Brent will use quotes and lessons from racing icons like Chapman, Enzo Ferrari, and The Stig to illustrate SQL Server performance tuning concepts. Find out how to "add lightness" to your database by using DMVs to eliminate unneeded indexes, how to get out of the pits faster with Database Mirroring, and why skipping performance monitoring is like overdriving your headlights. http://sqlbits.com 2009-11-20T11:31:55+00:00 2009-11-20T11:30:00+00:00 2009-10-20T19:04:05+00:00 216 1601 Colin Chapman was a true Formula 1 pioneer whose innovations included the aerodynamic wing spoiler. Enzo Ferrari once said, “Aerodynamics are for people who can’t build engines.” The Stig, well, he never says anything out loud, but his actions speak volumes. In this session, Brent will use quotes and lessons from racing icons like Chapman, Enzo Ferrari, and The Stig to illustrate SQL Server performance tuning concepts. Find out how to “add lightness” to your database by using DMVs to eliminate unneeded indexes, how to get out of the pits faster with Database Mirroring, and why skipping performance monitoring is like overdriving your headlights. http://sqlbits.com/ 2009-10-20T19:04:05+00:00 2009-11-20T07:00:00+00:00 5.0 2009-10-20T19:02:31+00:00 215 1600 There’s a lot of hype around cloud-based databases. After you get past the knee-jerk reaction about security, what else matters? Is it time to buy in, and what should you watch out for? Brent explains some of the pros and cons hes experienced running SQL Servers in the cloud, and will demonstrate how easy it is to fire up a new SQL Server in the cloud. 2009-10-20T19:02:31+00:00 2009-11-05T13:00:00+00:00 2009-10-20T19:01:05+00:00 215 1598 Developers and accidental DBAs: if you know more about how SQL Server handles crashes and disasters, you’ll be able to make a better decision about how to prepare. In this session, I will cover all of SQL Servers backup and high availability options at a high level, including clustering, log shipping, mirroring, replication and more. I’ll show the pros and cons of each, and teach you how to pick the right method for your application. We won’t have enough time to dive into actual implementation demos due to the number of solutions we’ll cover, but we’ll show screen shots and give links to the best resources for each method. 2009-10-20T19:01:05+00:00 2009-11-04T13:30:00+00:00 2009-10-20T19:00:09+00:00 215 1597 SQL Server 2005 introduced Dynamic Management Views (DMVs), an easier method for monitoring activity and performance. They replace the need to query the system tables or using other awkward methods of retrieving system information that you had to use with SQL Server 2000. Now’s your chance to explore one of the most popular SQL Server topics of the year with a panel of prominent experts from the world’s leading companies. – Join us for this free breakfast event at PASS* as we discuss: “Simplify SQL Server Management with DMVs – the Experts’ Perspective.” This panel of experts from Quest Software, Microsoft, Compass Technology and Spectrum Health Hospital System, will explore some of the most popular DMVs and show you some of their favourites. You will leave with a full stomach – and the knowledge you need to make the most of DMVs to simplify your ability to retrieve system information! Featured Panellists: Buck Woody, Program Manager, SQL Server, Microsoft Brent Ozar, SQL Server MVP and Domain Expert, Quest Software Kevin Kline, SQL Server MVP and Technical Strategy Manager, Quest Software Louis Davidson, SQL Server MVP and Senior Data Architect, Compass Technology Tim Ford, SQL Server MVP and Senior Database Administrator, Spectrum Health Hospital System http://www.quest.com/events/listdetails.aspx?contentid=10429&technology=34&prod=&prodfamily=&loc= 2009-10-20T19:00:09+00:00 2009-11-04T07:00:00+00:00 2009-11-13T01:55:00+00:00 215 1788 SQL Server 2005 introduced Dynamic Management Views (DMVs), an easier method for monitoring activity and performance. They replace the need to query the system tables or using other awkward methods of retrieving system information that you had to use with SQL Server 2000. Now’s your chance to explore one of the most popular SQL Server topics of the year with a panel of prominent experts from the world’s leading companies. This panel of experts from Quest Software, Microsoft, Compass Technology and Spectrum Health Hospital System, will explore some of the most popular DMVs and show you some of their favorites. You will gain the knowledge you need to make the most of DMVs to simplify your ability to retrieve system information! http://www.quest.com/events/listdetails.aspx?contentid=10617&technology=34&prod=&prodfamily=&loc= 2009-11-13T01:55:19+00:00 2009-11-04T07:00:00+00:00 2009-10-20T19:01:48+00:00 215 1599 Until a few years ago, the online SQL Server community consisted of Usenet newsgroups, mailing lists and forums. Conversations were mostly, “I have a problem” and “Here is the fix”. In this session, you will learn what new services are available, how to leverage them to build your professional network, get involved in the SQL community and, most importantly, do your job better. We will focus on the mainstay services of the forward thinking IT professional but will also give you a glimpse of the bleeding edge. Be prepared for an interactive session that will involve the worldwide online SQL Server community in real time. We won’t just tell stories about how social networking helped us do our jobs better – we’ll show how it works in real time. We’ll show you how database professionals all over the world are staying in touch with the PASS Summit even as we’re presenting. 2009-10-20T19:01:48+00:00 2009-11-03T16:30:00+00:00 2009-10-20T18:46:31+00:00 200 1592 Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company. Maybe it’s time to switch careers, and I have just the thing. Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server performance tuner! In this session, I will show you: - Why Colin Chapman would check for indexes before adding new ones - The importance of well-tested safety gear to performance tuning - Why not monitoring your servers is like overdriving your headlights - Just like races are lost in the pits, uptime records are lost during maintenance windows 2009-10-20T18:46:31+00:00 2009-10-21T10:00:00+00:00 4.95 2009-10-20T18:47:18+00:00 200 1593 You’ve heard it before: “It worked fine on my machine, but the users say it’s too slow.” Don’t blame the developers: they’re using SQL Server features that look great on paper, but in reality, they won’t scale up to production loads. Learn to recognize these common mistakes before they go into production, and be armed with easy fixes for: - User-defined functions that go through too much data - Triggers that perform business logic - Cursors that process data row by row 2009-10-20T18:47:18+00:00 2009-10-21T10:00:00+00:00 4.8 2009-10-20T18:47:56+00:00 200 1594 SQL Server does indeed work in virtual environments: the catch is that it doesn’t always work *well*. After years of working with SQL Servers running inside VMware and Hyper-V, I’ve gained valuable experience and learned some ugly lessons that I’ll pass on to you during his session. In this session, I will show you: - Why your sysadmins want to virtualize your servers - The pros and cons of moving your SQL Servers into virtualization - How to monitor your server performance after you make the switch 2009-10-20T18:47:56+00:00 2009-10-21T10:00:00+00:00 4.75 2009-10-20T18:49:50+00:00 214 1595 Scared to touch that SQL Server database? You can do it, and we can help. In this webcast, our SQL Server experts will show Windows administrators how to manage SQL Server with confidence. The experts will cover the basics of backup and restore, security and permissions, and performance tuning. Plus, they will show how a favorite Windows performance tool can help manage SQL Server. 2009-10-20T18:49:50+00:00 2009-10-21T06:00:00+00:00 2009-10-20T18:50:24+00:00 214 1596 Mystified by why your queries are running slow? Don’t be stumped – learn what the fancy diagrams mean and how to make your schema work for you. Grant Fritchey, author of SQL Server Query Performance Tuning Distilled, will boil down the basics in this one-hour session. 2009-10-20T18:50:24+00:00 2009-10-21T06:00:00+00:00 2009-10-09T20:14:12+00:00 202 1553 How to tune indexes for SQL Server 2005 and 2008. http://www.slideshare.net/SQLServerPedia/advanced-index-tuning-for-sql-server 2009-10-09T20:14:12+00:00 2009-10-09T13:30:00+00:00 4.5 2009-10-09T17:28:46+00:00 202 1552 About SQL Server on Storage Area Networks. http://www.slideshare.net/SQLServerPedia/sql-server-on-sans 2009-10-09T17:28:46+00:00 2009-10-09T10:00:00+00:00