Creating templates for use in BIDS (SQL Spackle)
Learn how to create and use templates in BIDS in this short SQL Spackle article.
2013-12-30 (first published: 2011-04-21)
11,023 reads
Articles
The Ultimate Tool List
This week Steve Jones looks at a few tools that can help your productivity and links to a few more.
2013-12-30
362 reads
Migrating SQL Server Database to Windows Azure - Deploying SQL Database
There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.
2013-12-30
3,822 reads
The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)
This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)
2013-12-28 (first published: 2013-12-10)
7,527 reads
The Importance of Validating Backups
You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.
2013-12-27 (first published: 2012-09-24)
11,798 reads
The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions
Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.
2013-12-27
3,340 reads
Generate multiple SSIS packages using BIML and metadata
Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.
2013-12-26
3,511 reads
How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
2013-12-25 (first published: 2010-10-11)
10,230 reads
Parameterized Queries
A Greg Larsen classic - he discusses how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.
2013-12-25
6,728 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
2013-12-24 (first published: 2011-07-12)
9,674 reads
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers