Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, MVP, Openday, SQLAuthority Author Visit
Yesterday was our last day at South Asia MVP Open Day. For three days continuously we are having great time along with fellow MVP. Every MVP was having great time because the way whole event was planned. We had plenty of time for networking as well lots of interesting sessions…
Read More

SQLAuthority News – Download RML Utilities for SQL Server

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Download, SQL Server Security
Note:   Download RML Utilities for SQL Server by Microsoft The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible…
Read More

SQL SERVER – Delete Backup History – Cleanup Backup History

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Scripts, SQL Stored Procedure
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to…
Read More

SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, DBA, MVP

I just received the following screen shot from one of the regular readers of the SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 million visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 million visitors. I even missed the anniversary our blog. On November 1st, 2008 SQLAuthority.com has completed 2 years of its existence and now continuing in 3rd year.

Read More

SQLAuthority News – TOP Downloads – Bookmark

Pinal Dave
SQL
Best Practices, Database, Outsourcing Technology, Software Development, SQL Download, SQL Server

Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.

Read More

SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Download, SQL White Papers
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…
Read More