Sometimes, I am in the frontline spitting blood in making the most out from SQL Server installations. Needless to say, one of the most important part is to to setup a good maintenance plan, tailored on every database workload and resources available. Since SQL Server and Azure SQL are two brothers – but far to... Continue Reading →
Custom SQL Server Triggers vs Dynamics 365 Business Central 2023 Wave 2 (v23) metadata changes
Hey you. Yes, you. You. That used to create custom triggers in SQL Server. Come closer… NO. MORE. First and foremost, we all need to respect cloud rules. And in da cloud no more access to backend to cheat with insert / update / delete / rename / whatever directly from SQL. No more Russian... Continue Reading →
