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
Diagram of the infrastructure stack from the internet and firewall through web servers, an app middle tier, databases and the SQL Server instance, down to the operating system, disk configuration, VM and virtual disks; a red callout says Most only tune here at the databases and the instance

SQL Server Performance Stack: Look Beyond the Query

December 25, 2013
Pinal Dave
SQL Tips and Tricks
Disk, Notes from the Field, SQL Performance, SQL Server, Virtualization

Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.

Read More
A chimney brush with soot on its bristles beside marked and clean hearth bricks

Investigating a Past Slowdown With the system_health Session

December 24, 2013
Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Monitoring, SQL Performance

Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.

Read More
Gouache painting: a quiet country train platform in soft morning light, a row of empty wooden benches waiting, and one vermilion umbrella leaning against the last bench

SQL SERVER – Learning More About SQL Wait Stats

December 23, 2013
Pinal Dave
SQL Tips and Tricks
SQL Wait Stats

Are SQL Wait Stats still relevant for performance tuning? Absolutely. Here is what I told a customer in Delhi and where to start learning about them.

Read More
Gouache painting of a person reviewing a database access checklist with a magnifying glass

Permissions I Have in SQL Server: Check Database, Server and Object Access

December 22, 2013
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.

Read More
An unbuckled spare girth lies beside a saddle awaiting a replacement strap

Recovering a Deleted Agent Job From an msdb Backup

December 21, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server Agent, System Database

Someone deleted the wrong Agent job. Here is how to get it back from an msdb backup without touching the live msdb.

Read More
SQL SERVER - Redundant Indexes Good or Bad - Final Wrap - Part 7

SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7

December 20, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index

Are redundant indexes good or bad? This final wrap of my seven part series recaps every part and its demo, so start here if you missed any.

Read More
SQL Server Configuration Checking Tool.

SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

December 19, 2013
Pinal Dave
SQL Tips and Tricks
Notes from the Field

Want to know about a problem before your users do? Mike Walsh explains SQL Server alerts, why they matter for server health and how to use them.

Read More
A compact plain toolbox with a few neatly arranged hand tools on a warm wooden workbench.

Free Tools Worth Having on a SQL Server

December 18, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.

Read More
A pebble tumbler holds varied stones while two similar stones lie beside it

Generating Unique, Hard-to-Guess Voucher Codes in T-SQL

December 17, 2013
Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Random, SQL String

Random-looking codes can still be guessed. Build 20 voucher codes from random bytes, check them, and make redemption single-use.

Read More
A person lifting a red blanket over a campfire, sending puffs of smoke across a valley at dusk

BASE64_ENCODE and BASE64_DECODE in SQL Server 2025

December 16, 2013
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Server, SQL String

Use BASE64_ENCODE in SQL Server 2025, decode binary and text safely, compare URL-safe output, and replace older XML encoding expressions.

Read More
Previous 1 … 317 318 319 320 321 322 323 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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