Login vs user is a question of authentication and authorization in SQL Server. A login lets you into the instance, and a user gives you rights inside one database. This post builds both on a demo database, shows the errors that appear when one is missing, and explains how they map.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.
The SQL Server Permission Hierarchy
Understand the SQL Server permission hierarchy from server to database, schema, and object, including GRANT, DENY, and role paths.
SQL SERVER – Automate Database Operations for Success – Notes from the Field #035
It is not about how busy you are, but how valuable you are. Brian Kelley explains how to automate database operations and get more important work done.
GDR or CU: Choosing Your Update Branch
Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.
NT SERVICE Accounts in sysadmin: What They Are For
A security scan wants those service logins gone. Here is how to see what each one is for before you click Delete.
SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029
DBAs often skip Windows security because they are not Windows experts. Brian Kelley explains file, folder and share permissions and why teamwork matters.