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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
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.
SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II
Does DENY always beat GRANT? In this Msg 230 follow-up I show the exception, where a GRANT at column level overrides a DENY at a higher level.
SQL SERVER – Common Sense Data Security – Notes from the Field #055
Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.
SQL SERVER – Is tempDB behaving like a Normal DB?
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.
SQL SERVER – SQLCMD to Build Comma Separated String
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.
SQL SERVER – Restricting Access to Contained Databases using Logon Triggers
Restricting access to contained databases: a DBA friend wanted to limit which users can connect, and logon triggers can do that. Here is how.
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.