Azure gallery VMs install SQL Server with SQL_Latin1_General_CP1_CI_AS. Here is how to change SQL Server Collation on such a VM by rebuilding system databases.
MySQL – Different Methods to Know Current User
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 – 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.