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
SQL PASS, SQL PASS 2013, SQL Server

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: