Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.
2008-05-07 (first published: 2007-05-16)
65,672 reads
Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more
2008-05-07
2,498 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
36 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
38 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
39 reads
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
2008-05-07
3,048 reads
This is a product that we have not heard much about, but Microsoft has a Data Protection Manager, designed to help ensure you can recover your databases by centralizing your backup files. Author Jay Dave brings us a short overview on this product.
2008-05-06 (first published: 2007-05-23)
5,894 reads
A unique solution that allows Reporting Services to easily publish information from your SQL Server Error logs.
2008-05-06
7,568 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
36 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
31 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers