Why check the current user in MySQL? For audits, permissions and custom logic. Here are the methods, from user() and current_user() to mysql.user.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.
SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached
A client changed one setting, restarted and nobody could connect: the maximum number of 1 user connections has already been reached. Here is how we got in.
SQL SERVER 2016 – Early Thoughts and Observations – Notes from the Field #120
SQL Server 2016 is almost here, while many still run 2014. In Notes from the Field #120, Mike Lawell shares SQL Server 2016 – Early Thoughts and Observations.
SQL SERVER – Finding If Status of Bulk Logging Enabled or Not From Logs
A friend’s SSIS jobs switch a database to Bulk-Logged and back again. Here is how to find which of his log backups ran with Bulk Logging Enabled.
SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server
A client wanted the email address and phone number of every user from Active Directory. Here is how to query Active Directory data with an ADSI linked server.
SQL SERVER – How to Add Multiple New Columns to Table with Default Values?
A reader asked how to add several columns with default values to an existing table. Here is a simple example to add multiple new columns with defaults.
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.