SQL Server with Mr. Denny:

SQL Server


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Database, PowerShell, SharePoint, SharePoint 2012, SQL Server

A client came to be with a pretty scary problem.  Their SharePoint site was totally down.  The databases were there but the actual SharePoint farm was totally dead.  All of the SharePoint tools said that the farm wasn't configured yet so there were some pretty big problems.  Thankfully they had...

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 6, 2012  12:42 PM

SQL Saturday 194 (#sqlsat194) Here I Come



Posted by: Denny Cherry
Data Encryption, Database security, Encryption, Security, SQL PASS, SQL Saturday, SQL Saturday 194, SQL Server

I'm so happy to be able to announce that I'll be giving a precon at SQL Saturday 194 over in England on Friday March 8th, 2013.  This precon will be will be on SQL Server...


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 28, 2012  2:00 PM

Why More People Should Be Working From Home



Posted by: Denny Cherry
Social Commentary, SQL Server

As database professionals there isn't much of a reason that we actual need to go into the office, other than to make other people in the office feel better because we are actually there in person.  In practice we don't ever need to actually touch the physical hardware.  Meeting can easily enough...


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


November 17, 2012  2:00 PM

Backup Databases on Creation



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, CREATE TRIGGER, Data Loss, Database, Database Administration, DDL Trigger, Recovery, SQL Server, SQL Server 2008 R2, SQL Server 2012, T/SQL, Transactions, Trigger, xp_create_subdir

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are...


November 7, 2012  5:52 PM

SQL PASS Day 1 Keynote



Posted by: Denny Cherry
AlwaysOn, Availability Groups, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2012

Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos.  The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries.

All of the keynotes from this years conference not only are the...


November 7, 2012  2:00 PM

Passive AlwaysOn Replicas, not as free as you might think



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Microsoft Cluster Service, MSCS, SQL Licensing, SQL Server, SQL Server 2012

With the release of SQL Server 2012 and specifically the AlwaysOn feature we need...


November 1, 2012  6:17 PM

Lugging fuel up stairs shouldn’t have been needed



Posted by: Denny Cherry
AlwaysOn, Data Loss, DataCenter, Distaster Recovery, Recovery, SQL Server

While I applaud the hard work and ingenuity of the sysadmins who works through the days after hurricane Sandy to keep the generators running, one thing kept coming to my mind.  Why...


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: