What is the difference between a SQL Login and a SQL User? In simple words, a login is for authentication and a user is for authorization. A short video.
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.
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.
SQL SERVER – Say No to DB Data Roles – SQL Security – Notes from the Field #022
Brian Kelley explains why he avoids the fixed DB data roles db_datareader and db_datawriter, and how they can compromise your server security.