Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Who Built This Thing?


Who Built This Thing?

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

Group: Administrators
Points: 52224 Visits: 19006
Comments posted to this topic are about the item Who Built This Thing?

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
majorbloodnock
majorbloodnock
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1279 Visits: 3062
I'm sure a few minutes of my time could come up with several suggestions for how to make SQL Server more user-friendly (at least for me), but I'll never spend those minutes, because I don't care about those deficiencies. SQL Server works. It does what I expect of it, reliably and consistently, and that's all that really matters to me. And for that reason, I believe SQL Server to be the single highest quality product to which Microsoft have ever put their name.

I'm not going to worry about detail when the fundamentals are (IMHO) right.

Semper in excretia, sumus solum profundum variat
Carl Federl
Carl Federl
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2852 Visits: 4350
"There are definitely times that I think the people that build the system stored procedures and other code we can see don't really work with SQL Server. It seems that best practices aren't followed and things aren't even well coded."

Agree with this comment but please realize that many of the system stored procedures are identical to those from in the 1993 Sybase version and probably are from earlier versions. A lot has changed in the area of RDBMSs in the last 15 years.

SQL = Scarcely Qualifies as a Language
edward_jeba
edward_jeba
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 149
I agree with Steve, especially when he talks about the MS Team and said they are like us. They too are humans and they are into teams that work with a passion to build a world class product. In my personal use of MS products, I have found that whatever you need to do, they have already thought about it and included it somehow or given us a means to do it. When I code, I always have the user of my product in mind and IMHO MS teams do too. MS, Keep up the good work.Smile
Edward.
Andy Warren
Andy Warren
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: Moderators
Points: 9503 Visits: 2728
I'll rate this as one of your better posts. Sharing an epiphany is worth doing. How about going back and looking at other "features" to see if you see hidden value in some of them?

Most businesses at the mercy of sales/marketing. Not all bad, but could use a little improvement too. It takes a lot of work to get a seat at that table in order to make a difference, and the process of getting there doesn't have much to do with coding ability - so not many of us try.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Stephanie Giovannini
Stephanie Giovannini
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1455 Visits: 1538
I am feeling very charitable toward SQL Server right now. It's a great product!

Yesterday, I had to assist another developer in writing queries for MS Access, interpreting its useless error messages, figuring out that "statement must be updateable query" meant that it didn't allow any subqueries in an update statement, and, to top it all off, practicing the black magic of placing enough parentheses in the FROM clause so it wouldn't scream syntax error.

When you think about how bad it could be... SQL Server is a great product!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: Administrators
Points: 52224 Visits: 19006
The hard part about seeing value in features is having a place where they can be used. This is where I think the developers and designers of SQL Server need to come up with, and publish, lots of use cases and examples of where things can be used.

Not that you have to have 14 cases to build the feature, but the more ideas you can publish, or that others can share, the more people will see value (or see them as not needed if you publish failures).

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
Matt Miller (4)
Matt Miller (4)
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: 10473 Visits: 18487
Stephanie Giovannini (5/20/2008)
I am feeling very charitable toward SQL Server right now. It's a great product!

Yesterday, I had to assist another developer in writing queries for MS Access, interpreting its useless error messages, figuring out that "statement must be updateable query" meant that it didn't allow any subqueries in an update statement, and, to top it all off, practicing the black magic of placing enough parentheses in the FROM clause so it wouldn't scream syntax error.

When you think about how bad it could be... SQL Server is a great product!


If you're down on MS Access, you should try a REAL "winner".... Say - Lotus ApproachSmile You'll be begging for the computing power, and ease of use of MSAccess in, oh - 2 hours (including the installation time)....

But I agree - I think SQL Server is very well put together all in all. Sure, there are some rather "interesting" choices that make us all jump through hoops, but that's what we have to do to earn our keep on a daily basis...

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
sgriffin-681047
sgriffin-681047
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 57
Hey Steve, I didn't know you knew Jesus.

Praise be to our Lord and Savior!

God bless you brother! Wink
timothyawiseman
timothyawiseman
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: 1046 Visits: 920
I concur that overall SQL Server is an excellent tool and one that is a large part of how I make my living, and I am glad to know passionate people are working hard to improve it.

It would still be nice to see more of the normal best practices followed within SQL Server itself though.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
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