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