SQL Server principals – Server Roles
[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us on Facebook & YouTube.] Server Roles: Server roles are security principals to control access of other principals. Server roles are server scoped and provide server-level permissions to logins. Fixed / Built-in / Default Server Roles User-Defined / Customized Server Roles Fixed … Continue reading
SQL Server principals – Logins & How does Login Authentication work in SQL Server?
[MSSQLFUN & Decode ITeS becomes a family of 1600 individuals across the globe. Please join us on Facebook & YouTube.] SQL Server Level Principals SQL Server level principals are the only way to connect to SQL Server to access data. They are the entry guard to ensure only authorized person entries and perform legitimated functions only. SQL … Continue reading
SQL Server Authentication
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] We will be discussion SQL Server Authentication and below topics:- What is Authentication? Type of authentication in SQL Server (SQL & Windows) Windows Authentication What is Windows authentication? Advantages & Disadvantages SQL Authentication What is SQL authentication? … Continue reading
Introduction to Microsoft SQL Server Management Studio (SSMS)
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Microsoft SQL Server Management Studio IDE (Integrated Development Environment) is a powerful GUI tool with a long list of features and options. SSMS is very useful and user friendly for all users like DBA, Developers, Testers, or … Continue reading
