SQL Server with Mr. Denny:

SQL Server 2012


July 26, 2012  2:00 PM

Security Sessions at SQL PASS 2012



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database, Database Administration, Database Design, Database security, Encryption, Security, SQL Injection, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

The SQL PASS session list for the SQL PASS 2012 Summit has been released.  This year there are 192 sessions being presented at the SQL PASS summit.  Last year at the 2011 summit there were only a couple of sessions...

October 12, 2011  5:02 PM

SQL PASS Keynote notes



Posted by: Denny Cherry
Azure, SQL PASS, SQL PASS 2011, SQL Server, SQL Server 2012, SQL Server MVP Deep Dives Volume 2

Today was Day 1 of the SQL PASS summit.  Today there were a few announcements during the keynotes which if you didn’t see on the live streaming site you probably want to hear about. During the PASS portion of the keynote we also heard about the massive amount of training the the SQL PASS...


October 4, 2011  7:58 PM

New SQL 2008 R2 SP1 trace flag adjusts autostats threshold



Posted by: Denny Cherry
auto-stats, SQL Server, SQL Server 2008 R2, SQL Server 2012, Statistics, Trace Flag

I recently learned about a new trace flag which has been introduced in SQL Server 2008 R2 SP1 (and SQL Server "Denali").  This trace flag, number 2371, changes the way that the SQL Server...


August 5, 2011  8:49 PM

Using SQL Server “Denali”? Want to be interviewed for an article?



Posted by: Denny Cherry
Jason Sparapani, SQL Server, SQL Server 2012

Have you been using SQL Server "Denali" and want to get your voice heard?  Now's your chance.  Tech Target is looking for SQL Server "Denali" users (either CTP 1 or CTP 3) to interview for an article that they are working on about SQL Server "Denali". To get your voice heard contact Jason...


July 14, 2011  6:33 PM

Updated SSMS Shortcut Key file



Posted by: Denny Cherry
Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

I've updated the SQL Server "Denali" settings file to include the CTRL+E and CTRL+X hot keys.  You can find the new file in the same location as the old one so you only need to download it once. Denny


July 14, 2011  2:56 AM

Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3



Posted by: Denny Cherry
Hot Keys, Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

If you did what I did when you installed CTP 3 of SQL Server "Denali" (which happened when I uninstalled CTP 1 then installed CTP 3) you'll be in for a rude surprise, a lot of your shortcut keys that you've been using for years don't work any more.  This is to say the least VERY annoying, and...


July 12, 2011  2:00 PM

Database %d was shutdown due to error 9002 in routine ‘HeapPageRef::Update’.



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

So I hit the error in the title the other night while converting a heap to a clustered index on a production system.  After this error poped up, some other nasty stuff showed up in the error log, which I've included below.

Error: 9002, Severity: 17, State: 4. The transaction log for...


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


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


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: