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


The Desktop Setup


The Desktop Setup

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

Group: Administrators
Points: 151284 Visits: 19455
Comments posted to this topic are about the item The Desktop Setup

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
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)

Group: General Forum Members
Points: 223126 Visits: 42003
To be honest, I don't want or need much either as a DBA or and SQL Server Developer. I've learned to use the basic tools to get along just fine. Part of that was by necessity when working as a consultant. Lot's of places just don't have all the nifty little or great big tools either due to budget or because they don't want to support them or because of "security issues". It'll be difficult for many to accept but PowerShell, SSIS, SSRS, SSAS, SSSB, Internet access, and a shedload of other tools all seem to fall into one or the other of those categories in many of the companies I've done work for. I've also worked for places where I can't even use a thumb drive due to security restrictions. I'd have been dead in the water if I relied on tools other than the basic tools that come with the product.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
dogramone
dogramone
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1001 Visits: 3837
I agree with Jeff, too often in the past I became reliant on something that was then taken away or was not available in a move/restructure. So I've come to rely on ctrl/printscreen for image capture, a word processor of any sort for image manipulation and documenatation and SSMS. And of course email to liase with clients and as a mechanism for getting sign off.
A working chair is nice but not important, the one I'm sitting on now slowly descends through the day so I "suck it up princess" and just keep re-adjusting.
Use what's available and make sure you can manage with the minimal.



Knut Boehnert
Knut Boehnert
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1361 Visits: 384
Only thing I really need to be productive is one screen with 1920x1280 resolution. Anything less and I find myself scrolling more often than doing actual work. And one with a decent screen refresh rate. Too often I looked at a screen where a co-worker mentioned an eye strain and I could see it flicker - less than 60 Hz. Especially in the old days of CRT monitors.

Other than that a screen capture and edit tool is nice but Paint will get the job done sufficiently in a crunch.

Oh, and my little (private) laptop just to listen to music to zone in when I need to do any stuff where I need to concentrate.
Dalkeith
Dalkeith
Mr or Mrs. 500
Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)

Group: General Forum Members
Points: 570 Visits: 1121
The only unusual thing that I like to have is a home made Project/CRM software that I put together just for myself. It holds all my contacts and a list of the projects I am working on at the moment. Can detail documents and notes on projects. It will tell me what meetings are coming up and I can place people into projects. For research purposes I can store hyperlinks to projects. It helps automate putting e-mails in outlook and will put them in alphabetical order in the e-mail means I never miss people out and I'm totally pc in how things are placed in order etc… Because its just for me I continuously alter it to allow for particular things that will help me as a result its very eclectic. For example I m trying to learn Russian at the moment and so I've got a russian dictionary in it however it only has those words that I have learn't - which is not many! - so it’s a totally remedial russian dictionary. Thinking about putting in a form so I can test myself on the words that I place in it. The act of designing the table has been helping me learn the structure of the tenses cases etc. Another eclectic bit of development - I coach at a swim club on Fridays and its better to have a swim set to work to - I've got a simple form that I can write swim sets in and it will format it and print it out in a clean and consistent fashion. Its basically a complete mix of work and personal that I can access pretty much from anywhere. Passing between projects not every place has project management software so this gives me a consistent structure to the projects I'm involved in both at work and at home and being my own design I will add subtract to design according to requirements.

The idea is to reduce all that time spent "trying to find stuff"
Being the only user and my own design - I can neither have it taken away and always alter it to fit my requirements at the time.

It is my one luxury.
richardmgreen1
richardmgreen1
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2099 Visits: 1020
As long as I have a chair that works (even one that slowly descends), a desk that's not too badly beaten-up, a decent monitor (I agree with Knut on the resolution) and the basic SSMS I can do whatever I need to do.
I also use Office packages for dumping data in, image manipulation, etc.

My only real "nice-to-have" is a second monitor (or even a third if I can get it).
Christy M
Christy M
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1248 Visits: 221
As with Jeff above, I don't really use anything much apart from the standard tools for my job SSMS, Visual Studio, Office and a couple of specific business systems. I tend not to customise my environment within these applications much either, mainly because I don't really see the point. It did make it much easier to get up and running on different machines just before Christmas when we lost power to our building a couple of times and I had a mixture of working at my desk, working from home and working in another of our offices!
david.john.gilligan
david.john.gilligan
Mr or Mrs. 500
Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)

Group: General Forum Members
Points: 533 Visits: 550
Call me greedy, but I work somewhat as a DBA, DB developer and VB programmer for our finance department. Not that I am an expert at any but know enough to get the job done (usually Wink. Since I sometimes have to use VS, SSMS, Excel and usually a third-party tool at the same time, I would find it very difficult without two monitors. I have actually been given as many as four (in a somewhat different role).

Oh and a 3rd monitor dedicated to BOL and sqlservercentral would be nice!!!
Tracy McKibben
Tracy McKibben
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 798
Depends on the role I'm playing.

To function purely as a DBA, I don't need anything more than SSMS. In fact, for years I thumbed my nose at any third-party tools, simply because I didn't want to become dependent on something that hides the details behind a pretty wizard. I wanted to know how to run a backup using T-SQL, or how to make DDL changes to a giant table using T-SQL, or.... Wizards are nice, but if you don't understand what they're really doing, what do you do when the wizard fails?

To function as a DBA/blogger/presenter/writer/general-computer-user, well, the list is different. SSMS obviously, but I also install, by default, Notepad++, Evernote, Dropbox, Chrome, Greenshot, Ditto, and Zoomit. Can I function without these? Yes, but they certainly make life easier.

A good chair is a plus as well, although I do a lot of work standing up, or on my treadmill desk, or even parked in a recliner. If I could get a standing desk at work, I'd rarely sit down.
DHL-John.Parker
DHL-John.Parker
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 39
In my job, I am not purely a developer and dba, although I spend a lot of time in those roles. I also am a quality manager for a daily operation, and have to be available to drop anything I'm working on and investigate a customer complaint, or provide analysis of a performance topic. So with that in mind, the first big thing for my desktop environment is multiple monitors. I currently have managed to get three in a really cool configuration. I have one 30" widescreen monitor in landscape orientation at the center (2560x1600), and two 20" 4x3 monitors in portrait orientation on either side (1200x1600). This gives me an awesome workspace of 4960x1600, and allows me to have Outlook running on one side monitor to keep an eye on incoming emails, and web pages, etc up on the other side monitor for research, etc. When doing development work, I keep my code on the center screen, and use one of the sides for viewing the UI, or for testing the app as I work... Over the years I have come to have a pretty specific setup for my desktop, and have gotten pretty good at migrating from one PC to another fairly quickly (I've had to do this a handful of times at least...)

1) Multiple monitors (3 preferred)
2) UltraMon (for easily managing a multi-monitor environment.
3) MS Office
4) SSMS
5) DBVisualizer - For working in a few Oracle databases I have access too (not as DBA)
6) VS
7) Notepad ++
8) FastStone Capture (Screen Capture tool, including video screen capture. Awesome for training videos.)
9) Dameware (For managing a handful of remote, unmanned PC's that do automated work collecting data and sending reports.
10) Dedicated NAS (1 TB) - Keep all of my work saved there... makes PC transitions much easier, and allows me to work from my laptop equally as easily as from my desktop.

As far as desk and chair, as long as I have room for my monitors, and a chair that is comfortable, I'm good.

I like this topic! I've become pretty peculiar with my set-up, so this hit home. :-)

John
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