SQL Server with Mr. Denny:

SQL Server 11


July 28, 2011  2:00 PM

HA vs DR, what’s it all mean



Posted by: Denny Cherry
AlwaysOn, DR, SQL Server, SQL Server 11, Storage

People often get HA (High Availability) and DR (Disaster Recovery) mixed up.  There are a couple of reasons that this happens.  First is the fact that there aren’t any clear guidelines which separate the two.  There are standard terms which are used to help define HA and DR, but there’s...

June 15, 2011  5:27 PM

It’s #sqlpass summit session announcement time



Posted by: Denny Cherry
BI, Encryption, SQL PASS, SQL PASS 2011, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSAS, Stacia Misner

So I've managed to trick the kind folks of the SQL PASS program committee once again this year.  I've gotten two sessions accepted for the summit. The first is a "regular session" which is the normal 75 minute community session during which I'll be presenting "Where should I be encrypting my...


June 14, 2011  2:21 AM

Auto Close, Contained Databases and DDoS



Posted by: Denny Cherry
Attack Prevention, Consolidation, SQL Server, SQL Server 11

One of the features which has been announced to be coming in SQL Server “Denali” is the “Contained Database” feature.  The feature which I’m looking for the...


June 9, 2011  3:00 PM

Tech Ed Recap



Posted by: Denny Cherry
SQL Server, SQL Server 11, Tech Ed

I know that Microsoft’s Tech Ed 2011 ended a couple of weeks ago, and that my recap is way late, but better late than never.  It’s been a crazy few weeks with EMC World 2011, Tech Ed 2011 the next week, then a two day train trip to Seattle which was supposed to have WiFi but didn’t, then SQL...


April 14, 2011  2:00 PM

So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Management Studio

By default SQL Server Management Studio will only show you 256 characters per column.  The fix for this is pretty easy.  You click on Tools > Options to being up the options menu.  From there navigate to Query Results > SQL Server > Results To Text.  Change the "Maximum number of...


March 25, 2011  2:05 PM

Microsoft has made the decision to unleash me on Tech Ed North America



Posted by: Denny Cherry
In Person Events, Manageability, SQL Server, SQL Server 11, SQL Server 2012, Tech Ed 2011, Tech Ed North America

Apparently someone at Microsoft has completely lost their mind.  They have signed me up as a speaker for Tech Ed NA 2011.  I'll be presenting a session titled 'What's New in Manageability for Microsoft SQL Server Code-Named "Denali"'. This is a 300 level session so it will be full of all sorts...


February 7, 2011  2:00 PM

If you aren’t doing backups, you aren’t doing your job.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database.  There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...


February 1, 2011  2:00 PM

My SoCal Code Camp slide decks



Posted by: Denny Cherry
Data Encryption, Encryption, In Person Events, Indexing, SoCal Code Camp, SQL Server, SQL Server 11, SQL Server 2012

So this last weekend was the 13th SoCal Code Camp (the 6th at this location).  I presented three different sessions at this code camp.  My slide decks can be downloaded below.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 24, 2011  11:20 PM

OK everyone, it’s SQL Rally voting time



Posted by: Denny Cherry
AlwaysOn, SQL PASS, SQL Server, SQL Server 11, SQL Server 2012

So it is time for another vote for the second category that I have a SQL Rally session submitted for.  This time the vote is for the "Enterprise Database Administration & Deployment" track. I've got a session up titled "Using SQL...


December 6, 2010  2:00 PM

Microsoft SQL Server’s MDS has come a long way.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2008 R2

OK, now that I have your attention pretty much nothing has changed in Denali's Master Data Services.  The install procedure is a bit different now but that is about it.  To install the Denali version of MDS just run through the normal SQL Server installer.  When you get to the service list page...


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: