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

Content with tags Blogs, Security Rss

   Items 1 to 20 of 53    Older >>
 

Continuous Integration/Delivery without Testing!

Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...  Read more...
By Brian Kelley 2014/08/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 6,450 reads

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,708 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 | 960 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,332 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 | 1,028 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,162 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,247 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,220 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,361 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,753 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 | 4,115 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,421 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,312 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 | 2,095 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,880 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,306 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,813 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,387 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,234 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,803 reads
   Items 1 to 20 of 53    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)    
continuous integration (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)