Category: Permission & Security
Keeping your Server Secure Part 1 : Login Password Policy

Keeping your Server Secure Part 1 : Login Password Policy

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 thing on which any ...

READ MORE +
0
SQL Server Day to Day issues- Part2

SQL Server Day to Day issues- Part2

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 prevent the SQL Server ...

READ MORE +
0
Script : How to find SQL Server orphan Logins?

Script : How to find SQL Server orphan Logins?

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 like "Orphan Login" ...

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

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

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 available for this ...

READ MORE +
0
SQL Server Day to Day issues – Part 1

SQL Server Day to Day issues – Part 1

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 Properties Error : ...

READ MORE +
0
Database Permissions extraction script

Database Permissions extraction script

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

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

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

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 PC with a username ...

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

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

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 followed to enable ...

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

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

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

READ MORE +
0