Nice write-up.
Nice write-up. > This code has to be maintained, versioned, etc. Specifically to a Microsoft stack this specific pain point is outright negated, in fact, Microsoft's answer (Visual Studio SQLPROJ/Data Dude) exposes migrations for the horrible metahistory hack that they are. SQL projects are stored in source control as though they were C++/C#/what-have-you. Just like the rest of our code, the 347kloc SQL portion is handled on by CI and the migration (as well as the creation) scripts are generated for us - based on the schema differences (that it determines for us) between our last release and the current release. So far as SQL Server goes, maintenance and versioning woes are an outright myth. More pros: 4. A policy of using SPROCs only is a good way to significantly reduce the risk of SQL-related vulnerabilities. If developers are required to justify why they are sending raw queries to SQL they will have a hard time introducing e.g. an injection vulnerability. 5. A lot of the overhead of query execution (parsing, resolving objects, etc.) is done when you CREATE or ALTER the procedure, this can results in a performance benefit (especially if the application is chatty). More cons: 5. Query plans for SPROCs are aggressively cached, in extremely rare circumstances this can play havoc with performance (direct contradiction of my own pro 5). 6. Triggers+family are invisible logic. They can cause confusion during debugging.
Posted by zamalek on May 4, 2015, 11:31 AM
Tags
Related issues
- Legit what one of our clients problem was.
- sounds painful, just searched on "how can i get ms office running in linux using wine" and the results included a containerised windows v...
- Appreciate MCP server availability, will help integrate with Claude.
- Maybe a different take, but as someone that manages a large public API that allows anonymous access, IPv6 has been a nightmare to try and...
- Why is there no write through unionfs in Linux?
- > why is there no in-memory kafka server that I can use for simple testing purposes https://github.com/embeddedkafka/...
Raise real-world problems, find people facing the same issue, and discuss solutions.7,000 issues0 comments
hackernews (Sysadmin)
Legit what one of our clients problem was.
sounds painful, just searched on "how can i get ms office running in linux using wine" and the results included a containerised windows v...
Appreciate MCP server availability, will help integrate with Claude.
Maybe a different take, but as someone that manages a large public API that allows anonymous access, IPv6 has been a nightmare to try and...
Why is there no write through unionfs in Linux?
> why is there no in-memory kafka server that I can use for simple testing purposes https://github.com/embeddedkafka/...
> why is there no in-memory kafka server that I can use for simple testing purposes.
I went from daily driving mac and being very used to the desktop environment, and i am really hating everything i've tried in Linux.
Nice write-up.
Nice write-up. > This code has to be maintained, versioned, etc. Specifically to a Microsoft stack this specific pain point is outright negated, in fact, Microsoft's answer (Visual Studio SQLPROJ/Data Dude) exposes migrations for the horrible metahistory hack that they are. SQL projects are stored in source control as though they were C++/C#/what-have-you. Just like the rest of our code, the 347kloc SQL portion is handled on by CI and the migration (as well as the creation) scripts are generated for us - based on the schema differences (that it determines for us) between our last release and the current release. So far as SQL Server goes, maintenance and versioning woes are an outright myth. More pros: 4. A policy of using SPROCs only is a good way to significantly reduce the risk of SQL-related vulnerabilities. If developers are required to justify why they are sending raw queries to SQL they will have a hard time introducing e.g. an injection vulnerability. 5. A lot of the overhead of query execution (parsing, resolving objects, etc.) is done when you CREATE or ALTER the procedure, this can results in a performance benefit (especially if the application is chatty). More cons: 5. Query plans for SPROCs are aggressively cached, in extremely rare circumstances this can play havoc with performance (direct contradiction of my own pro 5). 6. Triggers+family are invisible logic. They can cause confusion during debugging.
Comments (0)
No comments yet. Start the discussion.