Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
358 reads
Koen Verbeeck
Stupid me #3 – Building the script component
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
644 reads
Stupid me #3 – Building the script component
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
356 reads
T-SQL Tuesday #46: Rube Goldberg Machine
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
795 reads
T-SQL Tuesday #46: Rube Goldberg Machine
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
437 reads
SSIS Deployment with PowerShell: Adding Environment References
With the release of the revamped Integration Services in SQL Server 2012, a bunch of new deployment methods were introduced...
2013-08-21
7,718 reads
Rants about Connect
The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions...
2013-07-29
709 reads
Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2013-07-16
1,089 reads
T-SQL Tuesday #44: The second chance
This month’s T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is...
2013-07-09
636 reads
SQL 2014 CTP1, where is my BIDS?
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...
2013-06-28
4,491 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