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
Articles with tag
Security
Search for
any
content tagged
security
Items 1 to 20 of 459
Next 20 >>
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
|
3,508 reads
Cloud Safety
Is the cloud secure? How can you be sure? Steve Jones talks a little about some ways you can try to check on your cloud provider.
Read more...
By
Steve Jones
2012/01/11
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
77 reads
Encryption Works
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
Read more...
By
Steve Jones
2011/12/12
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
141 reads
Not So Unbreakable
Oracle touted its database software as unbreakable, but many security researchers think the company is not spending enough effort on security. Steve Jones has a few comments.
Read more...
By
Steve Jones
2011/12/08
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
102 reads
Layers of Security
A good security scheme will contain many layers. Today Steve Jones talks about one of those: good habits.
Read more...
By
Steve Jones
2011/12/06
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
128 reads
Automatically Scripting Out Permissions for Cross Environment Restores
This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.
Read more...
By
Warren Campbell
2011/12/05
|
Source:
SQLServerCentral.com
|
Category:
automation
Rating:
|
Discuss
|
Briefcase
|
4,222 reads
A Welcome Intruder
This Friday Steve Jones asked about penetration testing of your security. Have any of you ever tested your systems?
Read more...
By
Steve Jones
2011/12/02
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
87 reads
SQL Server stored procedure to generate random passwords
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
Read more...
By
Additional Articles
2011/11/25
|
Source:
MSSQLTips.com
|
Category:
security
Rating:
Rate this
|
Briefcase
|
3,158 reads
Power Tools at Work
This editorial was originally published on Jan 17, 2007. It is being republished as Steve is on vacation. This one deals with data security.
Read more...
By
Steve Jones
2011/11/22
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
104 reads
More SQL Injection
Why are sites still being hit by SQL Injection on a large scale? Steve Jones talks about a recent large scale attack that affected over a million sites.
Read more...
By
Steve Jones
2011/11/17
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
283 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
|
4,817 reads
Password Help
Today we have an editorial that was originally published on Oct 9, 2006. Steve Jones talks about the issues of turnover, passwords, and security.
Read more...
By
Steve Jones
2011/11/02
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
94 reads
Employee Slurping
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
Read more...
By
Steve Jones
2011/10/28
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
123 reads
Protecting Data
How hard is it to anonymize data? According to some research, it might be close to impossible. The problem is that we are gathering so much data that cross referencing data sets becomes a problem. Steve Jones talks today about the implications of this for security.
Read more...
By
Steve Jones
2011/10/19
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
83 reads
A Matter of Life or Death
Could your job as a data professional result in the death of someone? It's entirely possible this might affect you at some point. Steve Jones talks about why you ought to do your best when setting up security.
Read more...
By
Steve Jones
2011/09/12
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
141 reads
From Vandalism to Serious Crime
It seems that there are new types of hacker attacks, not looking to steal information for profit, but for disclosure as an embarrassment. Steve Jones talks about the potential downsides for DBAs.
Read more...
By
Steve Jones
2011/09/06
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
112 reads
Virtual Security
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
Read more...
By
Steve Jones
2011/08/22
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
77 reads
The Window Is Shrinking
Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.
Read more...
By
Steve Jones
2011/08/09
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
113 reads
Identifying PII Data to Lock Down in SQL Server - Part 1
We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business users on many of our downstream reporting, datawarehouse and standby servers. The rise of identity theft makes protecting this data imperative. DBAs are the custodians of this information and must protect it like we protect our own personal information. Recent publicity over the theft of Sony PSN data underscores both the economic and ethical importance of protecting personal data.
Read more...
By
Additional Articles
2011/07/14
|
Source:
MSSQLTips.com
|
Category:
security
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,981 reads
SQL Server Service Broker Security
Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.
Read more...
By
Additional Articles
2011/07/04
|
Source:
Database Journal
|
Category:
security
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,252 reads
Items 1 to 20 of 459
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.