SQL Server with Mr. Denny:

Database Design


March 12, 2014  5:00 PM

Learn Before You Plan



Posted by: Denny Cherry
Data Normalization, Database Administration, Database Design, Query tuning, SQL, SQL Server, SQL Server stored procedures, T/SQL, Tables

Walking into a new shop every couple of weeks has its challenges. What sort of problems are they going to throw at me. Recently I had the...

January 2, 2014  2:00 PM

Why would I want to use a non-durable in memory table?



Posted by: Denny Cherry
Database Administration, Database Design, In Memory Tables, Non-Durable In Memory Tables, SQL, SQL Server, SQL Server 2014, Tables, Transaction Log

With SQL Server 2014 we were introduced to in memory tables, and specifically the ability to use non-durable in memory tables....


December 3, 2013  6:15 PM

Upcoming SQL Saturday Precon in Albuquerque



Posted by: Denny Cherry
Clustered Index, Database, Database Administration, Database Design, Execution Plans, Indexing, Nonclustered Index, Recovery Model, SQL PASS, SQL Saturday, SQL Saturday 271, SQL Server

I'm very pleased to announce that I will be presenting a precon at the Albuquerque SQL Saturday at SQL Saturday 271 on...


May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

A little while back I got one of those phone calls.  You know the one, the lovely 6am phone call about random performance problems.  There were two...


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


November 21, 2012  9:00 AM

Fixing a table that has overflowed its primary key



Posted by: Denny Cherry
Clustered Index, Data Types, Database, Database Administration, Database Design, SQL, SQL Server, Stored Procedures, T/SQL, Tables

During TechEd Europe I got a very scary phone call.  A very large table was throwing errors that the value being inserted into the primary key column was overflowing the data type that makes up that column.  In this case the data type in question was INT, so we were trying to stick the number...


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...


August 2, 2012  4:00 PM

Sensitive Data Must Be Encrypted



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database Administration, Database Design, Database security, Encryption, Exploit, Hashing, Security, SQL, SQL Server

The title of this post pretty much says it all.  If you store sensitive data in a database you have to work under the assumption that someone is going to try and break into the system and steal that data.  Thinking otherwise simply isn’t responsible as the developer and/or administrator of the...


July 26, 2012  2:00 PM

Security Sessions at SQL PASS 2012



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database, Database Administration, Database Design, Database security, Encryption, Security, SQL Injection, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

The SQL PASS session list for the SQL PASS 2012 Summit has been released.  This year there are 192 sessions being presented at the SQL PASS summit.  Last year at the 2011 summit there were only a couple of sessions...


December 1, 2011  2:00 PM

When learning database design, be careful where you learn from



Posted by: Denny Cherry
Database Design, SharePoint, Social Commentary, SQL Server

Every year we have new people joining our ranks as database professionals.  Many of these new people use systems at the places which they already work as the source of their learning when it comes to database design and data modeling.  However this isn't always the best idea unless the systems...


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: