September 11, 2008 11:00 AM
Posted by: Denny Cherry
END CONVERSATION,
Service Broker,
SQL,
SQL Server 2005,
TempDBI've seen an issue with Service Broker that others may be seeing. Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue. However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...
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 11, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Restore Database,
SQLThe restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command. The syntax of the RESTORE DATABASE...
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...
August 4, 2008 11:00 AM
Posted by: Denny Cherry
Config,
Encryption,
IPSec,
OpenSSL,
PGP,
Secure Data Transfer,
Secure FTP,
SFTP,
SQLYou've got a few options, none of which are all that easy to setup.
1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file.
2. Setup IPSec between the two SQL Servers and then transfer the data as normal.
3. Setup a Secure FTP Server at...
July 22, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
BACKUP DATABASE,
SQL,
SQL Server 2000,
SQL Server 2005Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion. This would be done by taking backups of the database. Backups are taken by using the BACKUP DATABASE command.
The...
July 21, 2008 11:00 AM
Posted by: Denny Cherry
Index Performance,
Query tuning,
SELECT statement,
T/SQL,
Tables,
Uni-codeIndexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for. However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server. This is because of the large amount of data being put in...
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...
July 14, 2008 11:00 AM
Posted by: Denny Cherry
DELETE statement,
Query tuning,
SQL,
TablesDeleting large amounts of data from a table is usually an important task, but if you don't have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database. Not to mention you will cause a very large amount of...
