Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,139 reads
Art
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...
2012-03-14
8,475 reads
Trello: An agile style kan-ban web app that really works
I am no different to many others where I am being asked to work on various projects concurrently and expected...
2012-02-29 (first published: 2012-02-27)
2,881 reads
Blogging: Controlling SPAM in Orchard CMS with OpenCaptcha
When I started blogging last year, my first major decision was either to host my own site somewhere using a...
2012-02-16
1,794 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2012-02-07
18,771 reads
Denali
Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...
2012-02-07
834 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2012-02-07
1,267 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2012-02-07
966 reads
Introduction to XML DML (Part 3) - Using the modify() method: delete
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
9,930 reads
Introduction to XML DML (Part 2) - Using the modify() method: replace value of
This is the second part of a 3 part blog which will attempt to show some different ways of how...
2012-01-26
13,338 reads
Blogs
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
Forums
SQL AOAG with listener ( without windows clustering)
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....
Event ID 65102 [Warning] FailoverClusterQueryError
Hello @all, i am facing a problem and can not find a solution... I...
Check scheduled pipelines in ADF
We are used to the job activity monitor in SQL server allowing quick checks...
Ask SSC