Archive for October 15, 2007

SQL DownUnder CodeCamp 2007 – SSIS Best practices (15)

Session-15 Topic: SSIS: Best Practices – Patterns and Anti-Patterns Darren Gosbell – Senior consultant – James & Monroe – SQL server MVP 19% of Posts in MSDN SQL server forums are related to Integration services (as of 1st September 2007). Demonstrated the concept of FETCH  : Flexible, Efficient, Transient, Composable and Honest. (Detailed information available on […]

October 15, 2007 · Rahul Desai · 2 Comments
Posted in: SQL Server, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – Analysis services

Session-13 Topic: Analysis Services Best Practices – Design, Storage, Queries and Calculations Grant Paisley – SQL MVP – Angry Koala Based on session DAT305 at TechEd 2007 (sessions by T K Anand and Christian Petculescu – Microsoft Corporation). Talked about Muvee and Armadillo Run…great tools. Started with importance of PERFORMANCE, how to get it: Focus on Cube […]

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – SQL Server 2008 Merge and Table valued parameters (12)

Session-12 Topic: SQL Server 2008 Merge and TVPs Rob Farley – Trainer / Mentor at Solid Quality Learning Email: Rob Farley Email A look at SQL server 2008 features (merge and table valued parameters). Demonstrated the merge command, Replacement for Update / Insert, capabilities to Synchronise two tables and table valued parameters. Worth getting the presentation […]

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – Sand boxing and Testing Databases (11)

Session-11 Topic: Sand boxing and Testing Databases Ron Dunn – Microsoft Technology Specialist Demonstrated couple of partner products – products from Red Gate Software. All the tools as below: SQL packager – Packages a database or a database update SQL Data Compare – Compares and synchronizes SQL database contents SQL Compare – Compares and synchronizes SQL database schemas […]

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – SQL Server 2005 CE – A DBA’s primer (10)

Session-10 Topic: SQL Server 2005 Compact Edition: A DBA’s primer Jeff Wharton – Chief solutions Architect – Wardy IT solutions Good coverage on compatibility, features, limitation, technical requirements, where to find resources, verifying and repairing, compacting and shrinking, securing, Synchronization, locking, con-currency and Isolation, performance tuning, most of the categories followed by a demonstration. Microsoft link: http://www.microsoft.com/sql/editions/compact/default.mspx A […]

October 15, 2007 · Rahul Desai · One Comment
Posted in: SQL Server, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – New features in SQL server 2008 BI (9)

Session-9 Topic: New Features in SQL Server 2008 BI Peter Myers – Solid Quality Mentors Agenda was , the marketing message, new BI-related features – Fact and Fiction, Change Data Capture. Involved a pretty detailed demonstration, hope it is available on the SQL downunder web site. Microsoft link: www.microsoft.com/sql/2008/solutions/bi.mspx You can view the webcast for Change data […]

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, UserGroups and conferences