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
CPU task manager snapshot.

SQL SERVER – T-SQL Script to Keep CPU Busy

February 22, 2013
Pinal Dave
SQL Tips and Tricks

Need to keep CPU busy for capacity planning or stress testing on a development server? I share an improved script, but never run it on production.

Read More
Top 1 star from.

SQL SERVER – Shortcut to SELECT only 1 Row from Table

February 21, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Developers often select only 1 row to peek at what a table holds, but typing SELECT TOP 1 again and again is slow. I share a quicker shortcut for it.

Read More
Gouache painting of a jar of saved seeds beside a small red pot with a new green sprout on a garden bench

Restore a Database in SSMS: Step by Step

February 20, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Management Studio

To restore a database in SSMS, right-click Databases, choose Restore Database, pick the backup file, name the destination and choose the recovery state. This post covers each page of the dialog, the tail-log error that stops overwrites, and the T-SQL for a full, differential and log restore chain.

Read More
A netted fruit cage over blackcurrant bushes, a blackbird perched outside unable to get in.

Safe Dynamic SQL With sp_executesql and QUOTENAME

February 19, 2013
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Server, SQL Server Security, SQL Stored Procedure

Write safe dynamic SQL with typed value parameters, validated object names, and allowed sort columns, then test hostile input.

Read More
Two identical windmills on hills across a valley, sails turning in step

Geo-Replication for Azure SQL

February 18, 2013
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL High Availability, SQL Replication

Geo-replication for Azure SQL protects against regional failure through readable replicas or failover groups; learn lag, routing, and drills.

Read More
SQL SERVER - Fix : Error - sqljdbc_auth.dll Issue - com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed

SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed

February 17, 2013
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server

A JDBC user got ‘The TCP/IP connection to the host localhost, port 1433 has failed’ even after checking the firewall. Here is the sqljdbc_auth.dll fix.

Read More
A car raised on a jack in a sunny driveway, spare wheel and red brace laid out.

Rehearsing a master Database Restore on a Test Instance

February 16, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, sqlcmd, System Database

Rehearse a master database restore on a matching test instance, including single-user sqlcmd, automatic shutdown, and configuration checks.

Read More
A row of garden gates swinging free, one red gate still latched

Optimized Locking in SQL Server 2025: What Changes for Blocking

February 15, 2013
Pinal Dave
SQL Performance
SQL Lock, SQL Performance, SQL Server, Transaction Isolation

Enable optimized locking in SQL Server 2025 with ADR and RCSI, then compare lock counts and blocking while checking LAQ limits.

Read More
A half-built brick wall with even mortar joints, a taut string line along the top and a trowel on the last brick.

Formatting T-SQL Consistently Across a Team

February 14, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Software Development, SQL Coding Standards, SQL Server

Formatting T-SQL consistently means choosing a few readable rules, using a formatter carefully, and keeping historical changes focused.

Read More
Gouache painting of mechanical components organized in fitted compartments, with a selected impeller beside its empty storage recess.

SQL Server Version and Edition: SQL in Sixty Seconds #043

February 13, 2013
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Instance, SQL Scripts, SQL Server Configuration

To find the SQL Server version and edition, read SERVERPROPERTY instead of parsing @@VERSION. The tests here show every useful property on SQL Server 2025, why ProductLevel can say RTM after an update, and how to read the version from the ERRORLOG.

Read More
Previous 1 … 349 350 351 352 353 354 355 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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