BYOD Risks and Opportunities: 14 Telling Statistics
Wed, 05 Jun 2013
An impressive 85 percent of educational institutions allow students, teachers and faculty to use personal devices on school networks. This is a huge opportunity for professors and students to engage in new learning styles — and for hackers and criminals to gain access to networks and potential sensitive data.
This post was a reblog of Higher Education Technology by .
Bypassing client-side validation
Mon, 27 May 2013
This post was a reblog of Infosec Reactions by securityreactions.
An interesting model of our solar system’s path as it travels through space in the Milky Way.
Certainly a departure from usual models that show the Sun as a static object, which it certainly isn’t
Fri, 24 May 2013
This post was a reblog of For animated GIFs by 4gifs.
Wed, 17 Apr 2013
26 Things to Note Before You Develop a Website
This post was a reblog of a point in time by richarrdg.
Text-transform Regular Expressions
Mon, 17 Dec 2012
I’ve been formatting emails lately. The CSS support is horrible at best. I’ve found it’s easier to go ahead and apply
text-transform while I’m building an email rather than let the email client try.
Here’s a couple of regular expressions that I built to handle text transformation with ColdFusion.
// Uppercase Words (text-transform: uppercase)
sWords= REReplace( sWords , "(\w+)" , "\U\1\E" , "all";
// Lowercase Words (text-transform: lowercase)
sWords= REReplace( sWords , "(\w+)" , "\L\1\E" , "all" );
// Capitalize Words (text-transform: capitalize;)
sWords= REReplace( sWords , "(\w+)" , "\u\1" , "all" );
SQL Server Suppression Table
Fri, 14 Dec 2012
Suppress Stored Procedure Output
I execute stored procedures from inside stored procedures a lot. It is a nice to reuse code so that the system behaves the same way for similar events.
However, I don’t always want the returned resultsets from an invoked stored procedure to interfere with the resultsets from the calling stored procedure.
The question then is, “How do you suppress the output of stored procedures in SQL Server?”
MySQL has a nice black hole that you can shove anything into and it disappears. The idea here is to implement this in SQL Server.
This is not as robust of a solution as a black hole, but it works fairly well.
You’ll need to create a temporary table and allow the stored procedure results to insert into it. You’ll need to craft the suppression table to match the resultset of the invoked stored procedure so that the$
-- SQL Server Suppression Table
-- Suppress Stored Procedure Output
-- Create Suppression Table
CREATE TABLE #SuppressionTable (
-- Insert ResultSet into Suppression Table
INSERT INTO #SuppressionTable
-- Execute Stored Procedure
-- Forget Suppressed Data
DROP TABLE #SuppressionTable
You can check out the gist at https://gist.github.com/4277332.