SQL style guide

Re:SQL style guide by mmphosis on Sunday October 09, 2016 @03:44PM (#12673011)

Or avoid expensive, uncooperative, proprietary SQL vendors. I'll keep pretending and stick with sqlite and PLSQL.

[ Parent | on HN ]

Re:SQL style guide by 6nf on Sunday October 09, 2016 @07:04PM (#12674050)

I don't know if you've ever worked with MS SQL Server in production but for us it's been the most amazing piece of technology in our stack for the past 15 years.

SQL Server is in the top 3 best things to be published by Microsoft ever. (The other 2 are probably Excel and Flight Simulator)

[ Parent | on HN ]

Re:SQL style guide by systems on Sunday October 09, 2016 @07:31PM (#12674152)

and SQL Server BI stack, is very solid and cost effective SSRS is really good SSIS is very acceptable (I mainly use to call SQL Tasks) and SSAS is really second to none

[ Parent | on HN ]

Re:SQL style guide by Pxtl on Sunday October 09, 2016 @10:41PM (#12674704)

SSRS still doesn't have support for msbuild, SSDT is a goddamned dumpster fire, and SSIS jobs have that hilariously over designed graphical programming language and are do frustratingly brittle that they are functionally single-use. And SSMS has the worst use of tabbed files I've ever seen.

There's a link to like about mssql, but a lot to hate too.

[ Parent | on HN ]

Re:SQL style guide by alistairbayley on Monday October 10, 2016 @12:10AM (#12674991)

What's so amazing about it, when compared to the other SQL DBMS's? (e.g. postgresql, oracle, sybase, db2, etc)

Especially as it's just a re-badged Sybase...

[ Parent | on HN ]

Re:SQL style guide by 6nf on Monday October 10, 2016 @12:31AM (#12675056)

You still think of MSSQL as 're-badged Sybase'?

You know that was literally DECADES ago right?

[ Parent | on HN ]