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
Nov23

SQL SERVER – FIX – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet

Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages
14 Comments

My weekend PowerShell learning hit an error: the term Invoke-Sqlcmd is not recognized as the name of a cmdlet. Here is why it happened and the fix.

Continue Reading
Nov22

SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10

Pinal Dave
SQL Performance
SQL Stored Procedure
1 Comment

Want to plot your own values, like rows in a table, next to standard PerfMon counters? The procedures sp_user_counter1 to sp_user_counter10 do just that.

Continue Reading
Nov21

Msg 230: A Column Level GRANT Overrides a Table DENY

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security
No Comments

A column level GRANT overrides a DENY on the whole table in SQL Server. A friend challenged my earlier claim that DENY always wins, so I built a repro. The granted column works, and every other column raises Msg 230.

Continue Reading
Nov20

SQL SERVER – Common Sense Data Security – Notes from the Field #055

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security
No Comments

Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.

Continue Reading
Nov20

SQL SERVER – Is tempDB behaving like a Normal DB?

Pinal Dave
SQL Tips and Tricks
SQL TempDB
No Comments

TempDB is a special shared database, but in many ways it behaves like a normal DB with a twist. I share how I explained it to DBAs during my tuning work.

Continue Reading
Nov19

SQL SERVER – SQLCMD to Build Comma Separated String

Pinal Dave
SQL Tips and Tricks
sqlcmd
10 Comments

A trick from Balmukund and Vinod at SQLBangalore: use SQLCMD to export a table’s data as a comma separated string. Here is how it works.

Continue Reading
Nov18

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

Pinal Dave
SQL Tips and Tricks
SQL Trigger
6 Comments

Restricting access to contained databases: a DBA friend wanted to limit which users can connect, and logon triggers can do that. Here is how.

Continue Reading
Previous 1 … 403 404 405 406 407 408 409 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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