Updated blog Site
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
147 reads
Blog Posts
Versioning In Your SQL Database
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...
2014-11-12 (first published: 2014-11-07)
6,990 reads
#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,410 reads
Consuming the Output of an SSIS Package in a Client Application
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...
2014-11-11
4,831 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
692 reads
Join me in DC for a full day of Biml
I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml...
2014-11-11
609 reads
PASS Summit 2014 – It’s not you, it’s me
After an exciting week at the PASS Summit, I’m back home with my family. This was my first ever PASS...
2014-11-11
607 reads
PASS Summit 2014 in Review
I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to...
2014-11-11
1,190 reads
PASS Summit 2014 in Review
I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to...
2014-11-11
934 reads
Power Testing ETL with Power BI – The Process
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...
2014-11-11
1,281 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
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...
Forums
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers