Viewing 15 posts - 1,501 through 1,515 (of 3,221 total)
I have always advocated separation between development and production. In every scenario including one man bands. Even if one doesn't do full separation policy in one go then you can...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 31, 2015 at 5:54 am
Yet Another DBA (3/31/2015)
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 31, 2015 at 5:22 am
Where is it going wrong?
How do you know?
What is different from expected?
That is a reasonably long script. I am sure that you don't expect us to just debug it blindly!!!
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 30, 2015 at 4:00 am
Nice one SQL-DBA-01.
Have you thought of using:
Write-Error
Write-Warning
Write-Verbose
Write-Debug
Write-Progress
They can really help developing and using scripts. Also aids the self documenting aspect of it i.e. when appropriate why add a comment when...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 30, 2015 at 3:57 am
I have used SQL Server for quite a while now (first used v7 in 1999 for anyone interested) and did not know of the existance of RULEs. Possibly this was...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 30, 2015 at 3:49 am
There are some companies that add the term Graduate, Junior, Trainee, etc. to the role of new starters (to the field of computing). Occassionally this involves ensuring that theorectical foundations...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 30, 2015 at 3:11 am
Jeff Moden (3/27/2015)
SQL-DBA-01 (3/27/2015)
I have managed to fix this.Please share what you did. Thanks.
Yes please SQL-DBA-01. Help others please 🙂
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 29, 2015 at 8:57 am
Check a success flag outside of the loop to output messages.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 29, 2015 at 8:54 am
TomThomson (3/27/2015)
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 29, 2015 at 8:39 am
Tom I tend to agree with you about ORMs but have a different opinion on languages both from a technical and preference perspective.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 29, 2015 at 8:30 am
Charles Kincaid (3/27/2015)
...If I have aliased a column I can't order by the alias name. That's nuts (IMHO).
Agreed.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 27, 2015 at 10:40 am
Steve Jones - SSC Editor (3/27/2015)
Eric JOATMON (3/27/2015)
You mention "extra columns in a result set" as being a downside to deploying database changes prior to application code changes. That...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 27, 2015 at 9:35 am
My emphasis:
Phil Parkin (3/27/2015)
...SSDT is my preferred environment. The ability to build and publish is very cool and integration with source control works better.
Good point.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 27, 2015 at 2:12 am
Phil Parkin (3/27/2015)
Gary Varga (3/27/2015)
dwain.c (3/26/2015)
-- Whilst I'm a consultant named Jack
-- I swear that I'll never be back
-- Removing this code
-- Causes server overload
-- Despite you're thinking its a...
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 27, 2015 at 2:09 am
So what is going wrong? How does that differ from what you are expecting?
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 27, 2015 at 1:29 am
Viewing 15 posts - 1,501 through 1,515 (of 3,221 total)