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
Feather duster uncovering retained dust traces on a ceramic shelf

query_store_query_text: Searching Query History by Statement Text

December 27, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Query Store, SQL Server

A LIKE search on Query Store text is a good first step, but one search found four statements, including itself. I show how to narrow it down to the real history.

Read More
Two small wooden platforms connected by a narrow rope bridge on a neutral tabletop.

Linked Servers and What Goes Wrong With Them

December 17, 2016
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.

Read More
SQL SERVER - Best Practices About SQL Server Service Account and Password Management

SQL SERVER – Best Practices About SQL Server Service Account and Password Management

November 21, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Password, SQL Server, SQL Server Security, Starting SQL

Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.

Read More
Two plain wooden model houses stand beside each other with a small movable bridge between them.

In-Place Upgrade or Side by Side: Choosing Properly

November 16, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Compare an in-place upgrade with a side-by-side SQL Server migration, including downtime, testing, dependencies, and recovery after cutover.

Read More
Creating and Running an SQL Server Unit Test - Best Ways to Test SQL Queries

Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries

October 18, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Devart, SQL Scripts, SQL Server

Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.

Read More
Bamboo whisk mixing matcha beside two separate ingredient dishes

Why ’10’ + 5 Returns 15: Mixing Strings and Numbers

October 6, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

The plus sign adds or glues text depending on the types on each side. I show the surprise, the error 245 it can cause, and how text keys get hurt.

Read More
A storm-ready cellar doorway with sandbags, lanterns on a shelf and a red first-aid box on the wall

Writing a Disaster Recovery Runbook: RPO, RTO and a Restore Test

August 31, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, SQL High Availability

Build a disaster recovery runbook around agreed RPO and RTO, usable backup chains, instance dependencies, clear roles, and restore tests.

Read More
Previous 1 … 9 10 11 12 13 14 15 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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