SQL Clone
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 (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)

Group: Administrators
Points: 150896 Visits: 19455
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
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2541 Visits: 3064
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
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7120 Visits: 4352
"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-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 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
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: Moderators
Points: 26037 Visits: 2749
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
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2501 Visits: 1541
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 (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)

Group: Administrators
Points: 150896 Visits: 19455
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)
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30535 Visits: 19011
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
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2454 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