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 rice sack leaking a thin trickle into a large heap, beside a smaller single spill of flour on a pantry floor.

Top Resource Consumers in Query Store

July 23, 2014
Pinal Dave
SQL Performance
Query Store, SQL CPU, SQL DMV, SQL Server

Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.

Read More
Gouache painting of a wooden architectural model with brass rods and cords connecting structures to a central red support.

Object Dependencies in SSMS: SQL in Sixty Seconds #071

July 23, 2014
Pinal Dave
SQL Video
SQL Dependency, SQL in Sixty Seconds, SQL Server Management Studio, SQL View

Object Dependencies in SSMS shows the references recorded in SQL Server metadata. This post adds T-SQL queries for both directions, tested on SQL Server 2025, and shows what the dialog cannot see: dynamic SQL, other databases and a table dropped under a view.

Read More
A new set of watercolor paints tied with a red ribbon handed across a desk

Getting Your Employer to Pay for Training

July 22, 2014
Pinal Dave
SQL Tips and Tricks
Career Advice, DBA, Professional Development, SQL Training

Ask your employer to pay for training with a short proposal that ties the course to work, shows cost, and shares the result with the team.

Read More
Gouache painting: a canal lock with one closed wooden gate holding back several small rowboats waiting in a line on calm water; one boat is vermilion

SQL SERVER – SSMS: Activity – All Blocking Transactions

July 22, 2014
Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Server Management Studio

Bengaluru traffic after a rainy day has a lot in common with blocked queries. I look at the All Blocking Transactions report in SSMS and what it shows.

Read More
SQL SERVER - Activity Reports - Dormant Sessions

SQL SERVER – Activity Reports – Dormant Sessions

July 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Scripts, SQL Server, SQL Server Management Studio

A parent-teacher meeting tells me more than a report card. In the same way, the SSMS activity report on Dormant Sessions shows idle connections on your server.

Read More
Gate latch with one toggle seated and the other lifted

AND Before OR: Operator Precedence in WHERE Clauses

July 20, 2014
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL NULL, SQL Operator

A report showed closed orders even though the filter said open. The reason is how SQL Server groups AND and OR.

Read More
MySQL - How to Format Date in MySQL with DATE_FORMAT()

MySQL – How to Format Date in MySQL with DATE_FORMAT()

July 19, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL DateTime

MySQL uses the DATE_FORMAT function to show a date or datetime value in the format you need. Here are simple, self-explanatory examples for common formats.

Read More
A hand pressing a red-handled dibber board into soil, leaving a neat grid of planting holes

SSMS Code Snippets: Writing Your Own Templates

July 18, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Shortcut

Build SSMS code snippets with editable literals, register your own snippet folder, and use Template Explorer for repeatable SQL scripts.

Read More
SQL SERVER - Beginning Contained Databases - Notes from the Field #037

SQL SERVER – Beginning Contained Databases – Notes from the Field #037

July 17, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Scripts

Beginning contained databases: syncing users and logins is a pain with database mirroring. John Sterrett explains how a contained user needs no login.

Read More
Gouache painting of a garden gate with a large key and a porch of three doors, one with a small red key

Login vs User in SQL Server: Who Gets In, Who Can Do What

July 16, 2014
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server Security

Login vs user is a question of authentication and authorization in SQL Server. A login lets you into the instance, and a user gives you rights inside one database. This post builds both on a demo database, shows the errors that appear when one is missing, and explains how they map.

Read More
Previous 1 … 295 296 297 298 299 300 301 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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