SQL Server with Mr. Denny:

ITKE grandparent


December 28, 2012  7:00 PM

Recommended reading from mrdenny for December 28, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

December 26, 2012  2:00 PM

Cross Database Chaining

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3.  However this feature isn't often understood mostly because it isn't often used. Database chaining is when permissions cascade from one object to another because they are used by the...


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

SQL Saturday 194 (#sqlsat194) Here I Come

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I'm so happy to be able to announce that I'll be giving a


December 5, 2012  2:00 PM

Databases With Large Tables Should Use Auto Stats Async Update Feature

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Altaro gives away 50 free PC backup licenses to all Microsoft Hyper-V administrators

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL


November 28, 2012  2:00 PM

Why More People Should Be Working From Home

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this...


November 7, 2012  5:52 PM

SQL PASS Day 1 Keynote

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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


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: