Applying Your Scripts across Multiple SQL Server Databases
This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.
2008-03-20
3,639 reads
Articles
ETL for Free-Form Data
This article demonstrates how to extract, transform and load free-form data into a structured form like a staging table by way of XML conversions.
2008-03-20
5,622 reads
Sharing
As humans we look to share with each other, but there are times that this can be a bad thing. Steve Jones has a poll asking you about your sharing habits.
2008-03-20
35 reads
Sharing
As humans we look to share with each other, but there are times that this can be a bad thing. Steve Jones has a poll asking you about your sharing habits.
2008-03-20
29 reads
SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup
Part 18 of this series explores several scenarios in which the Merge Web Synchronization can be applied and describes their implementation details.
2008-03-20
1,747 reads
Using the CASE expression instead of dynamic SQL
I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?
2008-03-20
6,666 reads
Conditional Flow in DTS
While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.
2008-03-19 (first published: 2007-06-07)
10,359 reads
SQL Server Scalabilty - An Introduction
A brief introduction into the world of scalability, presenting at a high-level the various options
2008-03-19
2,108 reads
XML Workshop XVI - Shaping the XML results
Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.
2008-03-19
4,833 reads
CS Techcast 16: Revving Up SQL Server 2008
CStechcast.com brings another podcast episode to the starting line with guest Kalen Delaney. This SQL Server expert and authoritative author of the Inside SQL Server series gives us her take on SQL Server 2008. Find the latest from Kalen Delaney at insidesqlserver.com and SQLCommunity.com.
2008-03-19
1,207 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