XML Workshop XIX - Generating an ATOM 1.0 Feed
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,219 reads
Articles
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
2008-05-15
42 reads
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
2008-05-15
32 reads
Finding dependencies in SQL Server 2005
Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.
2008-05-15
2,960 reads
Using DDL triggers to audit events
Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
2008-05-15
3,467 reads
Overview of SSIS
SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package.
2008-05-14 (first published: 2007-06-18)
25,706 reads
The Lighter Side - Life is like an analogy
Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.
2008-05-14
7,006 reads
The SQLServerCentral.com Party - 2008
Steve Jones talks a bit about the upcoming SQLServerCentral.com event at the 2008 PASS Summit and asks for some ideas.
2008-05-14
681 reads
Essential Steps for the Integrated Enterprise Data Warehouse, Part 2
This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.
2008-05-14
2,226 reads
2008-05-14
31 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers