Question : I’ve been tasked to prepare Azure SQL database deployment plan and I am struggling with it… I’ve been […]
Tag: deployment
Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2
Question : Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At […]
Problem with deployment of SQL Server Database on Azure DevOps
Question : We have problem with deploy database via Azure Devops from Database solution: 2022-01-26T09:10:26.6741963Z Unhandled Exception: System.NullReferenceException: Object reference […]
Web application for Software as a Service – Shared database or Multiple Databases?
Question : (I am not sure if this is the best place to post this question. If not, please redirect […]
Is there a way to give GRANT OPTION recursively for subsets of permissions?
Question : In SQL Server, I would like to create a role that has the ability to manipulate database objects […]
SQL User Permissions for Continuous Integration via DbUp and Octopus
Question : Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. […]
Howto create useful dacpac versioning along with SSDT deployment?
Question : It took me almost one day to go through lots of articles and blogs to realize check-in driven […]
Enable TDE When Publishing DACPAC
Question : In the database properties in Visual Studio there is a checkbox for encryption. I’m not sure if I […]
Replication Blocks Code Deployment
Question : We have a database (SQL Server 2008r2) that is being transactionally replicated, namely tables, sprocs, views, indexed views […]
Database upgrade script for removing columns
Question : So I have a SQL database project which tracks our application’s database schemas, stored procedures, etc. It also […]