Search SSWUG.ORG:

EXPERT SESSIONS

Best Practices
by: TJ Belt

Having worked with databases for some time now, I felt it important to get some best practices documented. This presentation will touch on the simple things that we often take for granted while using our favorite database systems. From naming conventions, to cursors, to temporary, derived and variable tables, to the use of dynamic sql. We’ll touch on a great many different ideas and hopefully further cement your own best practices, making you a more exceptional DBA or Database Developer.

Download for only $6.95  

End-to-End Troubleshooting for SQL Server 2005
by: Kevin Kline

Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate: - Performance Monitor (PerfMon) - SQL Profiler/Server-side Trace - Correlating PerfMon and Profiler results - Graphic Explain Plan and Transact-SQL Showplan - SQL Server 2005 and 2008 DMVs - When to use Trace Flags These tools and techniques can make your long days shorter and make difficult troubleshooting activities much faster and easier. Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need these skills to do it.

Download for only $6.95  

Introduction to SQL Server Analysis Services
by: Brian Knight

Is your customer looking for drag and drop reports or capabilities inside of Excel. SQL Server Analysis Services (SSAS) is the answer for you then. You’ll be amazed how quickly you can develop sophisticated reports after watching the basics of this session.

Download for only $6.95  

Introduction to SQL Server Integration Services
by: Brian Knight

SQL Server Integration Services has a bit of a learning curve. It is especially confusing if you have worked with the previous ETL tool, DTS. Learn how to use SSIS from one of the authors of the Wrox SSIS book.

Download for only $6.95  

Maintenance Plans
by: Thomas LaRock

In SQL 2008, Maintenance Plans create a workflow of tasks to ensure your database is optimized and backed up on a regular schedule. The Maintenance Plan will create an SSIS package that will be scheduled and run with SQL Agent. Attend this session and learn how Maintenance Plans will ease your administrative overhead.

Download for only $6.95  

SQL 101 -- The Essentials
by: Jeremy Lowell

If you are new to SQL or a DBA interested in learning the t-sql language, this is a great place to start. We will cover the basics, as time allows for. Topics to include DML statements (select, insert, update, and delete).

Download for only $6.95  

SQL 103 – The Essentials – DMV’s & t-sql for internals.
by: Jeremy Lowell

If you have ever wondered what some of those 286 system views are in your user database, this is for you! We will cover a handful of these views, also known as DMV’s. They contain data that every DBA should smile about and be able to understand. We will also look at some t-sql that will provide you with information about what’s going on with your SQL Server.

Download for only $6.95  

Surviving the Data Avalanche
by: Kevin Kline

The SQL Server database platform is hosting larger and larger databases. But the industry term “Very Large Database” (VLDB) is more difficult to define than ever with multi-terabyte database becoming very common. This session will answer questions like: - How do I configure my SQL Server instances to support multi-terabyte databases? - What risks and problems do VLDBs pose? - How do I overcome issues presented by VLDBs? Administrating and protecting very large databases is extremely difficult and very hard to learn except through direct experience. This session helps you learn from the experiences of others so that you can apply their lessons learned and mitigate your risks before you ever experience them.

Download for only $6.95