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 – 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.
Msg 230: A Column Level GRANT Overrides a Table DENY
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.
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.