XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT
This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.
2008-07-16
2,670 reads
This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.
2008-07-16
2,670 reads
In a followup to his article on SQL Server Everywhere, Jacob Sebastian takes a more in-depth look at the smallest platform for SQL Server, Compact Edtion.
2008-06-05 (first published: 2007-07-10)
10,885 reads
SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.
2008-06-04
4,121 reads
Accessing your SQL Server without Enterprise Manager or Management Studio can be a difficult task without a custom application. Especially if you are not in the office. Jacob Sebastian brings us an open source application that can make this much easier for DBAs.
2008-05-27 (first published: 2007-06-27)
7,420 reads
Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.
2008-05-22 (first published: 2007-06-20)
20,636 reads
Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.
2008-05-19 (first published: 2007-07-25)
6,521 reads
Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.
2008-05-15
3,175 reads
In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.
2008-05-02 (first published: 2007-05-30)
69,083 reads
Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.
2008-04-09
6,440 reads
How many times have you wished that your queries performed better? Performance Tuning is a bit of an art, but learning about new techniques and which things work help grow your knowledge. Jacob Sebastian brings us the first part of a series on writing better performing queries.
2008-03-31 (first published: 2007-05-22)
30,049 reads
By HeyMo0sh
This blog post is about Test Data Management – or my take on it....
By Steve Jones
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at...
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
I'm hoping someone here has encountered this before and was able to fix it....
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers