A Survey of Microsoft SQL Server 2000 XML Features
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.
2004-09-20
13,005 reads
Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.
2004-07-27
30,174 reads
2008-01-04 (first published: 2003-09-26)
185,242 reads
Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.
2003-02-20
13,125 reads
In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.
2002-10-17
7,018 reads
This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.
2002-08-08
5,877 reads
An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.
2002-07-22
9,104 reads
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,338 reads
This article demonstrates the ability to use the XML DOM on the client-side browser.
2002-04-11
16,687 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers