-
Find text in Stored Procedures
I can't express how useful this has been to me when trying to find whether a text string exists in one of our Stored Procedures / Functions: -
Most Active Databases in SQL Server
I recently had someone ask what the most active databases were in our SQL Server. Well... we knew which was the most active (based on our application) but there were ... -
Add a column with a default and foreign key constraint
Every so often you may be presented with the requirement to add an additional column to one of your database tables. My experience, with SQL Server 2008 and above at ... -
Welcome Baby Katherine
More than fourteen years ago I heard for the first time that I was going to be a father. To a boy. I think dads secretly long to hear those ... -
Delete rows in Excel from a list
I had the need recently where I was provided an Excel XML file containing a large list of SKU's. From this list I queried a SQL database to figure out ... -
How to find my full sitepath?
Having trouble finding the full path in your shared web hosting / VPS? <?php echo $_SERVER["DOCUMENT_ROOT"];?> PHP Manual describes it as: The document root directory under which the current script ... -
2012/13 - That Tied Illawarra 2nd Grade Grand Final
Undoubtedly the rivalry of the season in 2nd Grade were the clashes between the Northern Districts Butchers and the Wollongong Lighthouse Keepers. Not only did they finish just 2-points apart ... -
Hide SSRS Toolbar
If you'd like to hide the Report Viewer toolbar whilst utilising ReportServer, you can simply append the following to the end of the query string: &rc:Toolbar=false Which may end up ... -
SSRS – Alternate Row Colors of A Group
This has always been a challenge in Reporting Services – you’ve tried using this standard alternate row shading for a group but the alternation doesn’t work as expected: For a ... -
Get First Day of the Quarter
I’m building a Stored Procedure and Report that needs to limit to data created in the previous quarter, only. The assumption is the report will be run on the first ... -
SSRS – Mixed formatting breaks hyperlink action
I have a textbox that hyperlinks to another report via textbox action. However, in SSRS 2008 you can now now have multiple text elements within one textbox – so you ... -
SSRS – Capitalize the first letter
Need the ability to Capitalize the first letter of a string within SSRS? I found a gem of an SSRS function by Paul Turley of SolidQ. From SSRS Report Properties ... -
Get first & last day of the month
I'm building a Stored Procedure and Report that sets the default start date as the first day of the month one (1) month ago. Can easily be adapted to this ... -
Repeat header columns on each page not working
Reference: Visual Studio 2008, Microsoft SQL Server 2008 You’ve created a table in Reporting Services, added data, added column headers and you’re now trying to set the column headers to ... -
Go Daddy Apache Upgrade
Go Daddy just upgraded Apache on one of the webservers I use; an important one. I found out the hard way when I discovered my league website was entirely broken ...
