SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, Administration Rss

   Items 1 to 20 of 92    Older >>
 

Only Use My Application

By Steve Jones 2017/05/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,046 reads

Killing Statistics Jobs

By Steve Jones 2017/01/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,087 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 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 266 reads

Password Policy

By Steve Jones 2016/12/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,016 reads

Deploy Security Changes with Copy-SqlLogin

Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.  Read more...
By Steve Jones 2016/11/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,380 reads

The security scheme

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

Creating schemas

By Steve Jones 2015/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,802 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,510 reads

SETSPN

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

Service Principal Names

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

Members of windows group

By Yogeshwar Phull 2014/03/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,714 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 | 22,157 reads

Central Management Server Security

By Steve Jones 2013/12/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,302 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 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 266 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 | 22,157 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,896 reads

User Defined Server Roles

By Steve Jones 2013/08/09 | Category: server roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 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,151 reads
   Items 1 to 20 of 92    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)