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.

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.

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-2012 ~ Full Text Indexing Basics ~ John Miner

Posted by admin

 

Presenter: John Miner
Topic: Full Text Indexing Basics
Downloads: Slides

 

Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.

I will be introducing the Brother’s Grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs better with an index seek.

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.

May-2012 ~ On beyond Zebra AdventureWorks OR where did I go wrong? ~ Steve Simon

Posted by admin

[Steve Simon]

 

Presenter: Steve Simon
Topic: On beyond Zebra AdventureWorks OR where did I go wrong?
Downloads: http://tinyurl.com/talkz
Mentioned Link: Parameter Sniffing

 

 

No matter how well planned and executed, the data structures of any data warehouse oft times eventually land up resembling something out of a Dr. Seuss book. In this presentation we shall be looking at and discussing a few of the “perfect” data structures (that I have inherited) and discussing the flaws that have only recently surfaced. We shall be looking at the ‘before’, discussing a few alternatives to make these structure more efficient and effective, then we shall then look at final “production structure” and the resulting improvement metrics; all of which help us to help our clients’ make better decisions in a timely manner.

Biography:

Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe. He has just recently presented a Business Intelligence paper at Oracle World in San Francisco . Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.

Apr-2012 ~ Aviation Disasters & IT Lessons From Them ~ Mike Walsh

Posted by admin

 

Presenter: Mike Walsh
Topic: Aviation Disasters & IT Lessons From Them
Downloads: Slides

 

What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; even if a freak accident occurs, training and preparation can make all the difference – it’s the same for us!

In this session we’ll have a group discussion through a few actual aviation disasters and see what skills, attitudes and thought processes led to them. We’ll look at some success stories and see what was different. We’ll see how these attitudes and decisions impact us at work and talk about how to identify them in ourselves and our teams. Then we’ll figure out how to prevent them in our day jobs.

Biography:

Mike is an experienced SQL Server professional and has worked with SQL Server for over 12 years. He has performed the duties of DBA, Developer, Architect and Performance Lead but always leans on his DBA experience. Mike is a partner in the exciting SQL Community focused venture called Linchpin People – He is also an independent consultant through his Straight Path Solutions consultancy. He was recognized as an MVP by Microsoft in April of 2011 for his SQL Server community involvement. He blogs at http://www.straightpathsql.com

Mar-2012 ~ T-SQL Deployment and Continuous Integration ~ Grant Fritchey

Posted by admin

 

Presenter: Grant Fritchey
Topic: T-SQL Deployment and Continuous Integration
Downloads: Slides

 

While most T-SQL developers focus on writing quality T-SQL code and efficient queries, what they often forget is how it should best be deployed. This includes deployment of new applications, as well as upgrades and bug fixes. In this session, you will learn many best practices involving the principles of continuous integration, such as maintaining a code repository, automating builds, self-testing, auditing, automated deployment, and much more. This session is designed for both DBA administrators and developers who want to optimize their T-SQL deployment process.

Biography:

Grant Fritchey is a SQL Server MVP with over 20 years of experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0, back in 1995. He has developed in VB, VB.NET, C# and Java. Grant volunteers at PASS and is past president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk and joined Red Gate Software as a Product Evangelist in January 2011. He blogs at www.scarydba.com.