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,959 reads
This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem
2009-02-25
3,100 reads
You can read the previous posts here. To finish up (I think), I want to share a networking technique I stumbled on a few years ago, and talk about one more good reason to network.
2009-02-25
1,553 reads
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
2009-02-25
813 reads
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
2009-02-25
1,056 reads
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
2009-02-25
785 reads
This article is final part of a 5 part series that explores the SSIS features introduced in SQL Server 2008. The final artilce in the series will explore VSTA support for the Script Task and Script Component, Import And Export Wizard Enhancements and how SSIS leverages SQL Server 2008 features.
2009-02-25
3,254 reads
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
2009-02-25
658 reads
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
2009-02-25
896 reads
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
2009-02-25
941 reads
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers