Author Archives: Matt

Reporting Services Scripting for fun and profit

After spending too long on Google, and finally getting an appropriate answer from a colleague, I thought it wise to record this information in case someone finds themselves in a similar situation. This stackoverflow sums up my issue nicely: “I … Continue reading

Posted in SQL Toolbox | Leave a comment

WordPress 3.0.1 upgrade hung!

Just in case anyone’s site gets hung on an upgrade, this is a great tip to get out of maintenance mode. Stuck WordPress Fix I have no idea what caused the issue – I have two WordPress sites with identical … Continue reading

Posted in Uncategorized | Leave a comment

Thought of the day

I was doing some research for a project and stumbled across this gem. I did a quick search for a source, but only found variations on a theme. People don’t want to buy a quarter-inch drill. They want a quarter-inch … Continue reading

Posted in Uncategorized | Leave a comment

Outside the Box Thinking

I had a problem to solve recently, and essentially it boiled down to a need to do multiple pivots in one statement. After playing with it for a little while and not quite getting it the way I wanted, I … Continue reading

Posted in Uncategorized | Leave a comment

Increasing the size of a vmware virtual disk

Adventures in updating the size of the virtual hard disk via VMWare Workstation. Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Hashbytes – VARCHAR vs. VARBINARY Performance

A recent post on sqlservercentral.com got me thinking about Hashbytes recently. I was ignoring the issue of getting a false positive using a hashbyte solution to check for errors, and focused on the performance of the routine. My initial pass … Continue reading

Posted in SQL Server Performance | Tagged , , , , | Leave a comment

Windows Server 2008 & SQL Server 2005

It seems that Windows Server 2008 and/or SQL Server 2005 doesn’t automatically add a firewall exception to the OS for access to the database. As a result, an exception needs to be added, by following instructions found here.

Posted in SQL Toolbox | Tagged , | Leave a comment

First Day of Current Month

SELECT DATEADD( mm, DATEDIFF( mm, 0, GETDATE() ), 0 ) AS FirstOfMonth Since I always manage to get the syntax wrong from memory, above is a SELECT statement that will return the first day of the current month. Edit: As … Continue reading

Posted in SQL Toolbox | Tagged , , | 1 Comment

XML Modification

XML Modification for fun and profit Continue reading

Posted in SQL Server Development | Tagged , , | Leave a comment

XML Nodes Query

A reminder of how the nodes query works inside Microsoft SQL Server. Continue reading

Posted in SQL Server Development, SQL Toolbox | Tagged , | Leave a comment