Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
2009-09-14
9,827 reads
This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.
2009-07-22
6,732 reads
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
2009-02-25
3,937 reads
SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.
2009-02-13 (first published: 2007-09-12)
34,225 reads
Continuing on with his series on SQL Server 2008, MVP Jacob Sebastian brings us a look at the debugger, which has returned in SQL Server 2008.
2008-10-15
5,856 reads
RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.
2008-10-01
3,051 reads
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
2008-09-25 (first published: 2007-05-09)
29,455 reads
SQL Server MVP Jacob Sebastian starts a new series looking at the changes in SQL Server 2008 to the management tools.
2008-07-30
7,207 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,679 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)
11,167 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Comments posted to this topic are about the item Limits, Not Goals
MS SQL Server/SSMS are my tools. As my project evolves I find I need...
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...
What is the precision, length, and scale for an int variable?
See possible answers