SQL Clone
SQLServerCentral is supported by Redgate
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!

Archives: May 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, 5,002 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, 2,206 reads

Posted in SQL Server Rocks! on 10 May 2012