This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A hot air balloon lying flat on a field at dawn as a person opens the burner and a red flame starts

Compatibility Level 170: What SQL Server 2025 Turns On

July 26, 2013
Pinal Dave
SQL Tips and Tricks
Compatibility Level, Query Store, SQL Server, SQL Upgrade

Move to compatibility level 170 on SQL Server 2025 with feature checks, Query Store baselines, plan comparisons, and a rollback plan.

Read More
A hand drops red pigment into a small test jar of cream paint beside a large closed paint can.

Trying New SQL Server Features Without Risk

June 30, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Upgrade, Testing, Virtualization

Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.

Read More
Thinking about deprecations.

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server

May 18, 2012
Pinal Dave
SQL Tips and Tricks
SQL Deprecated Feature, SQL Profiler, SQL Server, SQL Upgrade

In this blog post we Nakul will talk about Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server.

Read More
A finished stone bridge beside an old wooden bridge over a river, workers placing the last span to meet the road

Upgrading With Log Shipping for a Short Cutover

May 17, 2012
Pinal Dave
SQL Tips and Tricks
DBA, Log Shipping, SQL Backup and Restore, SQL Upgrade

Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.

Read More
An old car drives along an empty road at dusk, past a roadside garage with its shutters closed.

End of Support: What Actually Stops Working

December 19, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Server Security, SQL Upgrade

End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.

Read More
A hand turning the crank of a red barrel organ with its punched roll feeding

Replaying a Production Workload After Distributed Replay

November 18, 2010
Pinal Dave
SQL Performance
SQL Extended Events, SQL Server, SQL Upgrade, Testing

Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.

Read More
Muddy new hiking boots beside a worn old pair on a porch step, a walking stick leaning on the rail.

Evaluating a New SQL Server Version in One Week

August 16, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Upgrade, Testing

Evaluating a New SQL Server Version in one week works when you install, restore, run a real workload, compare results, and write a decision.

Read More
Previous 1 2 3 4 5 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com