<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Administration
,
Security
Items 1 to 20 of 72
Next 20 >>
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,688 reads
Alter User
Read more...
By
Ole Kristian Velstadbråten Bangås
2013/02/18
|
Category:
user
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,892 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
2012/12/31
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
16,583 reads
SQL Server Browser & DAC
Read more...
By
Nakul Vachhrajani
2012/06/13
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,217 reads
SQL Server Agent Roles
Read more...
By
Steve Jones
2012/02/28
|
Category:
sql agent
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,127 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,198 reads
SQL Agent Roles
Read more...
By
Steve Jones
2012/02/07
|
Category:
security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,142 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,200 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
|
5,648 reads
Database encryption
Read more...
By
Steve Jones
2011/08/29
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,092 reads
Transparent database encryption
Read more...
By
Gail Shaw
2011/07/05
|
Category:
transparent data encryption (tde)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,335 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...
By
Additional Articles
2011/06/30
|
Source:
MSSQLTips.com
|
Category:
central management server
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,097 reads
Enabling TDE
Read more...
By
Steve Jones
2011/05/30
|
Category:
security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,259 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,800 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,034 reads
E K M
Read more...
By
Vyas DCS
2010/03/12
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,248 reads
List orphaned users from all databases
The script returns all orphaned database users across a SQL Server.
Read more...
By
James Howard
2009/12/29
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
3,120 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,800 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,034 reads
Read_Only Database
Read more...
By
Unknown .
2009/04/10
|
Category:
sql server 7
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,894 reads
Items 1 to 20 of 72
Next 20 >>
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)
backup / restore
(2)
best and worst practices
(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)
auditing
(1)
browser service
(1)
central management server
(1)
dac
(1)
databases
(1)
ddl
(1)
disaster recovery (dr)
(1)
distributed queries
(1)
dmv's
(1)
english query
(1)
extended stored procedures
(1)
grant
(1)
login
(1)
openxml
(1)
passwords
(1)
performance tuning
(1)
public
(1)
roles
(1)
script
(1)
scripting
(1)
server_principals
(1)
service packs
(1)
sysadmin
(1)
system databases
(1)
updategrams
(1)
users
(1)
visual basic 6
(1)
xml
(1)
xp_logininfo
(1)
xsl
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
