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,381 reads
SQL Server Rocks!
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,569 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,886 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,801 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
980 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
835 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,270 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,774 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)
10,146 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,845 reads
Blogs
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Forums
The Table Backup
Comments posted to this topic are about the item The Table Backup
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Monoliths and Microservices
Comments posted to this topic are about the item Monoliths and Microservices
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers