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
Feb4

Before You KILL a Session: Estimating the Rollback Cost

Pinal Dave
SQL Tips and Tricks
DBA, SQL Lock, SQL Server, SQL Transactions
No Comments

Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.

Continue Reading
Feb3

Hide Code in SSMS – SQL in Sixty Seconds #154

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure
No Comments

I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.

Continue Reading
Feb2

Hide Procedure Code in SSMS: What WITH ENCRYPTION Covers

Pinal Dave
SQL Tips and Tricks
SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure
2 Comments

To hide procedure code, create the procedure WITH ENCRYPTION. A demo shows what the clause blocks: the text, the definition and the plan. It also shows the ALTER trap that unhides a procedure, and why this is obfuscation and not security.

Continue Reading
Feb1

Digits in a Column: A CHECK Constraint for Digits Only

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server, SQL String
3 Comments

To keep only digits in a column, a CHECK constraint with NOT LIKE and a character range works, but it has two holes. It accepts an empty string and digits from other scripts. A demo closes both and shows NULL, trust and fixed length codes.

Continue Reading
Jan29

Zoom in SSMS – SQL in Sixty Seconds #153

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio
2 Comments

It is possible to zoom in SSMS (SQL Server Management Studio). A client asked me during a Health Check, so here is how to do it.

Continue Reading
Jan28

ALTER SCHEMA TRANSFER: Move a Table to Another Schema

Pinal Dave
SQL Tips and Tricks
Schema, SQL Scripts, SQL Server, SQL View
No Comments

ALTER SCHEMA TRANSFER moves a table to another schema and leaves repairs behind. A demo shows that permissions disappear and views break while the data stays. It also shows a synonym that keeps old queries working.

Continue Reading
Jan27

Find a Table in Execution Plan – SQL in Sixty Seconds #151

Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Server, SQL Server Management Studio
1 Comment

Finding a table in a huge execution plan is a nightmare. In this SQL in Sixty Seconds video, I show how to find any table in execution plan with SSMS.

Continue Reading
Previous 1 … 79 80 81 82 83 84 85 … 846 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