Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some major points to absorb from this: A login is created at the SQL Server instance level. We say it’s an instance-level object. A user is created at the database level. It’s a database-level object. The SID is the server ID – a […]
Category: SSC
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is slow. I’m going to let you in on the secret of the best method to get what you want out of your DBA. Ready? Here’s the secret… Ask clearly. Include all details. In the sections below, […]
CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts houses over a game of chess* with his brother: “ONE MILLION POINTS TO GRYFFINPUFF!” So I said, “Hey guys, I’m going to do a nerdy thing with my database skillz and then show you, okay? […]