Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)
GilaMonster (1/19/2016)
Gary Varga (1/19/2016)
I agree with your sentiments here but that is not the appropriate way to call a stored procedure from .NET.
No kidding, since I posted it as a...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 19, 2016 at 8:38 am
GilaMonster (1/19/2016)
roger.plowman (1/19/2016)
Stored procedures (and no dynamic SQL in them) are the way to go
No, they're not necessary. Parametrising calls is necessary. That's all.
If the app developer doesn't know what...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 19, 2016 at 8:19 am
This has been a long time coming and I see more and more acceptance of remote work, albeit sometimes on a temporary basis, even at the more staid of places.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 19, 2016 at 8:03 am
GilaMonster (1/4/2016)
roger.plowman (1/4/2016)
SQL, on the other hand, makes it hard to *avoid* accidental code execution inside parameters...
It's not hard at all.
Always parameterise queries (no, stored procs aren't required, parameterised...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 19, 2016 at 4:16 am
It seems that as always some people will read the "near zero administration" or "self-administering" as zero work. It depends on the complexity of the scenario. I have been aware...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 19, 2016 at 2:12 am
jarick 15608 (1/18/2016)
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 18, 2016 at 10:16 am
J Livingston SQL (1/18/2016)
david.dilworth (1/18/2016)
'Cornish' AS TheLanguage
Well there's something that you don't see every day 😉
I think Phil meant "Welsh" not "Cornish"
Must have done as the Cornish equivalent of the...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 18, 2016 at 10:12 am
It restricts the users to writing only DDL build scripts and spits out any DML it finds.
I hate it when languages and systems do this type of restriction. It should...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 18, 2016 at 5:30 am
As for who pays, when it isn't the IT department it is usually the IT department who make the recommendations and do so on the least risk basis. This is...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 18, 2016 at 5:18 am
Definitely one to bear in mind. Often forgotten. Ever present.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 18, 2016 at 4:55 am
It is easy to attribute the work
It is morally right to give credit.
It is often a legal requirement to specify the origins.
So we should just to it.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 15, 2016 at 5:15 am
Iwas Bornready (12/29/2015)
If you don't want your code reused, don't share it.
One difficulty in this area is that some developers feel that they can do what they like with what...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 15, 2016 at 5:11 am
Trick question. The new Systems Administrator is not a wise man :w00t:
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 15, 2016 at 3:30 am
You are most welcome.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 15, 2016 at 2:30 am
Eric M Russell (1/14/2016)
Gary Varga (1/14/2016)
Jeff Moden (1/14/2016)
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
January 15, 2016 at 2:20 am
Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)