Using Change Tracking in SSIS
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,674 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
387 reads
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
501 reads
Foundations Friday starts now
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
446 reads
Push Button Deployments
I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...
2016-01-21
531 reads
Easy Installing .NET 3.5 for SQL Admins
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,474 reads
Book review – Extending SSIS with .NET Scripting
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,865 reads
Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks
There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...
2016-01-21
869 reads
Return of the .NET - NYC
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,243 reads
What is RapidMiner
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
558 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers