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


Would You Choose SQL Server?


Would You Choose SQL Server?

Author
Message
Miles Neale
Miles Neale
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3100 Visits: 1694
Steve Jones - SSC Editor (8/19/2013)
Miles Neale (8/19/2013)
Hi Steve,

I was out last week and came late to the game but needed to add something. Not all apps are .net and not all databases are SQL Server. There is a class of web server that is low-end, highly visible, and moderately used. In this area we are finding that the growth of CMS systems like WordPress, Joomla, and Drupal is expanding quickly. These sites include a standard WAMP or LAMP stack running mssql as the database of choice and they are cheap and easy to use. Using the CMS the database is almost encapsulated from the developer as well as large component solutions are available.



You mean MySQL, not mssql, right? I know many systems like this use MySQL or PostgreSQL. I with they had an option to use SQL Server or a plug in data access layer. Conversely, it would be nice if some other software written on SQL Server worked with other platforms.


Typo, yes MySQL. Thank you!

I have wondered why there is not a SQL option or layer as well. Then the idea come that a SQL agnostic back-end still has to to insure that SQL injection is stopped in its tracks. If we write a SQL solution that uses parameter driven stored procedures, we limit the back-end to those databases that understand and will execute in kind. However it we write an ANSI SQL compliant data system using direct calls w/o Stored Procedures it would work across all ANSI compliant platforms but would be open to injection and other problems.

Have to give this a little more thought.

Not all gray hairs are Dinosaurs!
chrisn-585491
chrisn-585491
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2039 Visits: 2441
From Brent Ozar, the software license cost three times the hardware...

http://www.brentozar.com/archive/2013/08/load-testing-solid-state-drives-raid/

For our design, we ended up with:
•Dell PowerEdge R720 with 2 quad-core CPUs, 384GB memory – $10k
•16 Samsung 840 Pro 512GB SSDs – $8k
•Hardware total: under $20k
•SQL Server Enterprise Edition licensing for 8 cores – $56k

Kinda keeps things in perspective, doesn’t it? The hardware seems insanely overpowered until you look at how much licensing costs. At that point, why wouldn’t you buy this kind of hardware?

Gary Varga
Gary Varga
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17015 Visits: 6534
Miles Neale (8/19/2013)
Steve Jones - SSC Editor (8/19/2013)
Miles Neale (8/19/2013)
Hi Steve,

I was out last week and came late to the game but needed to add something. Not all apps are .net and not all databases are SQL Server. There is a class of web server that is low-end, highly visible, and moderately used. In this area we are finding that the growth of CMS systems like WordPress, Joomla, and Drupal is expanding quickly. These sites include a standard WAMP or LAMP stack running mssql as the database of choice and they are cheap and easy to use. Using the CMS the database is almost encapsulated from the developer as well as large component solutions are available.



You mean MySQL, not mssql, right? I know many systems like this use MySQL or PostgreSQL. I with they had an option to use SQL Server or a plug in data access layer. Conversely, it would be nice if some other software written on SQL Server worked with other platforms.


Typo, yes MySQL. Thank you!

I have wondered why there is not a SQL option or layer as well. Then the idea come that a SQL agnostic back-end still has to to insure that SQL injection is stopped in its tracks. If we write a SQL solution that uses parameter driven stored procedures, we limit the back-end to those databases that understand and will execute in kind. However it we write an ANSI SQL compliant data system using direct calls w/o Stored Procedures it would work across all ANSI compliant platforms but would be open to injection and other problems.

Have to give this a little more thought.



TBH I cannot remember the last time someone thought of writing SQL statements that were so SQL compliant that they were cross-RDBMS compatible. Most places I have worked develop a RDBMS specific data access layer but some do so whilst ensuring that it takes business entities or data transfer objects (i.e. database neutral types) so that the data access layer/tier can be replaced whilst the remaining parts of the application can remain. The same is true for the UI e.g. swapping ASP.NET MVC front end for a Java Server Pages implementation.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Miles Neale
Miles Neale
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3100 Visits: 1694
Gary Varga (8/22/2013)
[quote]
TBH I cannot remember the last time someone thought of writing SQL statements that were so SQL compliant that they were cross-RDBMS compatible. Most places I have worked develop a RDBMS specific data access layer but some do so whilst ensuring that it takes business entities or data transfer objects (i.e. database neutral types) so that the data access layer/tier can be replaced whilst the remaining parts of the application can remain. The same is true for the UI e.g. swapping ASP.NET MVC front end for a Java Server Pages implementation.


TBHA I cannot remember the last time I did either.

M.

Not all gray hairs are Dinosaurs!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)

Group: Administrators
Points: 66092 Visits: 19120
I think this is where some layer of data access makes sense. Make calls to package/procedures that can be rewritten in a host language. Or use a method in a set of classes that can be replaced when you move from SQL Server to Oracle to MySQL.

Not easy, but not too hard if you build the pattern into your development.

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
Miles Neale
Miles Neale
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3100 Visits: 1694
Steve Jones - SSC Editor (8/22/2013)
I think this is where some layer of data access makes sense. Make calls to package/procedures that can be rewritten in a host language. Or use a method in a set of classes that can be replaced when you move from SQL Server to Oracle to MySQL.

Not easy, but not too hard if you build the pattern into your development.


In writing the internal data layer for a web service a number of years back we took the approach to having one data tier. In the configuration of the service was an option for either Oracle or SQL Server. Then depending on the config setting we were able to execute the correct querybuilder and connection methods for the appropriate database. Worked well. As you say it took some design up front but it worked well.

Not all gray hairs are Dinosaurs!
Jim P.
Jim P.
SSC Eights!
SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)

Group: General Forum Members
Points: 953 Visits: 2215
Gary Varga (8/22/2013)

TBH I cannot remember the last time someone thought of writing SQL statements that were so SQL compliant that they were cross-RDBMS compatible. Most places I have worked develop a RDBMS specific data access layer but some do so whilst ensuring that it takes business entities or data transfer objects (i.e. database neutral types) so that the data access layer/tier can be replaced whilst the remaining parts of the application can remain. The same is true for the UI e.g. swapping ASP.NET MVC front end for a Java Server Pages implementation.


I took a PeopleSoft 7 (or maybe 8) training course on developing forms many moons ago.

PS had actually coded forms with both the Oracle and SQL Server SQL statements for all the DML statements. It read the config file and that told it which code to use.

You want to talk about bloatware...



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Jason-
Jason-
SSChasing Mays
SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)SSChasing Mays (627 reputation)

Group: General Forum Members
Points: 627 Visits: 506
SQLExpress is free of licensing fees. If I am in a position that my server performance needs to exceed that of SQLExpress.... Yeah, the 8K is more than justified. By keeping with SQL Server my code will port immediately to Standard, BI or Enterprise when that need arises.

The only way I'd deviate is if I had the need to exceed SQLExpress and didn't have the money.

-
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