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 , | Leave a comment

Sep 2014 ~ What the VLF? ~ Mike Hillwig

Presenter: Mike Hillwig
Topic: What the VLF?
Downloads: Available at CrankyDBA.com

Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. Having too many VLFs will cause performance to suffer.

And having too few will cause backup performance to suffer. How do you strike the right balance? In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they’re created, how to identify them, and how to strike the right balance between too few and too many.

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.

Posted in Meetings | Tagged , , | Leave a comment

Aug 2014 ~ SQL Server Statistics: The Secret Sauce ~ Tim Harkin

tim_harkinPresenter: Tim Harkin
Topic: SQL Server Statistics: The Secret Sauce

Learning how to write a query is a basic SQL skill. Eventually, a curious developer wants to know how SQL actually returns the data. Statistics are the “secret sauce” that SQL uses to create a query plan to get your data. In this session, the basics of how SQL creates and maintains statistics will be discussed, and the impact that the this has on query plans. Other topics covered will be what happens when statistics are wrong (and how that can happen), as well as when to take statistics maintenance into your own hands.

Biography:

Tim Harkin has been working with SQL since SQL 2000 and has worked in a variety of database environments from multi-terabyte data warehouses to high volume OLTP applications and everything in between. Tim also helps run the Fairfield\Westchester SQL Server User Group. Currently he is the Senior DBA for Toluna, USA, a pioneer in the dynamic world of market research, data collection, reporting and visualization.

Posted in Meetings | Tagged , , , | Comments Off

July 2014 ~ Building a vision for IT ~ Dave Ramsden

Atrion_LogoPresenter: Dave Ramsden
Topic: Building a Vision for IT

…is about creating a vision that will make IT more strategic as we move into the dramatically changing IT landscape of the first digital decade. The overall theme stresses focusing on business outcomes in order to gain strategic influence. It specifically calls on IT leadership to understand the major changes going on in the industry, leverage personal passion to accomplish change, and to understand and work within the context of their organization’s business goals and strategy. A big component involves demonstrating how our organization, Atrion Networking Corporation, created an intelligence function rather than just implementing a technological BI solution. I contend that BI is a valuable tool, but certainly not an outcome. Moreover, I argue that it takes an Intel Function using a full Intel Cycle to lead to meaningful outcomes. We examine the implementation of this model and demonstrate the results, further supporting the assertion.

Biography:

David Ramsden is currently the Chief Strategy Officer (CSO) at Atrion Networking Corporation, Inc. He has worked in the technology industry for 20 years, and for 15 of them has held leadership roles in Professional Services, Operations Management, Competitive Intelligence and Strategy. He has a Bachelor’s Degree in History and a Master’s Degree in English. He is a member of the society of Strategic & Competitive Intelligence Professionals (SCIP) and has earned their Competitive Intelligence Professional (CIP-I) Certification. He is a member of American Mensa, and has published numerous articles on increasing the strategic influence of IT within an organization. David lives with his wife and 4 children in Massachusetts. Proud to be an Aspergian, Dave is active in raising Autism Awareness both within and outside of the technology community. He is a member of the Asperger’s Association of New England (AANE) and has spoken publically on living with Autism Spectrum Disorder (ASD).


Posted in Meetings | Tagged , , | Comments Off