September 8, 2008 11:00 AM
Posted by: Denny Cherry
KB 250367,
MS DTC,
MSCS,
RPC,
SQL,
Windows 2008This post is specifically about setting up DTC on Windows 2008. If you are looking for the post about setting up DTC on Windows 2003 you'll want to go to the post "
August 7, 2008 11:00 AM
Posted by: Denny Cherry
KB 250367,
MS DTC,
MSCS,
RPC,
SQL,
Windows Server 2003Back in the Windows 2000 days, getting DTC to work was easy. It was setup by default to work. There wasn't a whole lot of configuration which needed to be done...
July 17, 2008 11:00 AM
Posted by: Denny Cherry
Exchange,
Microsoft Windows,
SQL,
SQL Server 2005,
SQL Server 2008,
StorageThat's right I said a book. Well it's actually an eBook but good enough right? The best part is that it's available for free. It's a three chapter eBook called "The Windows Manager's Guide to iSCSI SANs". Each chapter was posted separately so you have to click through to each...
June 23, 2008 11:02 AM
Posted by: Denny Cherry
Disk Alignment,
Diskpar,
Diskpart,
SQL Server,
StorageMyself and many other people have been saying for quite a while now that you need to align your disks before putting data on them. I know have some information on how you can figure out just how much potential performance you are loosing by not aligning.
Before we can begin to figure this...
June 12, 2008 5:24 AM
Posted by: Denny Cherry
Beta,
Migration,
SQL Server 2005,
SQL Server 2008,
SSISA ran across a bit of a problem when upgrading my SQL 2008 CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0. Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages. Because of this when I edit all of the script tasks within my SSIS package the...
May 21, 2008 5:04 PM
Posted by: Denny Cherry
EMC,
EMC World 2008,
FLARE 26,
MirrorView Cluster Enabler,
MirrorView SE,
MSCSYesterday was an very busy day. I didn't have time to think, much less put together a post about it. I hit every session which I was looking for including the always hard to get into Navisphere Manager Hands-on workshop.
The session I probably got the most out of was the session on what's...
April 11, 2008 12:00 PM
Posted by: Denny Cherry
Back To Basics,
LOGIN,
USERUsually Logins and Users are words which are interchangeable with each other. However in Microsoft SQL Server they are very different things. Because everyone assumes that they are the same thing, it can get a little confusing.
Logins are created at the database server instance level, while...
March 31, 2008 10:00 AM
Posted by: Denny Cherry
Back To Basics,
SQL,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
T/SQL,
UPDATEAfter you've inserted the data into the table, it's time to update the data. We do this by using the UPDATE statement. The update statment can be used in two ways. The first is to update a record or set of records in a single table, by simply filtering the data in the table by using values...
