{"id":659,"date":"2005-09-18T22:51:21","date_gmt":"2005-09-18T22:51:21","guid":{"rendered":"\/blogs\/kimberly\/post\/PDC-Pre-conference-Workshop-Resourcesand-what-a-list-it-is!.aspx"},"modified":"2020-12-11T10:40:42","modified_gmt":"2020-12-11T18:40:42","slug":"pdc-pre-conference-workshop-resources-and-what-a-list-it-is","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/pdc-pre-conference-workshop-resources-and-what-a-list-it-is\/","title":{"rendered":"PDC Pre-conference Workshop Resources…and what a list it is!"},"content":{"rendered":"

Brian A. Randell’s Blog: http:\/\/www.mcwtech.com\/CS\/blogs\/brianr\/default.aspx<\/a>
MCWTechnologies Website: http:\/\/www.mcwtech.com\/<\/A><\/P>
\n

Kimberly L. Tripp’s Blog: http:\/\/www.SQLskills.com\/blogs\/Kimberly<\/a>
SQLskills Website: http:\/\/www.SQLskills.com<\/A><\/P>
\n

Presentation Resources<\/STRONG>
<\/FONT>Presentation in PDF form<\/a>
Kimberly’s Demo Scripts<\/a>
Brian’s Demo Scripts and Code<\/a><\/P>
\n

Running SQL Server 2000 tools and SQL Server 2005 tools side-by-side<\/FONT>
<\/STRONG>We talked about re-registering all of your COM components and I didn’t have a slide for this. So, if SQL Server 2000 Enterprise Manager crashes when you try to access database properties OR SQL Server 2000 Query Analyzer doesn’t seem to do the color coding correctly, then you need to re-register your COM componenets in BOTH of the following directories:
   c:\\program files\\microsoft sql server\\80\\tools\\binn 
   c:\\program files\\microsoft sql server\\mssql\\binn<\/P>
\n

To re-register the components, execute: FOR %i IN (*.dll) DO regsvr32 \/s %i<\/STRONG><\/FONT><\/P>
\n

Resources and Presentations on Indexing Best Practices<\/STRONG>
<\/FONT>First, start by reviewing the blog entries listed in the Indexes category here<\/a>.
As for the Webcasts – there are 6 from which to choose! Each webcast has an associated Q&A posted to my blog – make sure to look for the Q&As. Usually they are posted within 1 week (give or take <\/EM>:) from the actual webcast.
   MSDN Webcast: Indexing for Performance – Finding the Right Balance (SQL Server 2000)<\/a>, recorded 11 June 2004
   MSDN Webcast: Indexing for Performance – Index Maintenance Best Practices (SQL Server 2000)<\/a>, recorded 19 July 2004
   TechNet It\u2019s Sh0wtime Webcast: Index Creation Best Practices with SQL Server 2005<\/a>, recorded at Tech Ed Amsterdam, July 2005
   TechNet It\u2019s Sh0wtime Webcast: Index Defragmentation Best Practices with SQL Server 2005<\/a>, recorded at Tech Ed Amsterdam, July 2005
   MSDN Webcast Series: Part 4 of 10, Best Practices in Indexing<\/a>, recorded 26 August 2005
   MSDN Webcast Series: Part 5 of 10, New Features in Indexing and Index Maintenance Best Practices<\/a>, recorded 2 September 2005<\/P>
\n

MSDN Webcast Series: Building Highly Reliable and Available Systems with SQL Server 2005<\/FONT>
<\/STRONG>Watch one on-demand and\/or sign up to attend one of the remaining!<\/P>
\n


\n

Part 1: Creating a Recoverable Database<\/o:p><\/STRONG><\/FONT><\/SPAN><\/P>
\n

      For the MSDN Download for Part 1, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>. <\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

      For the SQLskills Blog Entry for Part 1, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.  <\/o:p><\/FONT><\/SPAN><\/P>
\n

 <\/o:p><\/FONT><\/SPAN><\/P>
\n

Part 2: Creating a Reliable and Automated Backup Strategy<\/o:p><\/STRONG><\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>    For the MSDN Download for Part 2, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

      For the SQLskills Blog Entry for Part 2, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>. <\/o:p><\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/o:p><\/SPAN><\/P>
\n

Part 3: Designing Tables that Scale, Best Practices in Data Types and Initial Table Structures<\/o:p><\/STRONG><\/FONT><\/SPAN><\/P>
\n

      For the MSDN Download for Part 3, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

      For the SQLskills Blog Entry for Part 3, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>. <\/o:p><\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/o:p><\/SPAN><\/P>
\n

Part 4: SQL Server Indexing Best Practices<\/STRONG><\/FONT><\/SPAN><\/P>
\n

      For the MSDN Download for Part 4, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

      For the SQLskills Blog Entries for Part 4<\/FONT><\/SPAN><\/P>
\n

         Resource links blog entry, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/P>
\n

         Q&A blog entry, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/SPAN><\/P><\/BLOCKQUOTE>
\n

<\/o:p><\/SPAN>         Part 5: SQL Server Index Defrag Best Practices
         <\/STRONG><\/FONT><\/SPAN>      For the MSDN Download for Part 5, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.
               <\/FONT><\/SPAN>For the SQLskills Blog <\/FONT><\/SPAN>entry, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/SPAN><\/P><\/o:p><\/SPAN>
\n

         Part 6: SQL Server Mixed Workloads, Secondary Databases, Locking and Isolation
         <\/STRONG><\/FONT><\/SPAN>      For the MSDN Download for Part 6, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P><\/SPAN><\/o:p><\/SPAN>
\n

         Part 7: Understanding Plan Caching and Optimizing Procedure Performance 
         <\/STRONG><\/FONT><\/SPAN>      To register to attend, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

         Part 8: Data Loading and Aging Strategies<\/STRONG> 
         <\/STRONG><\/FONT><\/SPAN>      For the MSDN Download for Part 6, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

         Part 9: Profiling for Better Performance 
         <\/STRONG><\/FONT><\/SPAN>      For the MSDN Download for Part 6, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

         Part 10: Most Common Roadblocks to Scalability and Reliability 
         <\/STRONG><\/FONT><\/SPAN>      For the MSDN Download for Part 6, click <\/FONT>here<\/FONT><\/SPAN><\/B><\/a>.<\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

Profiling SQL Server and Creating a Server-side Trace
<\/STRONG><\/FONT><\/FONT>INF: How to Create a SQL Server 2000 Trace (283790)<\/a>
<\/FONT><\/SPAN><\/o:p><\/SPAN>HOW TO: Programmatically Load Trace Files into Tables (270599)<\/a><\/FONT><\/SPAN><\/o:p><\/SPAN>
How To: Stop a Server-Side Trace in SQL Server 2000 (822853)<\/a>
<\/FONT><\/SPAN><\/o:p><\/SPAN>INF: How to Monitor SQL Server 2000 Traces (283786)<\/a>
<\/FONT><\/SPAN><\/o:p><\/SPAN>INF: Stored Procedure to Create a SQL Server 2000 Blackbox Trace (281671)<\/a>
<\/FONT><\/SPAN><\/o:p><\/SPAN>BUG: BOL Incorrectly States That Users Do Not Need to Be Sysadmin to Use Profiler or SQL Profiler SPs (310175)<\/a> 
   NOTE: This is ONLY a SQL Server 2000 limitation.
<\/FONT><\/SPAN><\/o:p><\/SPAN>INF: Job to Monitor SQL Server 2000 Performance and Activity (283696)<\/a>
Support WebCast: SQL Server 2000 Profiler: What’s New and How to Effectively Use It<\/a><\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

Great KB to Start with for Troubleshooting
<\/FONT><\/STRONG><\/SPAN><\/o:p><\/SPAN>HOW TO: Troubleshoot Application Performance with SQL Server<\/a><\/FONT><\/SPAN><\/o:p><\/SPAN><\/P>
\n

What about Whitepapers – we referenced quite a few!<\/FONT>
<\/STRONG>Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005<\/a> <\/EM>by Brian A. Randell <\/EM><\/FONT>
<\/STRONG>SQL Server 2005 Beta 2 Transact-SQL Enhancements<\/EM><\/FONT><\/a> <\/EM>by Itzik Ben-Gan<\/FONT><\/FONT> 
<\/STRONG>SQL Server 2005 Partitioned Tables and Indexes<\/EM><\/a> by Kimberly L. Tripp
SQL Server 2005 Snapshot Isolation<\/EM><\/a> by Kimberly L. Tripp
<\/FONT><\/FONT><\/SPAN><\/o:p><\/SPAN>SQL Server 2005: the Database Administrator\u2019s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment<\/EM><\/FONT><\/a> <\/EM>by Kimberly L. Tripp<\/P>
\n

<\/FONT><\/FONT><\/SPAN><\/o:p><\/SPAN>Other Whitepapers, Websites, and Webcasts
<\/FONT><\/STRONG><\/FONT><\/SPAN><\/o:p><\/SPAN><\/SPAN><\/o:p><\/SPAN>Blog Entry: 8 Steps to Better Transaction Log Throughput<\/a><\/FONT><\/SPAN><\/o:p><\/SPAN>
MSDN Whitepaper: An Overview of SQL Server 2005 for the Database Developer<\/a><\/I>
MSDN Whitepaper: Processing XML Showplans Using SQLCLR in SQL Server 2005<\/a><\/I>
MSDN Whitepaper: Using CLR Integration in SQL Server 2005<\/a><\/I>
MSDN Whitepaper: XML Support in Microsoft SQL Server 2005<\/a><\/I>
MSDN Whitepaper: XML Options in Microsoft SQL Server 2005<\/a><\/I>
MSDN Whitepaper: What’s New in FOR XML in Microsoft SQL Server 2005<\/a><\/I>
MSDN Whitepaper: XML Best Practices for Microsoft SQL Server 2005<\/a><\/I>
MSDN Whitepaper: Usage Scenarios for SQL Server 2005 Native Web Services<\/a><\/I>
MSDN Whitepaper: Managed Data Access Inside SQL Server with ADO.NET and SQLCLR<\/a><\/I>
MSDN On-demand Webcasts<\/a> 
<\/SPAN>MSDN Live Webcasts<\/a> 
<\/SPAN>SQL Server 2005 Hands-On Labs<\/a>
          <\/SPAN>SQLCLR Hands-On Lab Manual<\/a>
Microsoft SQL Server TechCenter on TechNet<\/a>
Sample Book Chapters for SQL Server 2005<\/a> is a list of chapters posted from a variety of authors for books related to SQL Server 2005.
Hosting the .NET Runtime in Microsoft SQL Server<\/a><\/I> on the Association for Computing Machinery (www.ACM.org). To access this article you need membership in SIGMOD, the ACM, or you can purchase just this article for download.
Service Oriented Database Architecture<\/a><\/I> by David Campbell, also on the Association for Computing Machinery (www.ACM.org). To access this article you need membership in SIGMOD, the ACM, or you can purchase just this article for download.<\/P>
\n

Gert E.R. Drapers’ website<\/A>
Microsoft SQL Server Development Customer Advisory Team<\/a>
PDC Information Site<\/a><\/P>
\n

Well, if that doesn’t keep you busy, I don’t know what will! <\/P>
\n

Enjoy!
Kimberly<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

Brian A. Randell’s Blog: http:\/\/www.mcwtech.com\/CS\/blogs\/brianr\/default.aspxMCWTechnologies Website: http:\/\/www.mcwtech.com\/ Kimberly L. Tripp’s Blog: http:\/\/www.SQLskills.com\/blogs\/KimberlySQLskills Website: http:\/\/www.SQLskills.com Presentation ResourcesPresentation in PDF formKimberly’s Demo ScriptsBrian’s Demo Scripts and Code Running SQL Server 2000 tools and SQL Server 2005 tools side-by-sideWe talked about re-registering all of your COM components and I didn’t have a slide for this. So, if SQL […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,58,65],"tags":[],"class_list":["post-659","post","type-post","status-publish","format-standard","hentry","category-events","category-resources","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=659"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/659\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}