May-2013 ~ SQL Server Development and Administration Tips and Tricks ~ Roman Rehak

Posted by admin

Presenter: Roman Rehak
Topic: SQL Server Development and Administration Tips and Tricks
Downloads: Presentation Materials (.zip)

This presentation will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment.

Biography:

Roman is principal database architect at MyWebGrocer in Colchester, Vt. He specializes in SQL Server development, database performance tuning, ADO.NET and writing database tools. He regularly contributes SQL Server articles to Visual Studio Magazine, SQL Server Magazine and other technical publications and presents at user groups and conferences in the U.S. and Canada.

Apr-2013 ~ SSIS Best Practices, Tips and Techniques ~ Bryan Cafferky

Posted by admin

Presenter: Bryan Cafferky
Topic: SSIS Best Practices, Tips and Techniques
Downloads: SSIS Presentation (.zip)

Join us for this presentation on the best practices, tips and techniques of leveraging SSIS. Learn how to load any external file confidently and easily, how to take direct control of SSIS processes using the Script Task and the Script Component, how to select the best configuration and deployment approach to meet your requirements, how to design a package to make it flexible and extensible. This promises to be a meeting where you will come away with new ideas and techniques to apply in your job.

Biography:

Bryan is an experienced Business Intelligence engineer who has been developing solutions with SSIS since it was first released. He has been developing for and administering relational databases since 1987 and started working with SQL Server in 1998. He has written a number of articles on www.BIDN.com and leads The Rhode Island Business Intelligence User Group which he founded. Bryan currently works as Senior Business Intelligence Engineer with Smarter Travel Media, a TripAdvisor Company. He has worked in the insurance, banking, utilities, and ecommerce industries.

Aug-2012 ~ Bad Habits and Best Practices ~ Aaron Bertrand

Posted by admin

 

Presenter: Aaron Bertrand
Topic: Bad Habits and Best Practices
Downloads:Slides

 

In this session we will go over several bad habits that are quite pervasive in the SQL Server community, and show with demos and samples why these habits can be bad.


We’ll also illustrate some good habits that are less common and why they should be adopted.

The goal is to have every user in the room walk away with immediately actionable knowledge to improve their existing stored procedures, raise their overall T-SQL skill, and change the way they think about writing code.

Biography:

I thoroughly enjoy my position as Senior Consultant for SQL Sentry, makers of Performance Advisor, Event Manager and the free Plan Explorer – all tools geared to helping customers get the most out of SQL Server.

I have been working with SQL Server for 15 years, and do my best to share my knowledge and experience with the community via sqlblog.com, speaking at dozens of community events, and answering questions in online forums and through the twitter hashtag #sqlhelp.

Jun-2009 ~ Best Practices – Execution Plans ~ Grant Fritchey

Posted by admin

 

Presenter: Grant Fritchey of FM Global
Topic: Best Practices for working with Execution Plans

 

Get a preview of the PASS 2009 Summit with an early preview of this session on how to work with execution plans to solve common problems.

Learn how to deal with large execution plans and various methods for retrieving execution plans from SQL Server.

Biography:

Has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last eight years I have been working at a major insurance company as a DBA.

I am a Microsoft MVP. I write articles for publication at SQL Server Central, Simple-Talk, PASS and SQL Server Standard. I have published two books, Dissecting SQL Server Execution Plans and SQL Server 2008 Query Performance Tuning Distilled. I am curently working on a third book called Beginning SQL Server 2008 Administration.