XML Workshop XV - Accessing FOR XML results with ADO.NET
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,656 reads
Jacob Sebastian
XML Workshop XIV - Generating an XML Tree
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,804 reads
Generating Missing Dates and Numbers
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,684 reads
SQLCE Workshop IV - Integration with Visual Studio 2005
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,155 reads
SQLCE Workshop III - Getting started with 3.5 Beta
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,181 reads
XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,837 reads
Creating Location Independent SSIS packages
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,200 reads
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
2007-12-05
7,116 reads
XML Workshop XI - Default Namespaces
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
2007-11-21
4,484 reads
TSQL Lab I - Playing around with ROW_NUMBER
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
2007-11-14
6,175 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers