Browse by Tags
All Tags »
SQL Server 2005 (RSS)
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
Read More...
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
Read More...
Latest addition to the best practice series. I highly recommend the same for DBA and architects ! SQL Server 2005 Predeployment I/O best practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
Read More...
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
Read More...
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
Read More...
Quick one – How to check the version of SQL Server product running in production ! SELECT SERVERPROPERTY ('Edition')
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
One of the common questions that I face while reviewing the applications at customer site is if SQL Server caches and reuses the plan then where is the difference in stored procedure vs. SQL Query. There is no single answer; recommend to read Batch Compilation,
Read More...
Another common query – How can I upgrade from SQL Server Standard Edition to Enterprise Edition Use the following command to upgrade to a different edition of SQL 2005. Go to Command prompt “start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=<Instance
Read More...
Faced a question couple of time “What are the performance gains in Win 2003 SP2 for SQL Server 2005 as mentioned in: http://www.microsoft.com/technet/windowsserver/sp2/faq.mspx “ 2 important performance areas that I know of: · Optimization done for Dispatch
Read More...
As a consultant I face a common question where can I find useful whitepapers and reading material on SQL Server 2005. A simple cross reference approach - Troubleshooting Performance Problems in SQL Server 2005 Physical Database Storage Design Online Indexing
Read More...
Microsoft recently released a free download - SQL Server 2005 Performance Dashboard reports. Joint effort of SQL support and SQL development teams to help field with performance issues identification with focus on resolving the problem. The dashboard
Read More...
