Sep-2009 ~ Creating reports using cubes ~ Sunil Kadimdiwan

Posted by admin

 

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.

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.

Jun-2009 ~ Best Practices – Execution Plans ~ Grant Fritchey

Posted by admin

 

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

Posted by admin

 

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

Posted by admin

 

 

Presenter: Richard Thomas of Attunity
Topic: Real Time Integration

 

This presentation covers the following topics:

  • Change Data Capture
    1. Data Changes
    2. Transactions
  • Loosely Coupled Integration
    1. Scalable
    2. Recoverability
    3. Fault Tolerance
  • Integrating with Non-Microsoft Platforms
    1. High-Speed Connectors – Oracle
    2. High-Speed Connectors – Teradata
    3. Attunity Connectors – Legacy Sources

Feb-2009 ~ IWAY versus SSIS ~ John Miner

Posted by admin



Presenter: John Miner of Citizens Bank
Topic: IWAY versus SSIS

Which tool might be better for your company’s infrastructure environment?

 

The first part of this presentation will discuss topics related to Extracting, Translating and Loading (ETL) data from various sources to various targets. It will give you a high level over view of ETL concepts and tools in the market place.

The second part of this presentation will showcase two totally different ETL tools: IWAY 7.14 development environment from Information Builders and SSIS 2005 development environment (SQL Server Integration Services) from Microsoft Corporation.

Common functionality between the tools will be explored using the North-Wind database an example source system and several different target formats. ETL job error handling, logging, scheduling, and other interesting features will be explored during this demonstration.

If you are deciding which ETL tool to select for your company in the future, this is a must attend presentation!

Biography:

Has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance.

His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA).

Nov-2008 ~ DBA job searching ~ Scott Abrams

Posted by admin


 

Presenter: Scott Abrams
Topic: DBA job searching in our current economy

 

This presentation will cover the following:

  • Types of jobs available out there?
  • Skills that employers are looking for?
  • Types of questions asked when interviewing?
  • Areas to focus on in order to land the job you want!
  • Common pitfalls to avoid!