Sep-2010 ~ Accelerated MDM with SQL Server 2008 ~ Brian Berry

Posted by admin

 

Presenter: Brian Berry of Blum Shapiro Consulting
Topic: Accelerated MDM with SQL Server 2008 R2 Master Data Services

 

Data architects have struggled for several years with issues of Enterprise Master Data Management (MDM). The technology, tools, and processes required to create and maintain consistent and accurate lists of master data are of keen interest to rapidly growing organizations.

In this session, Brian Berry will discuss what master data is, why managing it matters, and some key concepts related to architecting an MDM solution. SQL Server 2008 R2 Master Data Services (MDS) is Microsoft’s first product offering to the MDM market. Brian will discuss MDS as an example of MDM Hub Architecture, demonstrating how to leverage MDS for rapid development of Master Data Models, Hierarchies, Business Rules, and integration scenarios via WCF and SharePoint 2010 Workflow

Biography:

Brian Berry is the Director of Technology Consulting at Blum Shapiro Consulting in West Hartford, CT. He has over 10 years of consulting experience with Microsoft Information Worker and Business Intelligence technologies: SharePoint Server 2010, PerformancePoint Services, SQL Server 2008 R2 and Master Data Services. He blogs on these topics (and others) at http://blogs.blumshapiro.com/bcbblog and tweets from @BrianChBerry.

Note:

NEIT needs to use the Hall of Fame on the same day as our meeting (Wednesday, 8th September 2010 6PM-9PM), so they have assigned us a different venue in the same building: #CT232.

Aug-2010 ~ What Are You Waiting For? ~ Thomas LaRock

Posted by admin

 

Presenter: Thomas LaRock; Senior DBA, SQL Server MVP, PASS Director
Topic: What Are You Waiting For?

 

It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Biography:

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and DBA. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

Jun-2010 ~ Launch of SQL Server 2008 R2 ~ SNESSUG Officers

Posted by admin

 

Presenter: SNESSUG Officers
Topic: Launch of SQL Server 2008 R2

 

Southern New England SQL Server Users Group is taking part in the launch of the newest version of SQL Server, SQL Server 2008 R2. The R2 version of SQL Server enhances several areas of functionality for the report writer and provides more and better management for the DBA and adds greater opportunities for the developer. Multiple aspects of SQL Server 2008 R2 will be explored with presentations from various officers of SNESSUG. Please come down and take part in this great presentation.

May-2010 ~ As a DBA, where do I start? ~ Mike Walsh

Posted by admin

 

Presenter: Mike Walsh
Topic: As a DBA, where do I start?

 

