Viewing 15 posts - 31 through 45 (of 74 total)
patrickmcginnis59 10839 (12/19/2014)
David Rueter (12/18/2014)
For example, if HTML included something like <a href="getRecord?id=6">Click for details</a> it would be trivial for a malicious user to call "getRecord?id=5" to retrieve data he...
December 19, 2014 at 8:53 am
I agree that GUIDs for clustered indexes are a bad idea, and GUIDs for primary keys are not generally ideal. But there is at least one additional consideration that...
December 18, 2014 at 12:36 pm
Jason Shadonix (9/11/2014)
September 11, 2014 at 9:26 am
Brilliant! Yes, synonyms for vendor-provided tables.
In fact, a public repository of scripts to create synonyms for common applications could be a great thing:
Working with Great Plains? Run the...
September 11, 2014 at 8:31 am
Unless there is a compelling reason not to, developing on full production data is best.
Consider:
Comprehensive set of values are needed to test logic
[p]Simple things like a NULL where you didn't...
August 21, 2014 at 11:51 pm
Initially we used SQL Compare, but have now matured to the point where this all happens natively in T-SQL code.
Some of the elements of our approach include:
Use a...
April 22, 2014 at 12:55 pm
Thanks for the article. I especially appreciate the Information Maturity Model graphic. What is the source of that? I find it to be very insightful.
FYI, I posted...
April 22, 2014 at 10:40 am
To display elapsed time as Days Hours:Minutes:Seconds I use a secondsToChar() function I wrote, like this:
PRINT dbo.secondsToChar(DATEDIFF(second, '2/21/2013 4:43am', '4/2/2013 3:21pm'))
The result is:
[highlight="#E0E0E0"]40d 10:38:00[/highlight]
The function is defined as:
CREATE FUNCTION [dbo].[secondsToChar]...
September 26, 2013 at 12:30 pm
Yes, as a matter of fact I do. Here is the CLR source (see below).
See another article I wrote "Deploying CLR Assemblies with T-SQL[/url]" for one way to deploy...
August 27, 2013 at 4:43 am
We're off-topic a bit (not talking about Geocoding any more, but rather calling an arbitrary web service). That's OK...
When I run your code (with either URL) I am getting:...
August 27, 2013 at 4:05 am
@Phil: 🙂
Not to belabor the point... but "generation and display of graphic output" sounds like it applies to a PDF...as well as JPG, PNG, HTML, etc. "Rendering" is...
May 9, 2013 at 9:31 am
As @johannconsult's points out, neither this approach nor any other can eliminate malicious tampering with the output. However, using a PDF does discourage tampering more than some...
May 9, 2013 at 8:15 am
Jeff,
Thanks for chiming in. I'm a big fan of yours and have learned a lot from you.
FYI, the attached script does in fact check the status of xp_CmdShell and...
May 8, 2013 at 5:47 pm
Here is a script that demonstrates an ADO-based approach for logging within a transaction that may later be rolled back.
This script creates dbo.spLogErrorCommitted and other needed objects, and prints out...
March 28, 2013 at 4:43 pm
I haven't measured performance for this specific routine, but I have compared performance between CLR and COM calls in the past (i.e. for retrieving HTML from a remote server).
CLR is...
March 28, 2013 at 2:32 pm
Viewing 15 posts - 31 through 45 (of 74 total)