The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful extensions to SQL Server. Robert Sheldon, in the first part of a series, describes how create and index a XML column in a table, and discusses when you should consider using an XML data type.
2011-12-02
3,378 reads
Mind mapping software allows the rapid capture of thoughts and ideas. It is a killer app that can easily help a busy DBA capture their thoughts
2011-12-01
8,103 reads
2011-12-01 (first published: 2010-04-07)
9,988 reads
SQL Server offers a simple tool for business users to perform ad-hoc reporting.
2011-12-01
3,439 reads
DBAs are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries.
2011-11-30
2,633 reads
Our space judges are checking over the DBA in Space entries ready to reveal the finalists on December 6th. Meanwhile, we've revealed the answers, so why not take a look?
2011-11-30 (first published: 2011-11-25)
4,446 reads
Red Gate is doing some research into Visual Studio add-ins for SQL development. If you can spare a moment to complete a short survey, or are interested in being part of the early access program (linked from the end of the survey), please click here.
2011-11-30
2,845 reads
Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.
2011-11-29 (first published: 2011-11-21)
1,190 reads
2011-11-29 (first published: 2010-03-31)
9,995 reads
The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.
2011-11-29
4,513 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers