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

Content with tags Security, Administration Rss

   Items 1 to 20 of 87    Older >>
 

The security scheme

By Steve Jones 2016/01/26 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,345 reads

Creating schemas

By Steve Jones 2015/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,776 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,495 reads

SETSPN

By Steve Jones 2014/10/17 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,702 reads

Service Principal Names

By Tom Nicol 2014/08/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,876 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 | 3,035 reads

Members of windows group

By Yogeshwar Phull 2014/03/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,703 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 Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,961 reads

Central Management Server Security

By Steve Jones 2013/12/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,287 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 | 194 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 Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,961 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 | 13,770 reads

User Defined Server Roles

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

Alter User

By Ole Kristian Velstadbråten Bangås 2013/02/18 | Category: user
Rating: (not yet rated) |  Discuss |   Briefcase | 2,178 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 Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,961 reads

SQL Server Browser & DAC

By Nakul Vachhrajani 2012/06/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,378 reads
   Items 1 to 20 of 87    Older >>
 
Tags
sql server 7 (34)    
configuring (9)    
t-sql (7)    
miscellaneous (6)    
programming (5)    
sql server 6.5 (5)    
installation (4)    
sql server 2005 (4)    
strategies (4)    
dts (3)    
encryption (3)    
logins (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)    
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)    
openxml (1)    
passwords (1)    
performance tuning (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)