PASS – Rhode Island SQL Server Users Group

Presenter: George Walters
Topic: SQL 2014/2016 new features

SQL 2014/2016 new features
Do you have latch contention? Need to aggregate billions of rows? Reports are killing your server? Have more than one subnet and want to cluster across them?
This session will discuss new features and improvements in SQL Server 2014. We will also touch on coming features for SQL 2016!
Topics will include In-Memory features and performance improvements for both OLTP and OLAP workloads, database engine improvements, new ways to use SSD, and Always-On enhancements.

Bio…
George Walters is a Senior Technical Solutions Professional, Data Platform, for Microsoft’s Tier 1 customers in the Northeast District. He focuses on Microsoft’s Data Platform and Azure. Prior to 2012, he was a Premier Field Engineer, performing proactive and reactive support for Microsoft customers. He has taught enterprise customers Cloud Architecture, SQL Server High Availability, Disaster Recovery, Performance Tuning, and Architecture.

Presenter: Matt Batalon
Topic: Basic Transaction Log Management

SQL Server’s transaction log can be confusing for alot of DBAs and developers. What exactly is being logged? How often should I back it up? Why is it growing so much…and so often? Is the file supposed to be that big? Is my code affecting it somehow? In this presentation we will cover the basics of what the transaction log is, how it works, and also give you some tips to manage the transaction log in your environment.

Bio..
Matt Batalon has 15 years of experience in the Information Technology field with a focus on software development and database administration. For the past ten years, he has worked extensively with Microsoft SQL Server and the .NET framework.

He has a Bachelors Degree from Bryant University with a concentration in Computer Information Systems, and also holds the Microsoft Certified Information Technology Professional (MCITP) Certification in Database Administration.

Presenter: Bryan Cafferky
Topic: The PowerShell/SSIS Smack Down!

Step aside SSIS, there’s a new player in town. PowerShell and it can do anything SSIS can do and more. In this presentation, we will consider the merits of PowerShell as an ETL tool versus SSIS. We’ll discuss a simple ETL framework using PowerShell created custom objects that extract data from a number of sources, transform it, and load it into database tables. We’ll see how PowerShell can deliver a high level of extensibility and reusability unmatched by SSIS. Concepts will be made clear by applying them to a use case of a fictitious company’s data warehouse load. You may leave the meeting thinking it’s time to switch ETL tools.

Biography:

Bryan has been working in data warehousing for over two decades and on the Microsoft SQL Server stack for twenty years. He founded and leads PASS chapter, The Rhode Island Microsoft Business Intelligence User Group. Bryan is a frequent speaker at SQL Saturday’s, PASS Chapter meetings, Code Camps and anywhere he can share knowledge. He holds a bachelor degree in Computer Information Systems and a Masters of Business Administration. He is currently working on a book entitled PowerShell for Database Developers to be released in 2015. Most importantly, Bryan is always eager to learn new things.

I am thrilled about presenting to the Southern New England SQL Server User Group (SNESSUG) on February 11, 2015.

I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.

Here is the gritty details of the presentation that I will be exploring during the 60 minute talk.

Topic:

Basic Database Design

Abstract:

You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.

Topics are focused on data storage structures, security, and integrity.
After this presentation, will be ready to meet that clients need.

Coverage:
1 – Files & File Groups
2 – Logins & Users
3 – Security using schemas
4 – Database roles for access.
5 – Table design via SSMS or TSQL.
6 – Default, Check, and NULL constraints
7 – Handling table relationships (PK vs FK).
8 – To index or not to index?
9 – Testing database integrity using DML.
Coverage:

Biography:

John is the recent recipient of the Microsoft 2014 MVP award for SQL Server. He 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 Consultant at Atrion. He is the PASS chapter leader for Southern New England SQL Server Users Group.

Presenter: Matt Batalon

Topic: Introduction to SQL Stored Procedures

SQL Stored Procedures have been part of SQL Server since the early days. They are fundamental part of almost any SQL Server database. In this introductory presentation we will cover the benefits of using stored procedures in your database development projects, and also look as some drawbacks stored procedures might have. We will also cover the following topics to get you equipped to start writing, modifying and debugging stored procedures of your own.

We’ll cover:

1. Creating Stored Procedures
2. Modifying Stored Procedures
3. Creating Stored Procedures with parameters
4. Creating Stored Procedures with optional parameters
5. Viewing a Stored Procedure definition
6. Returning values from a stored procedure
7. Returning result sets from stored procedures
8. Deterring how nested your current stored procedure is in the call stack
9. Encrypting Stored procedures
10. Creating a stored procedure that executes on instance start up
11.Tips on coding stored procedures
12.Tips on Stored Procedure Performance
13. CLR Stored Procedures

Our chapter president, John Miner, will give a brief presentation on some SQL Server highlights coming up in 2015 from this years PASS SUMMIT. Afterwards, please join us for a fun game of SQL Jeopardy for a chance to win great prizes!

As always, there will be pizza to eat, soda to drink, and good conversation. We hope to see all of you at the meeting!

Due to the PASS Summit in Seattle this month, there will be no SNESSUG meeting this month. We will resume with our regularly scheduled “2nd Wednesday of the Month” meetings in December. Stay tuned for next month’s meeting topic.

Thank You.

SNESSUG Board of Directors