Category Archives: Past Meetings

SQL Server Data Quality Services (DQS) is a new Knowledge-Driven Data Quality feature set of the upcoming Microsoft SQL Server “Denali” release aimed at the data stewards and IT professionals who seek to improve the quality of their business data. … Continue reading →

Key takeaways: SSIS logging and auditing in SQL Server Denali Deploying packages in Denali Parameterization of packages Level 200 60-75 minutes In this session, you’ll learn how to manage SSIS in SQL Server Denali. You’ll first see how the logging … Continue reading →

How to Increase Report Development Productivity in SSRS Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using “report parts”. Report parts are stored on the report server … Continue reading →

SSIS Design Pattern (level 500) This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child … Continue reading →

Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class SQL Server provides multiple ways to insert data using ADO.NET. We’ll explore individual writes as well as batched writes in non-RPC and RPC form, with a focus on using the … Continue reading →