IT Budget

Question

Post reply

IT Budget

kapfundestanley

SSCertifiable

Points: 5637
More actions
February 14, 2012 at 7:28 am

#251554

I need to consider tools,software and hardware that I have to forward to management.I do not want to be caught wanting when i request for something that I would not have initially stated before.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Is there a question here?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 2

Sorry,I need any suggestions especially related SQL Server latest trends.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Jared SSC Guru Points: 61793 More actions · Answer 3

If you cannot do this yourself, I would get an experienced consultant. There are so many variables that we cannot be of much help here.

Jared
CE - Microsoft

Lowell SSC Guru Points: 323518 More actions · Answer 4

lol my shops IT budget doesn't have room for any software that would make my life easier; it pretty much covers absolutely required hardware + licenses.

If i wanted something like some of the redgate products, for example , it'd be out of my own pocket, or find/build a near equivalent for free.

i think it's the reverse, if you know your budget, you know what software you can buy to match your budget. For SQL, there's no "must have" software that is not included....just nice to have that makes it easier, but at a cost.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 5

I had a red gate tools in mind ,but just thought there could something out there,that i could be unare of,thank you so much guys.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

LutzM SSC Guru Points: 107049 More actions · Answer 6

There are many tools out there for many different tasks. Some are more reliable than others, some are considered "better" than others (but that's usually just personal preference).

The question is: what task do you need to be supported by a tool?

There are tools for automatic script formatting, extended IntelliSense, Backup tools ( a large variety all by itself), version control,... the list goes on.

And I'm confident you're not aware of "ALL" tools available...;-)

If you're a little more specific what you're looking for, you might get a more detailed answer.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

jcb SSCertifiable Points: 6574 More actions · Answer 7

Hey!

You are the guy from tthe job post!

http://www.sqlservercentral.com/Forums/FindPost1251850.aspx

What is it? An interview question?

Look, if you are in search for reviews for SQL tools you can google for it.

I dont know red gate products but they are SSC sponsor (look to the upper right banner).

Anyway you ill need experience in the tool before recomend it or use it properly.

GSquared SSC Guru Points: 260824 More actions · Answer 8

Some SQL tools I've used:

DB Dev:

SQL Prompt

SQL Search

SQL Compare

SQL Data Compare

SQL Data Generator

SQL Dependency Tracker

SQL Doc

ApexSQL Edit

ApexSQL Version

ApexSQL Refactor

ApexSQL Complete

Team Foundation Server

Visual Source Safe

DB Admin:

Confio Ignite

SQL Monitor

SQL Backup Pro

SQL Multi Script

Those are the ones I can think of off the top of my head.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

The main SQL Server vendors seem to be Red Gate, Quest, Idera, and SQL Sentry, all of whom have a variety of tools. There are others, but those seem to be working the hardest in this market. Embarcadero, Confio, CA, and many smaller companies are out there, but there isn't a trend per se for tools.

Most people look for some sort of backup compression, and there are many ways to do this, including native compression in SQL Server. There are performance related tools that help you write better code or diagnose issues, or monitor your systems, but it really depends on what you need.

Lowell has good advice. Look for things you want to accomplish better, or perform more efficiently. Then look for vendors who make products in that area.