SQL Server with Mr. Denny:

SQL


October 2, 2013  2:00 PM

Seeks Aren’t Always Better Than Scans



Posted by: Denny Cherry
SQL

So I was doing a little performance tuning of a query for a company recently and we were getting hammered on the IO for the query. The query was in a stored...

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


May 3, 2013  10:25 AM

Atlanta SQL Saturday PreCon



Posted by: Denny Cherry
In Person Events, SQL, SQL PASS, SQL Server, T/SQL

At the upcoming SQL Saturday in Atlanta, GA I have the honor of delivering a precon on database security which has several seats still available. This precon is a full day session where we will be talking about all the security best practices. Signing up for the precon is pretty simple, just...


March 27, 2013  2:00 PM

Using Event Viewer Logging for SSIS Performance Trouble Shooting



Posted by: Denny Cherry
BIDS, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSIS

So while working with a client recently I was going some performance tuning on SSIS for them.  While SSIS isn't exactly my normal workload, the...


January 9, 2013  9:00 AM

Tips from a traveler



Posted by: Denny Cherry
Avis, Delta Airlines, Hilton Hotels, SQL, SQL Server, Travel, United Airlines

Every once in a while I put down a few notes designed to help out the new frequent fliers among us.  Traveling a lot sucks there is just no getting around...


December 12, 2012  2:00 PM

The Least Expensive SQL Server 2012 High Availability Solution



Posted by: Denny Cherry
Database, Database Administration, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL, SQL Server, SQL Server 2012, Storage

As we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature.  Butt what happens when you have a small business that is running its apps on SQL Server Express.  Can't SQL Express have any sort of high...


December 5, 2012  2:00 PM

Databases With Large Tables Should Use Auto Stats Async Update Feature



Posted by: Denny Cherry
Auto Update Statistics Asynchronously, Auto Update Stats, Database, Database Administration, SQL, SQL Server, Statistics, Tables

A pretty cool feature that was introduced in SQL Server 2008 R2 SP1 is the ability to change the auto stats algorithm from the default of 20%+500 rows to a sliding scale. ...


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 29, 2012  10:15 PM

Now that it’s too late, what DR prep can we do today?



Posted by: Denny Cherry
SQL, SQL Server

While preparing for a major disaster is what should be done ahead of time, that's a little...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


October 29, 2012  6:33 PM

I Hope Everyone on the East Coast has a DR Plan



Posted by: Denny Cherry
SQL, SQL Server

With hurricane Sandy dropping into the East Coast of the US this week this is a perfect time to think about DR plans.  DR planning isn't something that people should take personally when it is brought...


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: