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,220 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,513 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,882 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,795 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
967 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,013 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,529 reads
Blogs
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Cloud Databases Made Simple: Creating Your First AWS RDS Instance
I recently started full time learning of Amazon Web Services (AWS). I found that...
Forums
cluster node quarantined
evening All hoping someone can shed some light - I have a (originally) 2...
Is this version SQL Server Management Studio15.0.18424.0 buggy or...?
Maybe I'm just doing something really simple and dumb. I imported a bunch of...
C# - how to convert string to date
Hi everyone I am not too experienced using C#. I need to convert date...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers