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

Content with tags Administration, Security Rss

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

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 | 6,182 reads

Database encryption

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

Enabling TDE

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

E K M

By Vyas DCS 2010/03/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,274 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,900 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 | 29,932 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,559 reads

Read_Only Database

By Unknown . 2009/04/10 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 3,922 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,713 reads

Password policies checked by CHECK_POLICY

By Diana Dee 2008/11/24 | Category: passwords
Rating: (not yet rated) |  Discuss |   Briefcase | 3,409 reads

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.   Read more...
By Shiva Challa 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,083 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,417 reads

public access to extended SP's

check public access to extended stored procedures  Read more...
By Mani Singh 2008/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 888 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,251 reads

usp_ShowOrphanUsers - SQL 2k5

Check Orphaned logins ie, not associated with any database on the current instance.  Read more...
By Pedro Lopes MS 2008/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,582 reads

usp_SecurCreation - SQL 2k5/2k8

Creates statements for securables creation.  Read more...
By Pedro Lopes MS 2008/06/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,563 reads
<< Newer    Items 21 to 40 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)