 October 22, 2009 - Execution Extract, Transform, and Load your Data Warehouse by Jessica M. Moss.
One data warehouse buzzword that often gets used is "ETL", also known as extract, transform, and load. But what does this really mean from a data warehousing perspective and how do we use SQL Server Integration Services to perform these ETL functions? This session will answer these questions and show solutions to common ETL problems.
View Meeting Presentation >>
|
 August 27, 2009 - Execution Plan Caching and Reuse by Alejandro Mesa presents.
In this presentation, Alejandro is going to talk about how batches are cached and reused (SS 2005 / 2008), and a review of best practices on maximizing reuse of cached plans.
View Meeting Presentation >>
|
 July 16, 2009 - Inside SQL Server 2008 Resource Governor by Aaron Bertrand.
In this presentation, Aaron will provide an overview of Resource Governor, a new feature in SQL Server 2008 that will give DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He will explain how you can leverage SQL Server 2008's Resource Governor not only for preventing the "runaway query" but also for prioritizing workloads, testing consolidation approaches, meeting service level agreements, and configuring a chargeback system. Aaron will also provide information about what you cannot or should not do with Resource Governor. This presentation is the basis of an upcoming whitepaper to be published soon.
View Meeting Presentation >>
|
 May 28, 2009 - Inside SQL Server Policy-Based Management by Geoff Hiten.
This meeting explained how to scale your DBA efforts across an entire SQL Infrastructure. Policy-based management is a new tool in the SQL Server product that allows you to define how you want your systems to be instead of taking individual actions on individual servers.
View Meeting Presentation >>
|
 March 17, 2009 - DTS to SSIS by Brian Knight.
The Microsoft "End of Life" policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS.
View Meeting Presentation >>
|
February 17, 2009 - Fortress SQL Server by K. Brian Kelley.
This meeting looked at the best practices for securing SQL Server and the data contained within from both a DBA and developer perspective. Starting with the basics of how to relate security issues to business personnel, it then dove in to the technical aspects of locking down SQL Server. The various SQL Server versions from 2000 through 2008 were covered.
View Meeting Presentation >>
|
January 15, 2009 - Server 2008 Firestarter Event.
The SQL Server 2008 Firestarter event is a 1/2 day, free event for SQL Server developers and administrators. You'll be able to learn about the newest features in SQL Server 2008, and how you can leverage them to improve your existing applications. Developer topics will include the new features in T-SQL. including the new data types for dates, times, and spatial values. BI Developers will be interested in the sessions on SQL Server Analysis Services improvements and how they can speed the development of OLAP cubes. New features in Reporting Services 2008 will also be covered. For administrators, server consolidation options and the new policy based management framework will be reviewed.
• Improvements in T-SQL
• Accelerating SSAS Design and Performance -
• Policy-Based Management and Multi-Server Administration
• SQL Server 2008: Enabling Consolidation for the Enterprise
• Creating More Flexible and Richer Reports in SSRS 2008
This event is being sponsored by Microsoft and the Charlotte and Greenville chapters of PASS. We will have several SQL Server MVPs present, so it will be great opportunity to learn more about SQL Server.
|
 November 26, 2008 - Tips and Tricks for Writing Better Queries by Joe Webb.
Joe is a renowned SQL Server expert and former PASS Board Member.
Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we'll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.
View Meeting Presentation >>
|
 October 22, 2008 - Fast Times at SQL Server High: Data Management Inside a NASCAR Race Team by Andy Korczynski.
Andy is an experienced SQL Server developer and software engineer. He has five years experience in Champ Car Series at Newman Haas Racing where he contributed to their three championships. Andy moved to the Charlotte area three years ago to work for NASCAR's Robert Yates Racing. Andy is currently a software engineer for Red Bull Racing. SQL server has always been the backbone of the various applications he has developed for the auto racing environment.
View Meeting Presentation >>
|
 October 1, 2008 - Introducing Resource Governor by Jason Hall.
