-
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
MySQL GROUP_CONCAT returns [BLOB - 14 B]
A tech post today, I really don’t do enough of these. I bumped into an issue recently where I was building a form guide for ... -
Need some SQL dates?
Just a handful of quickie SQL dates that might come in handy. Run this in Management Studio to return a bunch of commonly needed dates, ...
Programming
Because nothing says fun like nested IF statements and joins
- View more
MYSQL - Find Starting With Lowercase Letter
I recently wanted to update the taxonomy within a CMS to set the name of all tags to begin with an uppercase letter. Over 10+ years I have a messy ... - View moreI have a need to determine the distinct number of ...
- View moreWe're using SSRS caching for a number of reports in ...
