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 | 4,251 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,641 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 | 941 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,300 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 | 988 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,123 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,216 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,185 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,337 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,690 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,732 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,295 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,278 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,027 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,847 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,250 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,729 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,363 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,088 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,783 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)