About my blog

I write about the technical and non-technical aspects of software development

How it works

Microsoft ASP.NETASP.Net
BlogEngine.NET BlogEngine.NET
Azure DevOpsAzure DevOps

Contact info

 Email
 Contact

Follow me

Prod-20240407.1

Tags

Posts tagged with 'SQL Server'

Creating Configurable and Portable SSIS Packages Part 3
Creating Configurable and Portable SSIS Packages Part 3

In this article I’ll conclude my set of articles into SSIS configuration. This article will be

Creating Configurable and Portable SSIS Packages Part 2
Creating Configurable and Portable SSIS Packages Part 2

In Part 1 I showed how a simple SSIS package could be created using variables and expressions as a b

Get a comma-delimited list of columns
Get a comma-delimited list of columns

One of the things I've been doing recently has been writing lots of SQL inserts in which I've had to

How to tell what has changed in a SQL Server Database
How to tell what has changed in a SQL Server Database

One of the things I've had to do recently is work out if objects on a SQL Server had been modified a

How to Import and Export DTS packages quickly
How to Import and Export DTS packages quickly

This article applies to DTS packages on SQL Server 2008 R2, but will probably work on most other ver

Handling Orphaned Database Users
Handling Orphaned Database Users

This isn't the first time I've had to deal with orphaned users in SQL Server, and probably won't be

🍂 🍂 🍂 🍂 🍂 🍂 🍂