SQL Server with Mr. Denny:

SQL Server


November 11, 2010  4:58 PM

SQL PASS 2010 Day 2 Keynote



Posted by: Denny Cherry
In Person Events, PASS, SQL PASS, SQL PASS 2010, SQL Server

Today was the second day of the SQL PASS summit. The first item of business was to award The passion award to Wendy Pastrick (blog | twitter) . After the awesome award was given out by Bill Graziano, Bill...

November 9, 2010  5:59 PM

SQL PASS 2011 Day 1 Keynote



Posted by: Denny Cherry
In Person Events, SQL PASS, SQL PASS 2010, SQL Server, SQL Server 11

Today was the first day of the SQL PASS summit. Starting the day with the keynote where a Laptop was given away to a member of the audience by Mark Souza (Twitter) the founder of the SQL CAT team. Ted Kummert was our...


November 9, 2010  4:33 PM

SQL PASS 2010 Day 0



Posted by: Denny Cherry
In Person Events, SQL PASS, SQL Server

Yesterday was my first day at the SQL PASS summit.  Normally I don’t have anything official to do on that day, however this year was different.  This year I was allow to present a pre-con at the summit.  The pre-con was a heck of a lot of work to put together, but it was a heck...


November 5, 2010  4:04 AM

Dev Connections was a blast



Posted by: Denny Cherry
Dev Connections, SQL PASS

This week was my first dev connections conference.  The conference was a bit bigger than I thought it would be, and I had a blast.  The couple of sessions that I went to where excellent, but I wouldn't expect much else from Paul Randal (Blog |


November 1, 2010  11:00 AM

What a difference a temp table makes over a table variable



Posted by: Denny Cherry
SQL Server, Statistics, Table Variables, Temp Tables

I was working on performance tuning the data deletion process that I use to remove data from our database.  We delete massive amounts of data on a daily basis, so our data deletion process is pretty important to us.  As we've grown our customer base the amount of data to be deleted every day has...


October 29, 2010  2:37 PM

Crap, I have to be awake and semi-sober every morning at PASS.



Posted by: Denny Cherry
Blog, In Person Events, SQL PASS


October 25, 2010  11:00 AM

Being a great DBA means knowing more than just SQL Server



Posted by: Denny Cherry
SQL Server, Windows 2008 R2, Windows 7

Sometimes a project comes around that requires knowledge beyond the normal SQL Server knowledge. This is where having the extra knowledge can really make you standout.  Recently I was talking to Allen Kinsel (blog |


October 21, 2010  11:00 AM

Web based MeetUp on 10/26



Posted by: Denny Cherry
Data Encryption, Encryption, In Person Events, SQL Server

On Tuesday October 26, 2010 at 6:30pm (pacific time) I'll be speaking at a Meet Up in Irvine, CA at the WorkBridge Associates offices (where I was originally going to be speaking this week.  Because I'm going to be in Atlanta, GA next week instead of presenting from Irvine, I'll be presenting over...


October 11, 2010  11:00 AM

Using the wrong data type can have same major problems.



Posted by: Denny Cherry
Data Types, SQL Server

Apparently this weekend a small company which does something very important discovered the upper bounds of the INT datatype (or the equivalent in what ever database platform they are using).  This makes it very clear that whoever designed the database for them...


October 7, 2010  11:00 AM

Are you going to SQL Connections? Better sign up soon.



Posted by: Denny Cherry
In Person Events, PASS, SQL Server

This year I've got the pleasure of being accepted as a speaker at the SQL Connections conference in Las Vegas, NV the first week of November.