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 (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139842 Visits: 19413
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
Mr or Mrs. 500
Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)Mr or Mrs. 500 (589 reputation)

Group: General Forum Members
Points: 589 Visits: 285
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?
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16134 Visits: 3403
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
www.simple-talk.com
Gary Varga
Gary Varga
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26475 Visits: 6541
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
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2286 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
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26475 Visits: 6541
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
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3784 Visits: 2558
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 Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63789 Visits: 18570
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
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26475 Visits: 6541
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
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3641 Visits: 2375
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