Whether you are new to the role of DBA, being “forced” to take on the responsibility of one or are starting at a new company, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the “itties” of Database Administration (Recoverability, Availability – Health & Performance – , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the “itties” of Database Administration. There is also an interesting tip on extracting information from vendors before bringing their systems live.

Biography:

Mike is an experienced SQL Server professional and has worked with SQL for over ten years. He has performed the duties of Database Administrator, Developer, Architect and Performance Team Lead but always leans on his DBA experience in each role. Most recently he is the Principal DBA and SQL Server SME for a global insurance company while consulting with interesting and challenging assignments on the side.
Mike is becoming more active in the community through his blogging, starting up a user group in NH (http://seacoastsql.sqlpass.org) and speaking at various regional events

Apr-2010 ~ Automating Database Deployments Using Visual Studio ~ Scott Abrants

Posted by admin

 

Presenter: Scott Abrants of Iron Mountain
Topic: Automating Database Deployments Using Visual Studio

 

Leading your database development solution to a leaner, more automated method of development and deployment is an essential step to implementing a successful Agile/SCRUM based methodology. An existing SQL Server database will be import it into Visual Studio Team Edition for Database Developers GDR version preparing it for an automated continuous integration builds. Learn some of the tips and techniques that will have you well on your way to integrating with an automated build taking advantage of the power of Visual Studio Team Edition for Database Developers.

Biography:

Scott Abrants is a principal database software engineer at Iron Mountain Digital. Having worked with SQL Server since 6.5 days, and close to 15 years IT experience, Scott has always preferred the BI space when it comes to managing data. Scott is one of the founding officers of the Southern New England SQL Server Users Group and severed as a past president. When not focusing on the world of SQL Server I enjoy spending time with my two beautiful daughters and wife Brenda.

Mar-2010 ~ Management Studio Tips & Tricks ~ Aaron Bertrand

Posted by admin

 

Presenter: Aaron Bertrand of SQL Sentry
Topic: Management Studio Tips & Tricks

 

 

A collection of little things you can do with Management Studio so you can start faster, work smarter, prevent mistakes, and present better!

Biography:

Aaron holds the position of Senior Data Architect at One to One Interactive in Boston, Massachusetts, responsible for database design and architecture. He has been a Microsoft MVP since the 1997-98 award year, and continues to devote spare time to helping the community – be it on the SQL Server newsgroups, StackOverflow, sqlblog.com, or live events like this one

Note:

Since the venue was needed by NEIT on Wednesday, 10th March 2010. March’s meeting has been moved to Monday, 15th March 2010. The time and venue remains unchanged (6PM – 9PM).

Jan-2010 ~ New England Data Camp ~ NESQL

Posted by admin

Overview:

New England Data Camp is a free training event for people who work with data–particularly in the Microsoft space.

This event will feature content for SQL Server DBAs, .NET developers, and business intelligence professionals. Applications are only as good as the data that backs them; if you are a software professional working in any of these disciplines then you are a data professional and this event is for you.

Location:

The event will be held Saturday, Jan 30, 2010 at the Microsoft New England offices – 201 Jones Rd, Waltham, MA 02451. Admittance to this event is free. All costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.

Sessions and Speakers:

Data Camps follow the Code Camp model of an open call for sessions. Whether you are a seasoned presenter or this is your first time in front of an audience, we encourage you to submit a session. We will make every effort to accept every session that is submitted. Click the Speakers link for more information.

Sponsorship Opportunities:

New England Data Camp is a community-run event and we’re looking for a few sponsors to help defer our costs. In exchange we will help you get your message to some of the best and brightest data professionals in New England–the attendees of our event. Click the Sponsors link for more information or send an e-mail to nesql [at] hotmail [dot] com for more information.

Oct-2009 ~ Dynamic Management Views ~ Raghuram Dharmapuri

Posted by admin

 

Presenter: Raghuram (AJ) Dharmapuri – FM Global
Topic: SQL Server’s Panoramic Ensemble
          DMV’s (Dynamic Management Views)

 

We know that DMV’s have the answers, but do we know which DMV to look at and what to look for?

This session gives a brief overview of some of the frequently used Dynamic Management Views in SQL Server.

Biography:

AJ has over seven years of experience in the IT industry. He is currently a Sr. Development Database Administrator with FM Global.

Before joining FM Global, he worked for over 5 years for diverse range of organizations, including Oracle and SAP Labs in the CRM space with main focus on databases. In his current role he designs, develops, tunes & manages all versions of SQL Server databases along with working with developers on SSIS & SSRS tools.

Jul-2009 ~ SQL Injection Attack – Defense ~ Andrew Novick

Posted by admin

 

Presenter: Andrew Novick of Novick Software
Topic: Defending SQL Server from SQL Injection Attacks

 

SQL Injection attacks have emerged as the application security issue that creates the most data loss and web site defacement incidents passing cross-site scripting.

Defending SQL Server from SQL injectioncontinues to be a problem for many applications. This presentation will discuss the ways that SQL Server developers and DBA can harden their applications and servers.

The methods demonstrated include:

  • Protecting Dynamic SQL statements when they can’t be eliminated
  • Security configuration to minimize the vulnerable surface area
  • Using DML triggers to thwart many common attacks
  • Managing stored procedure privilege with the EXECUTE AS clause
  • Using DDL triggers to minimize vulnerabilities
  • Ineffectiveness of database and column encryption as defenses

The SQL Server is one of the most vulnerable components of an application and one of the most frequently attacked. Come hear about the techniques you can use to protect it from SQL injection attacks.

Biography:

Novick Software is the New England based consulting company of Andrew Novick. Over the last 24 years I’ve been managing projects, consulting, writing, teaching, and
programming to create software applications for both operations and analysis. The most important thing that I can do for my clients is to understand what drives their business. Only by understanding their problem
or what they’re trying to achieve can an effective solution be found.