Archive for October, 2007

Re-Initialise Your Registry Without Rebooting….

Save your work before attempting this tip! Press CTRL + ALT + DELETE, to bring up the Windows task list. Highlight ‘Explorer’ and click on ‘End Task’, if the Shutdown screen is shown, click ‘Cancel’. After a few seconds an error message will popup, click on ‘End Task’ and the Windows explorer will be reloaded […]

October 17, 2007 · Rahul Desai · No Comments
Posted in: Tools, Tips & Utilities

Project hijacking…

This normally happens when you have a dedicated resource, faithfully trusted and assigned to a project on behalf of the company or an enterprise. The resource decides to leave the company for one or the other reason, and instead of handing over the project back to the company / enterprise, works out a situation with the […]

October 17, 2007 · Rahul Desai · No Comments
Posted in: Project Management, Talman news

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