Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Cloud Computing, SQL Azure
Microsoft has updated the branding for SQL Services and SQL Data Services. SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database. Changing the name does not change product but it demonstrates tight integration between the components of the service platforms. As…
Read More

SQLAuthority News – Whitepaper – Using the Resource Governor

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
Using the Resource Governor SQL Server Technical Article Writer: Aaron Bertrand, Boris Baryshnikov Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe Published: June 2009 SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads…
Read More
All Articles backuptimeline-404x400

SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.

Read More