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.
MySQL – How to Drop Table If Exists in Database?
SQL Server 2016 added DROP IF EXISTS, but MySQL has had it for years. Here is how to drop table if exists in a MySQL database.
What is a Self Join? Explain with Example – Interview Question of the Week #064
What is a Self Join? It is a popular interview question for every developer. Here is a simple answer, whether it is inner or outer, and a practical use.