Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2014-11-12
299 reads
Blog Posts
I need your help
The Situation
On the 19th November I am going to be presenting two sessions for the Luxembourg PASS chapter at the...
2014-11-12 (first published: 2014-11-07)
6,059 reads
MDX #43–Find a MDX Calculation Script
Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure...
2014-11-12
1,341 reads
PASS BI VC: How to (not) torment your fellow SSIS developer?
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS...
2014-11-12
693 reads
PASS DBA Virtual Chapter Webcast 20141112
Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about...
2014-11-12
675 reads
Should you move your data to the cloud?
Should you move your data to the cloud? That is the question. The answer is not simple. While moving data...
2014-11-12
740 reads
Speaking at SQL Saturday #354 – Charleston, SC
If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston...
2014-11-12
646 reads
Super Early Bird Registration for the Networking Dinner at the 2015 PASS Summit
Looking for a reason to show up at the 2015 PASS Summit on Monday, or just want something fun to...
2014-11-12
679 reads
T-SQL Tricks – Templates in SSMS
There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s...
2014-11-12
1,048 reads
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
413 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