Archive for the ‘UserGroups and conferences’ Category

SQL Server 2008: Performance Data Collector

Brad McGehee mentioned the SQL Server 2008 – Performance Data Collector at the SQL Down Under Code Camp 2009 @ Wagga Wagga. Below is the link to one of his more detailed article. SQL Server 2008: Performance Data Collector Thanks Brad. Technorati Tags: SQL Down Under Code Camp,Brad McGehee,SQL Server 2008,Performance Data Collector,Wagga Wagga,Rahul Desai

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

SQL DownUnder CodeCamp 2007 – Top ten DBA mistakes (18)

Session-18 Topic: Top ten DBA mistakes Kelvin Kline – SQL Server MVP Mentioned about the free seminar hosted by Quest software on SQL server in Melbourne on 16th October 2007: http://www.quest.com/events/listdetails.aspx?ContentID=6220&site=&prod=&technology=&prodfamily=&loc=   Some common mistakes: Unverified Backups, Insufficient error notification, Ignorance of internals, Unknown scalability requirements, No baselines or benchmarks, Query tuning ignorance.   Top 10 […]

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

SQL DownUnder CodeCamp 2007 -Using SSCE from SQL management Studio (16)

Session-16 Topic: Using SSCE from SQL management Studio Marc Ridey – Consultant – Readify A quick session on installing and using SQL server compact edition from SQL server management studio. Blog: http://blog.mridey.com  Technorati Tags: Marc Ridey, Readify, SQL DownUnder, SQL Server, Code Camp, Rahul Desai

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

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

SQL DownUnder CodeCamp 2007 – Introduction to Performance point 2007 (8)

Session-8 Topic: Introduction to Performance point Adam Cogan – SSW Microsoft Office Performance point Server 2007, the goal of the product is to turn the corporate  goals into Numbers. 3 building blocks of the product…Monitoring, Analytics and Planning (MAP). The product is built around Cubes, Reporting Services, Sharepoint Server,  KPI’s, Dashboards and the competitors to the […]

October 14, 2007 · Rahul Desai · No Comments
Posted in: Project Management, SharePoint, SQL Server, UserGroups and conferences