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,028 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
374 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 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,908 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,250 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,684 reads
Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
2013-12-24 (first published: 2010-12-08)
14,964 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers