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...
March 31, 2015 at 5:54 am
Yet Another DBA (3/31/2015)
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!!!
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...
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...
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...
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 🙂
March 29, 2015 at 8:57 am
Check a success flag outside of the loop to output messages.
March 29, 2015 at 8:54 am
TomThomson (3/27/2015)
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.
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.
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...
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.
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...
March 27, 2015 at 2:09 am
So what is going wrong? How does that differ from what you are expecting?
March 27, 2015 at 1:29 am
Viewing 15 posts - 1,501 through 1,515 (of 3,221 total)