Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Security Rss

<< Newer    Items 21 to 40 of 89    Older >>
 

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 22,027 reads

SQL Server Browser & DAC

By Nakul Vachhrajani 2012/06/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,381 reads

SQL Server Agent Roles

By Steve Jones 2012/02/28 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 2,249 reads

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,704 reads

SQL Agent Roles

By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,271 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,287 reads

Removing TDE

Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.  Read more...
By Steve Perry 2011/11/03 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,352 reads

Database encryption

By Steve Jones 2011/08/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,185 reads

SQL Server Central Management Server Security

I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,534 reads

Enabling TDE

By Steve Jones 2011/05/30 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,341 reads

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.   Read more...
By Rudy Panigas 2011/03/11 (first published: 2009/11/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 30,005 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,904 reads

E K M

By Vyas DCS 2010/03/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,294 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,104 reads

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.   Read more...
By Rudy Panigas 2011/03/11 (first published: 2009/11/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 30,005 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,904 reads

Read_Only Database

By Unknown . 2009/04/10 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 3,948 reads

Extract User-Role Mapping

This short script will list all the users along with their Roles.  Read more...
By Sudhir Chawla 2008/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,825 reads

Password policies checked by CHECK_POLICY

By Diana Dee 2008/11/24 | Category: passwords
Rating: (not yet rated) |  Discuss |   Briefcase | 3,474 reads
<< Newer    Items 21 to 40 of 89    Older >>
 
Tags
sql server 7 (34)    
configuring (9)    
t-sql (8)    
miscellaneous (6)    
programming (5)    
sql server 6.5 (5)    
installation (4)    
logins (4)    
sql server 2005 (4)    
strategies (4)    
dts (3)    
encryption (3)    
role (3)    
stored procedures (3)    
transparent data encryption (tde) (3)    
auditing (2)    
backup and restore (2)    
best and worst practices (2)    
central management server (cms) (2)    
dac (2)    
indexing (2)    
monitoring (2)    
passwords (2)    
permissions (2)    
replication (2)    
sql agent (2)    
sql-dmo (2)    
triggers (2)    
user (2)    
user defined function (udf) (2)    
worst practices (2)    
ado (1)    
browser service (1)    
databases (1)    
dbatools.io (1)    
ddl (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
dmv's (1)    
editorial (1)    
english query (1)    
extended stored procedures (1)    
grant (1)    
guest user (1)    
openxml (1)    
performance tuning (1)    
powershell (1)    
public (1)    
roles (1)    
schemas (1)    
script (1)    
scripting (1)    
server roles (1)    
server_principals (1)    
service accounts (1)    
service packs (1)    
sid (1)    
sid mismatch check (1)    
spn (1)    
sql spackle (1)    
sysadmin (1)    
system databases (1)    
updategrams (1)    
users (1)    
visual basic 6 (1)    
xml (1)    
xp_logininfo (1)    
xsl (1)