XML Workshop XVII - Writing a LOOP to process XML elements in TSQL
Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.
Data Comparison with Data Dude
In this article Dinesh Priyankara shows how Visual Studio Team Edition for Database Professionals can be used to perform data comparison.
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
SQL Server Database Requirements
In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.
Configuring SQL Server 2005 Failover Settings in Windows Server 2003
This article is to discuss a number of important cluster Group and Resource properties that have significant impact on failover behaviors.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
The HierarchyID Datatype in SQL Server 2008
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
Views and Horizontal Partitioning
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers