![ITForum.gif](\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/itforum.gif\")
<\/a><\/P>\n
<\/P>
\n
<\/P>
\n
<\/P>
\n
OK, so after SQL Connections<\/a> in Las Vegas, Paul<\/a> and I head off to Barcelona for the second week of TechEd’s two week event (week one for developers and week two for IT professionals). November’s definitely a busy month. So, if you’re in the US – we hope to see you at Connections and if you’re in Europe, we hope to see you at Microsoft TechEd ITForum 2007<\/a>. <\/P> <\/P> Here’s what we’re doing:<\/P><\/FONT> Sessions<\/FONT><\/STRONG><\/P> The next release of SQL Server will contain exciting new manageability features targeted at reducing total cost of ownership. Come learn more about what’s in store in areas like policy-driven administration and performance data collection and analysis. The session focuses on the database engine.<\/FONT><\/P><\/BLOCKQUOTE> Knowing tips and tricks to indexing is extremely helpful and will help you to solve “known” query problems. But what’s lurking in the unknown? Is SQL Server using your indexes? Or, do you have a bunch of indexes sitting around wasting space and negatively impacting performance? Finally, SQL Server 2005 has an answer! SQL Server 2005 DMVs (Dynamic Management Views) can provide you with valuable information about your current indexing strategies, what should be removed, and even what’s missing. Do you know how to find this information, leverage it, and then programmatically respond to it? Come to this session to learn a few tips and tricks as well as how to figure out the unknown indexing problems!<\/FONT><\/P><\/BLOCKQUOTE> How can you tell whether your data is corrupt? If you have corruption, how do you work out what\u2019s wrong with the database? How do you ensure you have a valid backup? If you don\u2019t have a valid backup, how and what do you repair? If you do have a backup, how do you work out whether you should restore or repair? And at what granularity? How do you go about determining what went wrong in the first place? It\u2019s all about limiting downtime and data-loss when a corruption occurs – from knowing the tools to understanding the choices to planning a successful strategy. Some of the features discussed: Facing database corruption is almost inevitable in every DBAs career – make sure you’re prepared when it happens to you.<\/FONT> Chalk-talks<\/FONT><\/STRONG><\/P> Even though SQL Server 2005 has been out for a while, many companies are only just getting ready to upgrade. Come to this session to learn best practices, tips, and tricks distilled from two years of customer experiences. We’ll also touch on some issues you’ll face going to SQL Server 2008 when it’s released next year. Come to this session to learn and share – bring your questions and experiences!<\/FONT><\/P><\/BLOCKQUOTE> Database Mirroring is one of the most exciting technologies in SQL Server 2005. With more and more people including it in their Disaster Recovery Strategies, it’s important to know when to implement Database Mirroring as well as the implications of the architecture you choose. In this session there will be no slides just demos that will explore how Database Mirroring works in its various configurations and how that may effect your performance. Join us and see database mirroring in action and get your questions answered!<\/FONT><\/P><\/BLOCKQUOTE> All DBAs should have heard of (and used) DBCC \u2013 especially for consistency checking. Get down deeper than 400-level with this session on how some of the most important DBCC commands work. Topics covered include CHECKDB, SHRINKFILE, INDEXDEFRAG, and more. Instructor-led labs<\/FONT><\/STRONG><\/P> See Database Mirroring in action! From implementation to monitoring to failover, database mirroring provides an ideal solution for many disaster recovery scenarios and this session will prepare you to handle them with minimal downtime or data loss.<\/FONT><\/P><\/BLOCKQUOTE> Database Snapshots are useful in many situations: database maintenance, data recovery, and point-in-time data access. You can even create a snapshot on a mirror database to get better return-on-investment (ROI) on your high-avaialbility (HA) investments. In this session we will explain how database snapshots work as well as go through several exercises, including working with multiple database snapshots and creating database snapshots on a mirror database.<\/FONT><\/P><\/BLOCKQUOTE> The bane of any DBA’s life is to have to take data offline to perform maintenance or recover from a disaster. The various Online Operations in SQL Server 2005 alleviate much of this frustration. This session will show you how to move a table online for better isolation and control, partition a table online, access a database that’s partially damaged, and perform online piecemeal restore.<\/FONT><\/P><\/BLOCKQUOTE> Lunchtime Demos<\/FONT><\/STRONG><\/P> In this fast-paced demo session nasty things will be done repeatedly to database. Then the methods and approaches to recovery will be shown. Not for the faint-hearted!<\/FONT><\/P><\/BLOCKQUOTE>
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/P><\/FONT>
\n
\n
\n
\n
\n
\n
\n
<\/FONT><\/P><\/BLOCKQUOTE>
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/FONT><\/P><\/BLOCKQUOTE>
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n