Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.
2008-03-26
13,688 reads
Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.
2008-03-19
4,808 reads
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,685 reads
Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.
2008-02-13
7,836 reads
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
2008-02-06
8,732 reads
Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.
2008-01-23
3,168 reads
2008-01-02
2,897 reads
Part 3 of his series looking at SQL Server Compact Edition, then embedded version of SQL Server. This time we look at the new version that's in beta.
2007-12-27
2,209 reads
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,869 reads
Building SSIS packages and deploying them to production can be a challenge as connection strings and directory structures change. Longtime SQL Server guru Jacob Sebastian brings us a technique for building packages to make this easier.
2007-12-12
11,220 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers