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

Content with tags Security, Blogs Rss

   Items 1 to 20 of 52    Older >>
 

Automated Permissions Auditing With Powershell and T-SQL: Part 5

If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...  Read more...
By Tracy McKibben 2013/11/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,602 reads

Schneier's Thoughts on the Future of IT Security and the Impact of the Internet on Power

If you've got an hour to spare, you might want to check out this presentation by Bruce Schneier where he...  Read more...
By 2013/08/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 933 reads

Backup a password, change it, then restore it.

A couple of months ago I talked about moving a login from one server to another without the password. The...  Read more...
By Kenneth Fisher 2013/06/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,282 reads

Security Questions: Accessing SQL Server Securables

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...  Read more...
By StrateSQL 2013/06/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 969 reads

SQL Server security webinar series is coming soon!

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...  Read more...
By 2013/06/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,113 reads

Security Questions: Differences between “Grant” and “With Grant?”

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...  Read more...
By StrateSQL 2013/05/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,201 reads

CREATE SCHEMA can do what?!?!?

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...  Read more...
By Kenneth Fisher 2013/05/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,168 reads

Getting the lowdown on 18456 errors

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...  Read more...
By Wayne Sheffield 2013/04/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,315 reads

Security: People Are the Weakest Link

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...  Read more...
By 2013/04/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,670 reads

How do I move a SQL login from one server to another without the password?

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...  Read more...
By Kenneth Fisher 2013/04/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,560 reads

Script to clean up “Windows” logins no longer in AD

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...  Read more...
By Kenneth Fisher 2013/03/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,249 reads

Granting Permission to Grant Permissions

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...  Read more...
By Steve Jones 2013/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,258 reads

The Principle of Least Privilege

One of the tenets of good security is that no person or process is granted more rights than it needs...  Read more...
By Steve Jones 2012/12/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,999 reads

You Need to Manage Passwords

I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...  Read more...
By Steve Jones 2012/12/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,822 reads

Logins vs Users

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....  Read more...
By Kenneth Fisher 2012/12/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,227 reads

Microsoft Security Bulletin MS12-070 for SSRS

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...  Read more...
By Brian Kelley 2012/10/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,686 reads

Interesting Reading for September 18, 2012

More stuff you may find interesting. Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...  Read more...
By Andy Warren 2012/09/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,354 reads

SQL Server Guest User – Still a Serious Security Threat

One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...  Read more...
By Basit Aalishan Masood-Al-Farooq 2012/08/31 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,037 reads

Resources for Those Dealing with Security Patches

It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...  Read more...
By Brian Kelley 2012/08/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,767 reads

Stop Storing Unencrypted Passwords!

I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...  Read more...
By 2012/07/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,062 reads
   Items 1 to 20 of 52    Older >>
 
Tags
database security (6)    
sql server (5)    
sql server 2005 (4)    
sql server 2008 (4)    
professional development (3)    
sql server 2000 (3)    
sql university (3)    
training (3)    
windows security (3)    
logins (2)    
permissions (2)    
reporting services (ssrs) (2)    
sql server 2008 r2 (2)    
sql server architecture (2)    
tools (2)    
architecture (1)    
auditing (1)    
career (1)    
conferences/user groups (1)    
database principals (1)    
database users (1)    
events (1)    
grant (1)    
microsoft sql server (1)    
orphaned (1)    
pass (1)    
passwords (1)    
powershell (1)    
presenting (1)    
professional organization for sql server (1)    
roles (1)    
server principals (1)    
sql injection (1)    
sspi (1)    
surface area configuration tool (1)    
trust (1)    
users (1)