This is the story of my saga to get DTC working in a clustered environment. It’s a bit different from other postings that I read and tried so I thought it was worth posting… We have a “test” SQL Server instance and it was noted that DTC (Distributed Transaction Coordinator) was throwing errors. The users… Continue reading DTC – Why Doesn’t it work?
Tracking your backups…one of the most basic/mundane/important functions for which a DBA is usually responsible. How do you know that your databases are being successfully backed up? What about your transaction logs? If you don’t have a current backup (even for a development database!), you and your users could be “up the creek without a… Continue reading Tracking your Backups
The JOIN clause seems to frequently be a source of mystery/frustration/wonderment for developers, so today I decided provide some information that may demystify it for you. First, a quick definition: a JOIN allows you to retrieve data from 2 (or more) tables based on logical relationships between the tables. A JOIN allows you to retrieve… Continue reading Notes about JOIN
Generally speaking, most T-SQL queries contain WHERE clauses to filter out data and WHERE clauses almost always contain a reference to a column…after all, that’s why the WHERE clause exists (to filter out the data). However, occasionally there is a need to use a condition in a WHERE clause that has no reference to any… Continue reading WHERE Clauses Without Column References
Today I decided to compile a list of tips and tricks for getting more use out of SSMS. I have a favorite set of shortcuts and option settings, and I bet you do as well. But we can all learn something new to help us become better, more efficient developers. There are many articles out… Continue reading Tips and Tricks for SSMS
GETDATE…such an easy function. You can use it whenever you need the current date and time. I often tell developers that you should always declare a variable and set that variable to GETDATE, then reference that variable in your code. Why? Most of the time when I see the GETDATE function in code, I see… Continue reading Some Tips on Using GETDATE
For those of you that use the SOUNDEX function: Please note that this function changed after SQL 2008 R2. Microsoft must have realized that they did not follow the exact algorithm for this function, so they changed it starting in SQL 2012. That means this function MAY return a different value than it used to. … Continue reading A Quick word about SOUNDEX