SQL Server with Mr. Denny:


March 5, 2014  5:00 PM

Risks of Password Changes

Posted by: Denny Cherry
Change Password, Database security, Security, SQL Server

We all know that we should be changing the passwords for our service accounts every once and a while (ever 90-180 days or so) just in...

January 22, 2014  7:00 PM

Changing your Password on Windows 2012 via RDP

Posted by: Denny Cherry
Change Password, Data Security, Microsoft Windows, Security, SQL, SQL Server, Windows 2012, Windows 2012 R2

I ran into a problem at a client recently that I'm shocked that I haven't run across before. I...

December 18, 2013  2:00 PM

Encryption and Compression

Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...

September 18, 2013  2:00 PM

SSL VPNs and Certificates

Posted by: Denny Cherry
Encryption, Security, SQL Server

I end up VPNing into a lot of different companies networks, and the thing that I see that always kills me is when I VPN I'm given an SSL URL to...

August 7, 2013  2:00 PM

Back To Basics: Statistics

Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, Indexing, SQL Server, Statistics

Statistics are magical little objects within the database engine that have the ability to make your queries run fast or painfully slow.  The...

May 5, 2013  2:38 PM

Two Factor Authentication Shouldn’t Depend on One Factor

Posted by: Denny Cherry
Bank of America, Data Security, Security, Social Commentary, SQL, SQL Server, Technology, Two Factor Authentication

Bank of America has decided to implement two factor authentication on their website when doing specific things like adding a remote...

February 6, 2013  2:00 PM

When Designing Logon Systems, Pay More Attention To Password Questions.

Posted by: Denny Cherry
Data Loss, Data Security, Database Design, Database security, Identity theft, Laws, Lawyers, Lesson Learned, Mayhem, Phishing, Security, Social Commentary, SQL Server

In recent months the Internet has started to wake up to security just a little bit more, and probably forgotten all about it as well (read

December 26, 2012  2:00 PM

Cross Database Chaining

Posted by: Denny Cherry
Data Security, Database, Database security, Security, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3.  However this feature isn't often understood mostly because it isn't often used. Database chaining is when permissions cascade from one object to another because they are used by the...

December 6, 2012  12:42 PM

SQL Saturday 194 (#sqlsat194) Here I Come

Posted by: Denny Cherry
Data Encryption, Database security, Encryption, Security, SQL PASS, SQL Saturday, SQL Saturday 194, SQL Server

I'm so happy to be able to announce that I'll be giving a precon at SQL Saturday 194 over in England on Friday March 8th, 2013.  This precon will be will be on SQL Server...

October 10, 2012  9:00 AM

Encrypting data in the same column

Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Data Types, Database, Database Administration, Database Design, Database security, Encryption, Identity theft, Security, SQL, SQL Server, SQL Server stored procedures, Stored Procedures, T/SQL, Tables

I wrote a little while ago about the fact that sensitive data needs to be encrypted within the database for all applications.  This is the first technique that is available to you to encrypt data...

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: