Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Hide Code in SSMS – SQL in Sixty Seconds #154
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.
Hide Procedure Code in SSMS: What WITH ENCRYPTION Covers
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.
Digits in a Column: A CHECK Constraint for Digits Only
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.
Zoom in SSMS – SQL in Sixty Seconds #153
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.
ALTER SCHEMA TRANSFER: Move a Table to Another Schema
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.
Find a Table in Execution Plan – SQL in Sixty Seconds #151
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.
SQL Server slow? Let's fix it together in about four hours.
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.