SQL Server with Mr. Denny:

ITKE grandparent

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

September 9, 2013  10:59 PM

SQL PASS 2013 1st Timers Webcast

Posted by: Denny Cherry

It's a little late in coming, but I'm happy to announce that I'll be presenting my SQL PASS 1st Timers webcast for the 3rd year in a row.  The webcast will be via GoToMeeting this year.  The webcast will be on September 25th, 2013 at 1PM PST / 4PM EST.  Just fire up the old web browser at that...

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

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: