Question : This is a follow-up to an earlier question. I have a SQL Server 2008 R2 Standard server, that […]
Tag: best-practices
Granting access to all tables for a user
Question : I’m new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, […]
When should I use a unique constraint instead of a unique index?
Question : When I want a column to have distinct values, I can either use a constraint create table t1( […]
Database modelling best practice question
Question : I am modelling a database for an application I am developing and I am in front of a […]
Is EXECUTE AS OWNER in msdb a security risk?
Question : I’ve been tasked with creating a system that allows non-privileged users to start and stop SQL Server Agent […]
Mongodb performance: compound query vs moving to other collection
Question : My application uses mongodb to store order information. At some point orders are sent after which I need […]
What’s a good use case for SELECT * in production code?
Question : Out of habit, I never use SELECT * in production code (I only use it with ad-hoc scrap […]
Should I use mysql_upgrade after mysqld_safe when upgrading MariaDB?
Question : I’m wanting to know the best practice to do a MariaDB upgrade on opensuse. I am getting this […]
How to encode a known date but unknown year?
Question : I am using a Postgres database, and have a table with a date-time field. For many records, we […]
How do I tactfully bring up database shortcomings? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]