Dynamically create and populate staging tables from CSV files
This SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.
Raw Materials - Order! Order!
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
Referencing Remote Data
Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?
SQL Test: Seeing Red Change to Green
Rob Sullivan is one of the users who are helping shape the way that SQL Test develops, and here he explains what is going on, and why.
On Database Migrations and Agility
It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.
SSMS Shared SQL Templates
This article describes how to use the built in repository for SQL Server Management Studio Templates and how to customize and share a common repository with your team.
The Stubborn DBA
Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?
Constraints and the Test-Driven Database
Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.
TSQL Challenge 73 - Implement Word Wrapping in TSQL
The challenge is to wrap the text by specified position.
Read-only Data
Today's poll looks at read only data and how you handle the backup and recovery of this data.
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers