SQLwisdom Newsletter

SQLwisdom is a newsletter published monthly by SQL Tools.

Our daily conversations with people managing SQL Server environments have highlighted that many are hungry for additional knowledge. Especially, those who are not specialist SQL Server DBAs.

So, besides keeping you up-to-date on what is happening in the Idera SQL Server toolbox, SQLwisdom also includes articles by local authors plus tips and links to resources to help you increase your SQL Server knowledge.

SQLwisdom Article Archive

From March 2007 Issue: Managing SQL Server 2005 Indexes by Neil Jacobson

We do not archive the SQLwisdom Newsletters. But, you can subscribe for future issues in the column on the right.

SQLwisdom Contributing Authors include:

Neil Jacobson  

Neil Jacobson has a degree in Electrical Engineering from QUT in Brisbane, Australia. He has been a full time SQL Server DBA in Sydney, Australia for the last 8 years and has been using SQL Server for about 11 years. For more than 5 years he was employed at a company hosting Australia's largest SQL Server 2000 site [source: Microsoft Australia/Wintercorp].

Neil is currently employed in the financial services sector as a SQL Server DBA. He participated in the SQL 2005 Beta program and has discussions with Microsoft occasionally regarding features and future directions of the SQL Server product.

Neil has presented to the Australian SQL Server User Group in Sydney (Aug 2005) and Canberra (Nov 2005) on Scripting with Metadata for Common Tasks and Upgrading SQL 2000 to SQL Server 2005. Neil has also presented these topics to Microsoft Australia (Sep 2005) and visited the Microsoft Redmond Campus in April 2006.

Victor Isakov

Victor Isakov is a Database Architect and Microsoft Certified Trainer. Victor provides consulting and training services to various organizations in the public, private and NGO sectors globally, and has been involved in different capacities at various international events and conferences.

Victor has authored a number of books on SQL Server 2005 and worked closely with Microsoft to develop the new generation of SQL Server 2005 Certification and Microsoft Official Curriculum for both ILT and e-Learning. Titles he has authored include:

  • Microsoft SQL Server 2005 Administrator's Companion, Microsoft Press

  • MCITP: Microsoft SQL Server 2005 Database Design Study Guide (70-441), Wiley Publishing

  • MCITP: Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444), Wiley Publishing*

  • Microsoft SQL Server 2005 Performance Tuning, McGraw-Hill*

Victor provides consulting in the following areas of SQL Server 2005:

  • Delivering customised SQL Server training courses

  • Architecting SQL Server database solutions

  • Performance tuning / troubleshooting SQL Server database solutions

  • Analyzing and documenting SQL Server database solutions:

    • Audits

    • “Health-checks”

    • Procedure manuals

Victor offers custom SQL Server courses including:

  • Writing Queries for SQL Server 2000-2005

        This course is targeted at the Information Worker (IW).

    • Day 1 : Writing Basic Queries

    • Day 2 : Joining and Summarizing Data

    • Day 3 : Advanced Querying Techniques
       

  • SQL Server 2005 Performance Tuning and Optimization Course

        This course is targeted at the advanced database administrator (DBA) and
        database developer (DBD).

    • Day 1 : Architecture and Tools

    • Day 2 : Best Practices

    • Day 3 : Disaster Recovery

    • Day 4-5 : Performance Tuning
       

  • SQL Server 2005 Certification Courses

        These courses are targeted at IT Professionals interested in attaining the
        following Microsoft certification:

    • Microsoft Technology Specialist: SQL Server 2005

    • Microsoft Technology Specialist: SQL Server 2005 Business Intelligence

    • Microsoft IT Professional: Database Administrator

    • Microsoft IT Professional: Database Developer

    • Microsoft IT Professional: Business Intelligence Developer

         Victor Isakov can be contacted via email at

* Available in the first half of 2007
* Available in the second half of 2007

Copyright | SQL Tools | Legal | Privacy