Browsing Posts in SQL Server

For this month’s T-SQL Tuesday, hosted by Sebastian Meine, we are asked to talk about joins. Joins in T-SQL are really easy and efficient compared to most other languages.¬† My goal here is to take a simple example and show how such a join could be represented in SQL and several other languages to help […]

Going through your databases to find and clean up users with no associated server logins can be a pain. ¬†It is fairly easy to find scripts that will go out and find those users, and even some will drop those users automatically. ¬†Unfortunately, sometimes it is not so simple to just drop a user from […]