Due to the lack of holiday attendance, the SNESSUG meeting this month is cancelled. We will resume normal meetings starting in January.
Nov-2009 ~ Meeting Cancelled ~ PASS Summit
November 2 to November 5 is PASS Summit 20009 in Seattle, WA. Many speakers and some regulars of SNESSUG are attending this event. Hence this month’s meeting is cancelled.
Oct-2009 ~ Dynamic Management Views ~ Raghuram Dharmapuri
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.
Sep-2009 ~ Creating reports using cubes ~ Sunil Kadimdiwan
Presenter: Sunil Kadimdiwan
Topic: Creating Impressive Reports Using Smart Data Analysis Cubes
It is important for us Database Developers and Database Administrators to provide useful reports to our business users. These should be based on good analysis of your data. It is more beneficial if we can display charts, maps, summary reports with drilldown capabilities and combine relevant information into easy to view dashboards. This will allow business users to get to the right information quickly.
SQL Server Analysis Services (SSAS) 2008 allows us to build data analysis cubes and then SQL Server Reporting Services (SSRS) 2008 will allow us to develop compelling reports & dashboards. In this presentation I will show you how to get started on these 2 products and very quickly get useful results.
Biography:
Sunil Kadimdiwan is a Data Architect with an extensive record of successfully designing and implementing mission critical Database & Reporting solutions.
He has deep knowledge of Microsoft BI technology platform. He is well versed in Insurance, High Tech, Capital Market, Publishing, and Non-Profit industries. He is a frequent speaker at code camps, user groups in the New England region.
Aug-2009 ~ Meeting Cancelled ~ SNESSUG
Due to the nice weather and lack of Summer attendance, the SNESSUG meeting this month is cancelled. We will resume normal meetings starting in September.
Jul-2009 ~ SQL Injection Attack – Defense ~ Andrew Novick
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.
Jun-2009 ~ Best Practices – Execution Plans ~ Grant Fritchey
Presenter: Grant Fritchey of FM Global
Topic: Best Practices for working with Execution Plans
Get a preview of the PASS 2009 Summit with an early preview of this session on how to work with execution plans to solve common problems.
Learn how to deal with large execution plans and various methods for retrieving execution plans from SQL Server.
Biography:
Has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last eight years I have been working at a major insurance company as a DBA.
I am a Microsoft MVP. I write articles for publication at SQL Server Central, Simple-Talk, PASS and SQL Server Standard. I have published two books, Dissecting SQL Server Execution Plans and SQL Server 2008 Query Performance Tuning Distilled. I am curently working on a third book called Beginning SQL Server 2008 Administration.
May-2009 ~ ETL Integration done the right way ~ Bob Hoffman
Presenter: Bob Hoffman of Information Builders
Topic: ETL integration done the right way
This presentation covers the following topics:
- Enterprise Information Management (EIM)
- Event Integration
- Content Integration
- Data Quality
- Master Data Management
Biography:
Bob Hoffman is a Senior Systems Engineer for Information Builders in Boston. Bob has held numerous positions in his 26 year tenure with IBI.
He has experience on almost every platform and database including ZOS, iSeries, UNIX, Windows as well as expertise in all of IB products from both the Business Intelligence and Integration (iWay) perspectives.
Bob has worked with the integration products since their inception including ETL, ESB and Adapters and has applied this technology at numerous customers. He has been a regular presenter at Information Builders user group meetings.
Bob currently resides in Connecticut and his interests include Computing, Baseball, Skiing, Karate, Lionel Trains and raising 2 boys.
Apr-2009 ~ Real Time Integration ~ Richard Thomas
Presenter: Richard Thomas of Attunity
Topic: Real Time Integration
This presentation covers the following topics:
- Change Data Capture
- Data Changes
- Transactions
- Loosely Coupled Integration
- Scalable
- Recoverability
- Fault Tolerance
- Integrating with Non-Microsoft Platforms
- High-Speed Connectors – Oracle
- High-Speed Connectors – Teradata
- Attunity Connectors – Legacy Sources