SQL Server with Mr. Denny:

SQL Server


September 4, 2013  2:00 PM

I Will Never Use A Travel Agent Again



Posted by: Denny Cherry
Community, Did You Know, Lot, Lufthansa, Social Commentary, SQL Server, Travel, United Airlines

Recently I had the privilege of traveling to Poland for SQL Day 2013. As always the people running the conference threw a...

August 27, 2013  6:46 PM

SQL Connections Post-Con Coming Next Month



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Database Administration, Dev Connections, High Availability, Microsoft Cluster Service, MSCS, Server Hardware, SQL Server

That's right, next month I'm giving a post con at the SQL/Dev Connections conference.  The post con is titled


August 21, 2013  2:00 PM

Back To Basics: Files, File Groups and Disks



Posted by: Denny Cherry
Back To Basics, SQL Server, Storage

SQL Server has three different storage terms which you need to know when dealing with physical file storage.  These...


August 14, 2013  2:00 PM

Back To Basics: Recovery Models



Posted by: Denny Cherry
Back To Basics, Recovery Model, SQL Server

The recovery models tell the SQL Server how much transaction log data to keep within the transaction log, and how much data recovery...


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


July 31, 2013  2:00 PM

Making people pay their own way to a job interview is not the way to get good talent



Posted by: Denny Cherry
Social Commentary, SQL Server

I get job postings emailed to me all the time from various recruiters.  Usually they are, we'll call them OK.  But sometimes the requirements of just...


July 24, 2013  7:00 AM

Blocking Is Not Bad



Posted by: Denny Cherry
Blocking, SQL Server

When dealing with SQL Server databases we have to deal with locking, and blocking within our application databases.  All to often we talk about blocking as...


July 17, 2013  7:00 AM

Nolock and your financial application



Posted by: Denny Cherry
Index Performance, Indexing, Nonclustered Index, Query tuning, SQL Server

The NOLOCK indexing hint gets used way, way to frequently.  The place that I hate seeing it the most is in financial applications, where...


July 10, 2013  7:00 AM

Preventing Locking, Blocking and Deadlocks in the vCenter database



Posted by: Denny Cherry
SQL Server, vCenter

As our VMware environments become larger and larger with more and more hosts and guests more thought needs to be given to the vCenter...


July 5, 2013  5:02 PM

Recommended reading from mrdenny for July 05, 2013



Posted by: Denny Cherry
SQL Server, Top 10

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.


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: