SQL Server with Mr. Denny:

November, 2008


November 20, 2008  8:02 AM

PASS 2008 – Day 1 Recapped



Posted by: Denny Cherry
Max Verun, Michael Rys, Michael Thomassy, PASS, Quest Software, SQLServerPedia.com

The sessions from the first day of PASS were great.

Read on for info about a couple of the sessions.

Continued »

November 18, 2008  11:00 AM

PASS Summit 2008 Kick Off tonight



Posted by: Denny Cherry
PASS

For those of you lucky enough to make it to PASS, I'll be seeing you at the Kick Off party tonight at the Welcome Reception in Room 6ABC at the event. For those who aren't able to make it, I'll do my best to keep...


November 17, 2008  8:00 AM

I’ll be speaking at the Inland Empire .Net User Group (reminder)



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


November 14, 2008  8:36 PM

Microsoft has released more SQL Server 2008 Exams



Posted by: Denny Cherry
Certifications, SQL Server 2005, SQL Server 2008

Microsoft has now released the the majority of the upgrade exams from SQL Server 2005 to SQL Server 2008.

Continued »


November 13, 2008  10:47 PM

Pictures have been taken of planets outside of our little corner of the galaxy



Posted by: Denny Cherry
Fomalhaut, HR 8799, Space

Now, I know that this has absolutely nothing to do with SQL Server, and if you read slashdot this is probably going to be old news for you. But apparently scientists have taken some...


November 13, 2008  11:00 AM

What exactly is MSDTC, any when do I need it?



Posted by: Denny Cherry
MS DTC

MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software which a lot of people use, but they don't really know what it does, or how it works. MSDTC is used by SQL...


November 11, 2008  10:54 PM

SQLServerPedia.com/Wiki Launch Party at PASS



Posted by: Denny Cherry
PASS, Quest Software, SQLServerPedia.com

All, I have just been informed that there will be a Lanch Party for the SQLServerPedia.com/Wiki website at PASS on Wednesday the 19th.  If you will be attending PASS be sure to swing by Booth 414 (Quest Software's booth) and pick up your party invite. Details for the location are on the...


November 10, 2008  11:10 AM

How to fix when you can’t copy data when RDPed into a server



Posted by: Denny Cherry
Clipboard, RDP, rdpclip.exe

So you are RDPed into your SQL Server, and you are trying to copy a script from your desktop to the server, or from the server to your desktop.  But you can't for some reason.  All you get is what's in the local buffer. One option is to log out of the machine and log back in.  But this option...


November 6, 2008  11:00 AM

Very useful little query to monitor the health of service broker



Posted by: Denny Cherry
Service Broker, SQL Server 2005, SQL Server 2008, sys.conversation_endpoints

While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was.  So I came up with this little query which is surprisingly effective. select far_service


November 4, 2008  9:50 PM

Does your SQL Server database improve SharePoint performance?



Posted by: Denny Cherry
Article, Performance Problems, SearchWinIT.com, SharePoint

This morning I posted by first article up on SearchWinIT.com called "Does your SQL Server database improve SharePoint performance?". It is...


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: