SQL Server with Mr. Denny:

Development


September 25, 2013  2:00 PM

SQL PASS Summit 2013 1st Timers Webcast is TODAY!

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Just a reminder that TODAY is my SQL PASS Summit 1st Times Webcast for the 2013 PASS Summit.  The...

May 3, 2013  10:25 AM

Atlanta SQL Saturday PreCon

Denny Cherry Denny Cherry Profile: Denny Cherry
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...


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

    0 Comments     RSS Feed     Email a friend


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

    0 Comments     RSS Feed     Email a friend


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


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: