SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No Works of Art


No Works of Art

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81857 Visits: 19215
Comments posted to this topic are about the item No Works of Art

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Robert Sterbal-482516
Robert Sterbal-482516
SSC Veteran
SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)

Group: General Forum Members
Points: 296 Visits: 263
This is a very hard sell for me at work. Has anyone gone through the process of changing a culture from using GUI based installers to one using a text/scripting process?
David.Poole
David.Poole
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10080 Visits: 3340
We've moved to the point where everything developed in the past 12 months is deployed using Puppet and Vagrant. You trigger a build and a pre-configured system materialises either on your desktops or your servers.

The challenge for us has been getting something that happily builds from a single master to something that can build on many hundred machines without a single master dependency.

Technologies like Docker look incredibly promising.

By treating infrastructure as software it means that the full configuration goes under version control!

It's a brave and better new world.

LinkedIn Profile

Newbie on www.simple-talk.com
Gary Varga
Gary Varga
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19675 Visits: 6534
Just like many readers of this editorial, I am sure, half way through I was thinking "scripting". It is a great way to maintain documentation (please tell me you add comments to your scripts!!!) in a way that assists manual ad hoc tasks as well as enabling automation.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Graeme100
Graeme100
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1620 Visits: 795
Interesting Topic

We have a very complicated process to deploy our product. We use a combination of msi and powershell and manual configuration. Talk about work of art, this belongs in MoMA Smile

Seriously, because the software/product relies on so many technologies, SQL Server/IIS/SSIS/MongoDB, the deployment is very involved but credit to the developers, they are moving towards a simpler version that is more scripted. But it is taking a while.

This is ok but the deployment tends to be more "black box" and when things go wrong it needs more than one person to deal with it. So we have the issue of confidence in the deployment.

We also suffer from a 2 week deployment cycle which means we have very little time to test before a live release. We don't even have a environment that mirrors live..shocking I know

All these things make for quite an anxious time. But amazingly we continue to release.

I am all for a scripted approach or at least an automated process that removes decisions from the deployment engineer but can we really get there when there are many technologies and are we widening the knowledge gap between the creators of the software and those that are supposed to support it (I know this will vary company to company, but in my company we tend to keep developers away from Customer Support Wink )

Graeme



Gary Varga
Gary Varga
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19675 Visits: 6534
I am also a big fan of (preferably scriptable) environment testing utilities. Often PowerShell cmdlets.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
chrisn-585491
chrisn-585491
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2588 Visits: 2471
I'm a student of Master Sean McCown and his attitude towards being an Enterprise DBA: Let's script or automate everything!
SQLRNNR
SQLRNNR
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40353 Visits: 18565
Scripting and automation are great tools. They are perfect tools for lazy DBAs (we like to not have to do the same manual thing over and over). Sure it may take a little bit of extra effort to get there, but hopefully that effort level does not exceed the effort level of doing things manually.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Gary Varga
Gary Varga
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19675 Visits: 6534
Sometimes it is not wasted time but mistakes that are trying to be avoided.

Of course, if the script is not robust nor tested enough you can repeated the same mistake loads of times pretty quickly!!!

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
jay-h
jay-h
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2352 Visits: 2341
Documents never get rev'ed to keep up with changes. Human memory is faulty, and certainly we find ourselves clicking the wrong button at times

Alas, scripts (especially the 'auto answer' variety) suffer from the same problem, perhaps more dangerously because you never easily see what is being replied

...

-- FORTRAN manual for Xerox Computers --
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search