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.

Mar-2013 ~ Why is an SSIS Framework important? ~ James Phillips

Posted by admin

FREE! Query Optimizer eBook and SQL Prompt trial

This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. Download it now

Presenter: James Phillips
Topic:Why is an SSIS Framework important?

In this session we will discuss why an SSIS framework is critical for a successful ETL design, delivery and overall long term success. We will start with some overall best practices, then show you how to create a framework and implement it. When you have completed this session you should have all you need in order to make sure your future ETL projects are successful.

Biography:

James Phillips is a Sr. BI Consultant with Pragmatic works and has over 15 years of IT experience with the last 10 years being focused on Business Intelligence Technologies.  He has been primarily focused on consulting within the BI space for the past few years and delivering solid solutions solving complex business problems within the Microsoft BI Stack.

Feb-2013 ~ Windowing Functions and SQL Server ~ Christina Leo

Posted by admin

Presenter: Christina Leo
Topic: Windowing Functions and SQL Server

Biography:

Christina has worked with various database platforms since 1994. She has earned her MCITP Developer/Adminstrator for SQL Sever 2005. Christina currently works with a small team of database developers and business analysts supporting a 5TB, and growing, research database used by the firm’s quantitative analysts to make their investment decisions.

Jan-2013 ~ Building Your Own Monitors with the SQL Agent ~ Mike Hillwig

Posted by admin

Presenter: Mike Hillwig
Topic: Building Your Own Monitors with the SQL Agent
Downloads: Available at CrankyDBA.com

See those things around your ankles? You hope they’re your socks because no DBA wants to be caught with their pants down. Whether you’re an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won’t buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what’s going on in your environment. You’ll learn how to implement simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. Best of all, Mike will show you how ANY query can be turned into a monitor. So if you need to look for any condition in your application, it can be monitored.

Biography:

Native Pittsburgher and Boston resident Mike Hillwig is a senior SQL Server DBA for a provider of private cloud-based solutions for the financial industry He’s been working with SQL Server since version 7 and has a background in infrastructure and networking.

Dec-2012 ~ Lightning talk ~ Various Members

Posted by admin

 

The December 2012 meeting will be devoted to developing new talent within the group. We will have several slots open for short fifteen to twenty minute talks on a Microsoft SQL Server topic of your choosing.

 

We will be reserving three slots for SNESSUG directors to present. The tentative line up is below.

1 – “Don’t Lose Your Integrity” by John Miner.  Download Sample Code & Presentation

2 – “An Introduction to Table Valued Parameters” by Matt Batalon. Download Presentation

3 – “HIPAA for the DBA. What are the implications of the law and how does it affect us as Data professionals” by Brandon Leach.

4 – Open Slots

Oct-2012 ~ Effective Use Of Temporary Tables ~ John Miner

Posted by admin

 

Presenter: John Miner
Topic: Effective Use Of Temporary Tables
Downloads: Slides

 

Every developer eventually comes against business logic that can not be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script. I will be covering derived tables, local temporary tables, global temporary tables, table variables, user tables in tempdb, and common table expressions in my examples using the AdventureWorks database. The pros and cons of each contruct will be examined. Advanced options like enabling trace flag 1118 will be explored.

Biography:

John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies. He is the PASS chapter leader for Southern New England SQL Server Users Group.