SQL Server with Mr. Denny:

SQL Server


July 29, 2010  11:00 AM

Running a query against multiple servers at one



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

So you've got a bunch of machines that you want to run a quick query against.  SQL Server 2008's Management Studio gives you a quick and easy.  Open up the Registered Servers in Management Studio and select a group of servers.  Then right click on the group and click on the "New Query"...

July 22, 2010  12:00 PM

Get some storage and virtuilization training, and walk away with an XBox 360



Posted by: Denny Cherry
In Person Events, SQL Server, Storage, Virtualization

On Monday August 9th, 2010 at the Microsoft Office in Irvine, CA I'll be leading up an all day "Storage and Virtualization for the DBA" training session.  In addition to a great day of training, one lucky attendee will walk away with a...


June 28, 2010  11:00 AM

Slide Deck from this weekends #SoCalCodeCamp



Posted by: Denny Cherry
In Person Events, SoCal Code Camp, SQL Server, Storage

I've just posted the slide decks for my sessions from this weeks SoCal Code Camp.  I'd like to thank everything that gave me great feedback on how to improve the sessions.

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 24, 2010  4:59 PM

PASS PreCon Followup



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

So apparently I need to actually read ALL the emails from PASS instead of letting my ADD kick in.  I've been selected for a Pre-Con on Monday November 8th, 2010.  You see PASS sends you a few emails when you are selected.  The first tells you which pre-con and spotlight sessions have been...


June 24, 2010  11:00 AM

Oh my god, what have I gotten myself into?



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

In case you aren't on twitter, at about 5pm (Pacific time) yesterday PASS sent out the emails to the people who have had their pre/post con sessions selected, and apparently Tim Ford (Blog | Twitter) was


June 24, 2010  11:00 AM

It’s #SoCalCodeCamp time again



Posted by: Denny Cherry
In Person Events, SoCal Code Camp, SQL Server

Well it's that time again.  It's time for another one or our world famous SoCalCodeCamp's.  This time Code Camp is down in San Diego, CA at the UCSD Extension Complex in La Jolla, CA. This...


June 21, 2010  11:00 AM

Portland SQL Saturday Slide Decks



Posted by: Denny Cherry
In Person Events, SQL Saturday

It occurred to me that I haven't ever posted the slide decks for the Portland SQL Saturday.  Sorry about that. SQL Server Service Broker in the Real World


June 14, 2010  11:00 AM

Getting started with Master Data Services in SQL Server 2008 R2



Posted by: Denny Cherry
SQL Server 2008 R2

I recently published an article on SearchSQLServer.com where I write all about SQL Server 2008 R2's Master Data Services and how to get...


June 9, 2010  3:50 PM

What’s the best way to really screw up my transaction log files?



Posted by: Denny Cherry
SQL Server, Transaction Log

Managing the space used by your SQL Server transaction logs is pretty easy. If the database is in full recovery mode then do transaction log backups on a regular basis.  Typically every 15-60 minutes. The second option is to put the database into Simple recovery mode.  If you need the...


May 6, 2010  11:00 AM

If you change the default instances port number, you may not be able to connect



Posted by: Denny Cherry
Microsoft CSS, SQL Server

Something that some companies like to do is to change the port number that the default instance is listening under as a security precaution.  However this has a habit of stopping anyone from connecting to the default instance without knowing the port number. This is because the default instance...