RML Utilities for SQL Server 2005

Most awaited tool for SQL Server DBA and experts (heard of ReadTrace!). Till sometime back these tools were only accessible to Microsoft SQL Server support team. The RML Utilities for SQL Server provide you a set of tools and processes to answer these questions and much more. The RML utilities allow you to process SQL…

1

Latest Certification for SQL Server 2005

Microsoft has finally launched the public version of “Microsoft Certified Architect : Database” certification. The Database Architect program, the newest Technology Architect program under the Microsoft Certified Architect (MCA) umbrella, provides training and certification in Microsoft SQL Server to help you become a trusted database architect. The program ensures success in three ways. Refer to…

1

Latest development on ADO.NET front – Part 2

At Mix 07, the ADO.NET team announced an incubation project that they have been working on, Project Codename “Astoria”. What’s this “Astoria” now ! – hold on lets look at the goals and high level features The goal of Microsoft Codename “Astoria” is to enable applications to expose data as a data service that can…

1

Latest development on ADO.NET front – Part 1

  Few weeks back at Mix 07 Microsoft announced “Jasper”, an ADO.NET incubation project for building quick, clean and iterative applications.   Jasper is latest steps to make the life of database driven application easier; using “Jasper”, developers start with a connection string and can immediately begin programming the core of an application. Jasper uses…

1

SQL Server 2005 Rocks – another Step to prove enterprise scalability – Latest TPC-H Results

  Another step to prove the enterprise scalability of SQL Server 2005.   The results are in— Microsoft SQL Server 2005 delivers the #1 price/performance for 3TB TPC-H non-clustered benchmark. The recent TPC-H benchmark study with HP demonstrates Microsoft SQL Server’s ability to deliver enterprise scalability and performance enabling our customers to run large scale,…


Peek into future version of SQL (Katmai = SQL Server 2008)

    SQL Server Product Team signed off on SQL Server “Katmai” CTP3 (externally known as “June CTP”). This is the first public Katmai CTP that is being launched in this week’s TechED. Have a bang and participate in testing and evaluating SQL Server 2008 CTP3 (aka. Katmai) and provide your valuable feedback to SQL Server…


New Best Practice Articles

Good reading for weekend  for techies!! Implementing Application Failover with Database Mirroring http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx SQL Server 2005 Deployment Guidance for Web Hosting Environments http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspx Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx  

1

Jargons – GDR and QFE release?

Another quick one for the day – for a frequent query – what is the difference between GDR, QFE and other release terms. For all such queries I redirect my customers to http://support.microsoft.com/kb/935897 – a nice article on Incremental Servicing Model (ISM). ·         GDRs (General distribution release) are new means of providing support. GDR fixes are reserved…

2