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,760 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,934 reads
A unique solution that allows Reporting Services to easily publish information from your SQL Server Error logs.
2008-05-06
7,633 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
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Communication, For Incidents and Life
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item Building a Support Ticket Triage...
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers