The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use within the pipeline without code or a SQL Server connection. As featured in The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimbal Group.
Today Steve Jones complains a bit about time zone support in SQL Server and why it seems so cumbersome. Shouldn't it be easier in 2012?
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
Today's editorial was originally published on August 21, 2007. It is being re-run as Steve is traveling. What a cool job it must be to try and tune and get the most performance out of a system.
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
Better security can be achieved by writing better code. Steve Jones agrees, but doesn't think it's as easy as it sounds.
Before you even install SQL Server, there a number of preparatory steps you need to take in order to get a new machine with a fresh copy of the operating system completely ready to install SQL Server properly. This is to maximize performance, reliability, and security.
How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.
This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. Today Steve talks about the potential problems with killing SPIDs in SQL Server.
The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
I am not sure which is the best way to proceed. I have parent...
Comments posted to this topic are about the item Hyperscale Replicas III
Comments posted to this topic are about the item Development Is Fun
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers