September 2010 Speaker
Brian Berry - 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.
August 2010 Speaker
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).
July 2010 Speaker
Andrew Novick - SQL Server MVP
Topic: "SQL Azure: Relational Database in the Cloud"
SQL Azure is Microsoft's relational database offering in the cloud. While it's similar to SQL Server 2008 there are enough differences that it's important to understand what you can and cannot do with SQL Azure. This presentation gets you comfortable with SQL Azure and understand how it can best be used. A glance at the topics that will be covered: Signing up for SQL Azure; Creating a database, users and tables; Differences from other SQL Server 2008 editions; Configuring the firewall; Moving schema and data up and down from the cloud; Getting the right connection string from the Azure UI; Checking Usage and Billing information; Connecting to SQL Azure; Approaches to scaling with SQL Azure; Data Access with OData; Deploying Data-Tier Applications to SQL Azure;
Biography:Andy Novick is a SQL Server MVP and consultant who builds business applications on SQL Server and the .Net technologies from Microsoft. Andy's writing includes the books Transact-SQL User Defined Functions and SQL Server 2000 XML Distilled as well as numerous web articles and web videos. You connect to is writing at his web site www.NovickSoftware.com. In addition to SQL Andy enjoys coaching Youth Baseball and the occasional movie with his wife, Ulli.
June 2010 Event
SNESSUG Officers
Event: "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 Speaker
Mike Walsh - SQL Server SME
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.
April 2010 Speaker
Scott Abrants - Principal Database Software Engineer
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.
March 2010 Speaker
Aaron Bertrand - Sr. Data Architect & Microsoft MVP
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 2010's meeting has been moved to Monday, 15th March 2010. The time and venue remains unchanged (6PM - 9PM).
February 2010 Speaker
Posted by John Miner @ 25.Jan.10
February 2010 Speaker
SNESSUG meeting of February 2010 was cancelled due to inclement weather.
New England Data Camp 2.0
Posted by John Miner @ 25.Jan.10
January 30, 2010
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.