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.
A short piece on indexing using multiple columns. For those of you that have 10 single column indexes, read a little about why you might choose to index on multiple columns.
A service oriented architecture seeks to decouple some of the tight connections normally built between systems and components. Here's a great overview on how messaging between systems can be setup from MSDN.
We've grown much faster and further than we expected and so the time has come to move. To a new collocation facility this weekend. We'll be down for a few hours Saturday and hopefully after that you won't notice a thing.
Another great article from David Poole looking at more user stereo types that the IT world must deal with. Read on for smile and a little fun.
The first article looking at the new BI scorecard technology from Microsoft. This allows you to quickly deploy some easy reports on your OLAP system. From datawarehouse.com.
What happens to SQL Server 2000 indexes over time? Fragmentation is one of the effects and Steve Jones looks at how you can work with and identity fragmentation.
Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.
Continuing his series on SQL Server and InfoPath 2003, the new reporting tool that has been added to Office. This time Dinesh looks at a practical application using expense entry along with some more features of this new tool.
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
Buy kratom online has never been more convenient than now. With trusted platforms like...
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Which of these inputs is the smaller input to a hash join?
See possible answers