Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

SQLBits XI recently announced

When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply made my day! Fantastic!!! I can’t wait now until the registration is open as I’ll be signing up as quickly as I can for the full event. I’m already seeking… Read more

0 comments, 376 reads

Posted in SQL Server Rocks! on 14 November 2012

Your online security is only as good as the weakest link

Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a verification code in the email to do that. It was a simple plain text email with no images or anything so I thought that this was just a spoof email… Read more

0 comments, 1,173 reads

Posted in SQL Server Rocks! on 24 October 2012

OVER() clause two simple ways on two different days

I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because I’ve rarely had the need to use windowing functions because I primarily work with XML and relational data that doesn’t need to be aggregated that often or have ranking applied… Read more

0 comments, 579 reads

Posted in SQL Server Rocks! on 26 September 2012

Suppressing namespace attributes in nested select statements when using FOR XML workaround

I was helping out on the forums the other day with a user who had stumbled across the quirk of SQL putting in an excessive amount of namespace declarations when using nested select statements as part of a FOR XML statement. There is a connect item already open for this,… Read more

0 comments, 803 reads

Posted in SQL Server Rocks! on 28 August 2012

Script to find orphaned/unreachable job steps within your SQL jobs

SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created by allowing great flexibility with the scheduling, execution, flow actions and notifications. Invariably, when jobs are setup, they just run and run without many problems, but the other day I… Read more

0 comments, 791 reads

Posted in SQL Server Rocks! on 23 August 2012

Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value

Not another comma separated string blog post I hear you say! I know that this topic has probably been done to death but I hope that this is a little different as it is about creating a single xml node containing a comma separated string from the values of multiple… Read more

0 comments, 1,381 reads

Posted in SQL Server Rocks! on 13 July 2012

Moving xml child elements to its parent using XQuery

I haven’t been able to do much XQuery development recently which is a shame as I love developing with the technology in SQL. In the past I used to work with xslt’s a lot and they immensely powerful, but since moving to xquerying in SQL, it is now my first… Read more

0 comments, 1,315 reads

Posted in SQL Server Rocks! on 9 July 2012

Unable to activate a Windows 2003 VM on Hyper-V behind a proxy

Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I did run into this problem myself a couple of weeks ago whilst creating a very specific build to test some functionality and seeing as it took me a little bit… Read more

0 comments, 1,215 reads

Posted in SQL Server Rocks! on 25 June 2012

Shredding a simple xml structure to a single row flat table

I was helping out a user on the forums the other day where they were asking questions about shredding an xml structure of which they didn’t know the schema for. They wanted to know the best way about writing a generic function to shred any xml to a flat table.… Read more

0 comments, 3,188 reads

Posted in SQL Server Rocks! on 16 May 2012

Command line to configure windows firewall for SQL server access

I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore is the wizard to configure the windows firewall on the host. So I done a quick bit of research today and found that the windows firewall can be configured from… Read more

0 comments, 1,210 reads

Posted in SQL Server Rocks! on 10 May 2012

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 data type, and I use service broker a lot for messaging between solutions. Over the years it has proven to be extremely reliable; only really stopping because of a poison… Read more

0 comments, 592 reads

Posted in SQL Server Rocks! on 16 April 2012

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 a full read/write RESTful API. Awesome! After a bit of thought I realised that I should be able to use the API to create new cards in Trello from within… Read more

0 comments, 2,561 reads

Posted in SQL Server Rocks! on 14 March 2012

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 to work through a long list of technical debt that needs addressing with our SQL databases. Throw in the usual day to day production issues as well and you get… Read more

0 comments, 2,219 reads

Posted in SQL Server Rocks! on 27 February 2012

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 CMS type system or use an online blogging service like blogger for example. Ultimately, because I wanted to have quite fine grained control over my blogs and also the space… Read more

0 comments, 860 reads

Posted in SQL Server Rocks! on 16 February 2012

SQLBits9

SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was fortunate enough to be able to attend all three days. I was not disappointed! Walking through the main door and up the stairs into the main conference hall, I… Read more

0 comments, 526 reads

Posted in SQL Server Rocks! on 7 February 2012

Denali

Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!

Announced at the PASS Summit 2011, it is due to be released to manufactoring in the first half of next year.

The other major announcement from PASS was Microsoft actively supporting the Hadoop… Read more

0 comments, 488 reads

Posted in SQL Server Rocks! on 7 February 2012

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 you a much cleaner and faster query plan. If like me you commonly use the name of an element or attribute as part of an XQuery predicate, then you would… Read more

0 comments, 665 reads

Posted in SQL Server Rocks! on 7 February 2012

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 shredding a comma separated string to a table that I come up with today, albeit with help from the very clever Itzik Ban-Gan cross join nested CTE that many of… Read more

0 comments, 8,289 reads

Posted in SQL Server Rocks! on 7 February 2012

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 you can use the xml modify() method to update the contents of an XML document. This part, starting at the absolute basics, will cover the ability to delete data in… Read more

0 comments, 3,093 reads

Posted in SQL Server Rocks! on 2 February 2012

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 you can use the xml modify() method to update the contents of an XML document. This part, starting at the absolute basics, will cover the ability to update data in… Read more

0 comments, 3,497 reads

Posted in SQL Server Rocks! on 26 January 2012

Newer posts

Older posts