Jason Hall is an MCSE, MCSD and MCPD with over 10 years of history in SQL Server related development work. Currently he is a Sr. Software Developer at SQL Sentry Inc., and has worked on projects at places like Wachovia Bank (before it was First Union too), JC Penney and the Annuity Board for the Southern Baptist Convention. Jason was a US Army Paratrooper at Ft. Bragg before he started working in IT and he spent a year on tour with the 82nd Airborne All American Chorus as well.
View Meeting Presentation >>
|
 August 20, 2008 - Introducing SQL Server 2008 Performance Data Collector by Brad McGehee.
Brad McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 10 years’ SQL Server experience. Having founded the popular community site SQL-Server-Performance.Com, where he now acts as the technical editor and forum moderator, Brad specializes in SQL Server Administration, Performance Tuning, and High Availability. He regularly consults with multiple clients, helping them to get the most out of SQL Server.
View Meeting Presentation >>
|
 March 19, 2008 - Automating Perfmon & Trace by Andrew Kelly.
Andrew Kelly, SQL Server MVP and noted SQL performance expert, has over 15 years experience with relational databases and application development on both Unix and Windows platforms. He currently does high level training and SQL Server consulting with many different clients throughout the world.
|
 February 27, 2008 - Transactional Replication for Beginners by Andy Warren.
Andy Warren is a noted SQL Server Guru, a cofounder of SQLServerCentral.com, accomplished PASS speaker and currently partner in End to End Training. Andy had a good time introducing this potentially intimidating technology by showing attendees how simple it can be to use. Here is Andy's blog IT Depends where he posted twice about his visit.
View Meeting Presentation >>
|
 February 7, 2008 - Ashton Hobbs, SQL Server MVP, author and developer of ApexSQL Edit shared his insights on "Performance Point Server Dashboards." This new Business Intelligence offering from Microsoft has the goal of making BI more accessible to end users. Ashton's presentation detailed the creation of monitoring components in Performance Point Server and showed some product features and their limitations. It also showed steps to using custom components that create new dashboard pieces which can improve the visual and usability aspects of your own dashboards.
View Meeting Presentation >>
|
 November 28, 2007 - John Welch, Chief Architect with Mariner and noted SQL Server speaker shared his insights on "Performance Tuning in SSIS." John showed some general best practices for performances. He covered many details of performance optimization for SSIS data flows, including optimizing execution trees, managing buffer size, and evaluating performance metrics to determine where the bottlenecks are. Also covered were the logging options and performance counters that can be used to monitor performance.
View Meeting Presentation >>
|
 October 16, 2007 - Rick Heiges, SQL Server MVP and PASS Board of Directors member presented the "64-bit Question." Rick showed why you should consider 64-bit SQL Server now and what are some immediate benefits. He covered the differences between IA64 and x64 and a comparison of current and expected 64-bit offerings. The presentation closed with a discussion of 64-bit SQL Server 2000/2005 as well as a peak at Katmai and consolidation.
View Meeting Presentation >>
|
 September 27, 2007 - Brian Knight, Author and SQL Server MVP talked about the good, the bad, and the ugly of DTS migrations in his presentation, "Converting DTS to SSIS." Brian then demonstrated how to migrate a simple DTS package to SSIS and some of the challenges that may occur.
View Meeting Presentation >>
|
 August 23, 2007 - Aaron Bertrand, SQL Server MVP is a major contributor to Microsoft's public newsgroups for SQL Server, and connect.microsoft.com. Aaron has spent considerable time exploring and testing Katmai (SQL Server 2008) and shared his insight in his popular presentation "New Features in Katmai.
View Meeting Presentation >>
|
 July 19, 2007 - Chris Shaw, the #1 rated speaker from the PASS Community Summit presented "How to Hire a DBA." View the presentation to find out tips on how to post a job opening, review resumes and conduct an effective interview. Here’s the insight you need the next time you are looking for a job or need to fill an open position.
View Meeting Presentation >>
**Can't open the presentation? Download PowerPoint Viewer from Microsoft
|
