July-2015 ~ George Walters ~ SQL 2014/2016 new features

george

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.

Posted in Uncategorized | 312 Comments

June – 2015 ~ Basic Transaction Log Management ~ Matt Batalon

matt-batalon

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.

Posted in Uncategorized | 1 Comment

May~2015~ The PowerShell/SSIS Smack Down!

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.

Posted in Uncategorized | Leave a comment

April ~ 2015 ~ SSRS: Interactive Reports and Charts:

Sunil Kadimdiwan

SSRS: Interactive Reports and Charts:

Microsoft Reporting Services has many exciting features. You can show your business data on Maps or utilize Sparklines, Data bars and indicators to produce outstanding reports. These can be interactive, which will also allow you to drilldown to details. In this session I will show you how can make use of these and other features in SSRS

Biography:

Sunil Kadimdiwan has 25+ years’ experience in architecting and implementing database and reporting solutions. He has deep knowledge of the Microsoft SQL Server and Business Intelligence technology stack. He is a frequent speaker at SQL Saturdays, Code Camps, User Group meetings.

Posted in Meetings | Leave a comment

March ~ 2015 ~SQL Server Reporting Services and your Sanity

GCelentano_Pic

SQL Server Reporting Services and your sanity!

Data is everywhere, but it doesn’t do any good if users can’t see and use it. SQL Server Reporting Services can be that gateway to uncover and open the doors into different data sources. If not configured correctly or unable to recognize bottlenecks it can make for a long, bad, day. Learn some of the basic mechanics of how this SQL Server feature is configured along with some useful tricks to monitor performance,and also learn some ways to solve some common issues.

SQL Reporting Services and your sanity

Biography:

Greg Celentano is a SQL Server DBA with a background in virtual and physical server administration. He also has experience integrating and administrating collaborative technologies such as SharePoint and Salesforce. Greg holds a Bachelor’s degree in Computer Information Science and an MBA in Organizational Leadership.

Posted in Uncategorized | Tagged , | Leave a comment

Feb 2015 ~ Basic Database Design ~ John Miner

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.

Posted in Uncategorized | Leave a comment

Jan-2015- Introduction to SQL Stored Procedures ~ Matt Batalon

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

Posted in Uncategorized | Leave a comment

December 2014 ~ Review of PASS Summit and SQL Jeopardy!

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!

Posted in Uncategorized | Leave a comment

Nov-2014 No SNESSUG Meeting this Month

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

Posted in Uncategorized | Leave a comment

Oct 2014 ~ Basic Database Programming ~ John Miner

I am thrilled about presenting to the Southern New England SQL Server User Group (SNESSUG) on October 8, 2014.

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 Programming

Abstract:

You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice. This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects. After this presentation, will be ready to meet that clients need.

This presentation will review the following topics to get you ready to code.

Coverage:

1 – How is a view better than ad-hoc SQL?
2 – Abstracting underlying tables via a view.
3 – Avoiding DML updates to views.
4 – Using triggers to enforce business rules.
5 – Using triggers to prevent data modifications.
6 – What are the different types of functions?
7 – Simple use of each type.
8 – Using stored procedures as an application interface.
9 – Batch programming using stored procedures.
10 – How to schedule batch jobs.

presentation bundle

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.

Posted in Meetings | Tagged , | 1 Comment