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
The open door of a village hall at dusk, warm light on the steps and one empty folding chair near the entrance.

Getting Started in the SQL Server Community

January 28, 2010
Pinal Dave
SQL Tips and Tricks
Professional Development, SQL PASS, SQL Server, SQL User Group

Join the SQL Server community through user groups, online events, helpful answers, and a first short talk built from real practice.

Read More
A wall calendar with a single date circled in soft pencil, the rest of the month blank.

SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010

January 27, 2010
Pinal Dave
SQLAuthority News
SQL Server

SQL Server 2008 R2 has a release date in May 2010. Here is what is new, from Master Data Services to StreamInsight, and why it matters to you.

Read More
A small closed toolbox sits beside a plain flashlight on a quiet workshop bench.

The First Hour on a Server Nobody Can Explain

January 26, 2010
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.

Read More
A hand lifting one small seed packet from a slim drawer, heavy seed sacks stacked behind it.

Keeping Large Blobs Out of Your Main Tables

January 23, 2010
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Datatype, SQL Server, SQL Table Operation

Large blobs can widen SQL Server access paths and backups; learn to separate payloads, avoid SELECT *, and measure off-row storage behavior.

Read More
SQL SERVER - Execution Plan - Estimated I/O Cost - Estimated CPU Cost - No Unit

SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit

January 22, 2010
Pinal Dave
SQL Performance
Execution Plan, SQL Server

What is estimated I/O cost, what is estimated CPU cost, and why do these costs in an execution plan have no unit? I answer these common training questions.

Read More
View from a theater's wings of a lit stage with one stool, and a spare guitar on a stand just inside the curtain.

Preparing a Demo That Does Not Fail on Stage

January 21, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Professional Development, SQL Sample Database, SQL Server

Prepare a demo with scripts, clean resets, offline backup material, and a recovery route that keeps the lesson moving when a live step fails.

Read More
A broken umbrella on a counter with its snapped rib and red tip laid beside it

Opening a Microsoft Support Case: What to Gather First

January 20, 2010
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Error Messages, SQL Server

Prepare a Microsoft support case with version details, a clear timeline, error logs, system_health, dumps, LogScout, and redaction notes.

Read More
Previous 1 … 344 345 346 347 348 349 350 … 416 Next
  • Books
  • Testimonials
  • Privacy Policy

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