Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, Administration Rss

   Items 1 to 20 of 83    Older >>
 

Service Principal Names

By Tom Nicol 2014/08/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,561 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: SQLServerCentral.com | Category: dac
Rating: |  Discuss |   Briefcase | 2,823 reads

Members of windows group

By Yogeshwar Phull 2014/03/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,611 reads

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 Shiva Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,339 reads

Central Management Server Security

By Steve Jones 2013/12/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,200 reads

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2013/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 182 reads

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 Shiva Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,339 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,534 reads

User Defined Server Roles

By Steve Jones 2013/08/09 | Category: server roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,549 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 | 3,894 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,915 reads

Security Change Snapshot

This script gives a server level snapshot of recent security changes  Read more...
By Nate Hughes 2013/02/28 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 826 reads

Alter User

Rating: (not yet rated) |  Discuss |   Briefcase | 2,111 reads

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 Shiva Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,339 reads

SQL Server Browser & DAC

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

SQL Server Agent Roles

By Steve Jones 2012/02/28 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 2,202 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,567 reads

SQL Agent Roles

By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,218 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,250 reads
   Items 1 to 20 of 83    Older >>
 
Tags
sql server 7 (34)    
configuring (9)    
miscellaneous (6)    
t-sql (6)    
programming (5)    
sql server 6.5 (5)    
installation (4)    
sql server 2005 (4)    
strategies (4)    
dts (3)    
encryption (3)    
role (3)    
stored procedures (3)    
transparent data encryption (tde) (3)    
auditing (2)    
backup / restore (2)    
best and worst practices (2)    
central management server (cms) (2)    
dac (2)    
indexing (2)    
logins (2)    
monitoring (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)    
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)    
login (1)    
openxml (1)    
passwords (1)    
performance tuning (1)    
public (1)    
roles (1)    
script (1)    
scripting (1)    
server roles (1)    
server_principals (1)    
service accounts (1)    
service packs (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)