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

Content with tags Administration, Security Rss

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

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,032 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 | 928 reads

Alter User

Rating: (not yet rated) |  Discuss |   Briefcase | 2,188 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,170 reads

SQL Server Browser & DAC

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

SQL Server Agent Roles

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

SQL Agent Roles

By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,280 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,292 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,576 reads

Database encryption

By Steve Jones 2011/08/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,191 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,673 reads

Enabling TDE

By Steve Jones 2011/05/30 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,348 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,011 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,946 reads

E K M

By Vyas DCS 2010/03/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,298 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,154 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,011 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,946 reads
<< Newer    Items 21 to 40 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)    
read only (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)