Permission & Security | DBA THINGS
Category: Permission & Security
0
Keeping your Server Secure Part 1 : Login Password Policy
0

Dear readers,   Now we are going to cover very important activity from a DBA perspective. Database\Server Security is the one of the most important ...

0
SQL Server Day to Day issues- Part2
0

Here comes another issue that is being faced by DBAs frequently. (Read part 1 here) Issue- SQL Server Instance fails to start A number of problems can ...

0
Script : How to find SQL Server orphan Logins?
0

Dear Readers, An attempt has been made to write a short script to find out SQL Server Orphan Logins. By the way, I am not sure if Microsoft has any term ...

0
Script : Who all have access to SQL Server via AD Groups?
0

Dear Reader, Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts ...

0
SQL Server Day to Day issues – Part 1
0

Here, I'm trying to share knowledge about Day to Day Issues while working with SQL Server and their quick resolution. Issue 1: Not able to access Database ...

0
Database Permissions extraction script
0

Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before ...

0
March towards SQL Server : Day 2 – SQL DBA Interview Questions Answers – Security Permissions
0

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a ...

0
How to enable remote connection to SQL Instances from single SQL Server Management Studio?
0

Problem : All SQL Server Instances in the Environment are not able to connect from central SQL  Server management Studio. Resolution: Below steps need to be ...

0
How to get access on SQL Server if you don’t have “sa” password or sysadmin access?
0

PROBLEM DBAs need to have sysadmin access on SQL Server to support Databases effectively. There may come situations where DBAs neither have sysadmin access ...