SQL Server with Mr. Denny:

Security


January 18, 2011  5:22 AM

My slide decks from #sqlsat62 in Tampa.



Posted by: Denny Cherry
Data Encryption, SQL Saturday, SQL Saturday 62, SQL Server, Storage

I gave two talks at the recent SQL Saturday 62 in Tampa, FL and I had a blast doing it.  As promised I've posted them on Monday (it is still Monday my time, so that counts right)?   Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 27, 2010  2:00 PM

My book “Securing SQL Server” is coming.



Posted by: Denny Cherry
Book, Security, SQL Server

I'm happy to say that I officially can't make a single change to my book "Securing SQL Server". The publisher made the last little changes and sent it to the...


December 23, 2010  2:00 PM

Do you have any affordable recommendations (mid-size company) for DR to a secondary site, about 11 TB of storage?



Posted by: Denny Cherry
DR, EMC, Storage

It depends on how you are going to handle your data replication.  If you are going to use native array based replication then you’ll need to either use array’s data replication options or look at EMC’s recover point. If however you are going to handle the replication outside of the...


October 21, 2010  11:00 AM

Web based MeetUp on 10/26



Posted by: Denny Cherry
Data Encryption, Encryption, In Person Events, SQL Server

On Tuesday October 26, 2010 at 6:30pm (pacific time) I'll be speaking at a Meet Up in Irvine, CA at the WorkBridge Associates offices (where I was originally going to be speaking this week.  Because I'm going to be in Atlanta, GA next week instead of presenting from Irvine, I'll be presenting over...


October 4, 2010  11:00 AM

Speaking at Microsoft User Group in Irvine, CA



Posted by: Denny Cherry
Encryption, SQL Server

Workbridge Associates is starting a new Microsoft Users Group which will be meeting at their offices in Irvine, CA on October 19th, 2010.  I've been asked to be the speaker at the first meeting, and since I've got sucker written on my forehead I've accepted. As this is a new User Group, I'm...


January 7, 2010  11:00 AM

Not everything needs a public IP address.



Posted by: Denny Cherry
SecurityFightClub, Storage

For those of you in bigger shops you can probably ignore this.  If you work in a smaller shop where everything in the datacenter has a public IP, this post is for you.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 17, 2009  11:00 AM

Dates can easily be the hardest datatype to work with.



Posted by: Denny Cherry
Index Performance, Index Scan, Index Seek, Indexing, T/SQL

The datetime data type can be one of the hardest to work with when it comes to index optimization.  Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value.  Most people handle this via a convert function around the date...


August 6, 2009  11:02 AM

What do you mean I can’t access my own database when trying to attach it?



Posted by: Denny Cherry
Attaching Database, Database security, NTFS Permisions, SecurityFightClub, SQL Server

When you detach a database from Microsoft SQL (I'm talking SQL Server 2005 and up here) the SQL Server automatically changes the NTFS permissions on the file so that only the user who told the SQL Server to detach the file has access to them.  SQL Server does this to ensure that an unauthorized...


June 29, 2009  7:37 PM

If I wanted to learn the law, I would have been a lawyer



Posted by: Denny Cherry
Data Encryption, Database Administration, Encryption, Lawyers, SecurityFightClub, Transparent Data Encryption

So your probably a lot like me, you were a teen who liked to play with computers and you managed to end up in IT.  This is awesome you figured, I play with computers and someone actually pays me for this. During the 90’s life was good, there wasn’t any regulations to deal with, you followed...


June 11, 2009  11:00 AM

Who’s been logging into my SQL Server?



Posted by: Denny Cherry
ERRORLOG, LOGIN, Security, SecurityFightClub, SQL Server 2000, SQL Server 2005, SQL Server 2008

Knowing who has been logging into your SQL Server is one of the key things to know about your SQL Server.  It lets you know quite a bit about who’s using your server, and about who’s been trying to break into your SQL Server, and most importantly if they have succeeded. Obviously you can...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: