Azure Data Factory CI/CD with GitHub and Azure PipelinesWithout source control for Azure Data Factory (ADF), you only have the option to publish your pipeline. And, it has to validate. Now with source control, we can save intermediate work, use branches, and publish when we are ready. The next step is CI/...Aug 19, 2024·6 min read
5 Databricks Performance Tips to Save Time and MoneyAs we process more and more data, performance is as critical as ever. The consumers of the data want it as soon as possible. And it seems like Ben Franklin had Cloud Computing in mind with this quote: Time is Money. — Ben Franklin Let’s look at fiv...Apr 29, 2024·5 min read
Manage Database Releases With Pre- and Post-Deployment ScriptsVisual Studio protects you and your data during deployments by making sure you do not delete data by accident. Such mishaps can be caused by shortening a column, dropping a column, and similar data operations. You can disable this. But I would only r...Apr 29, 2024·3 min read
Manage Cross-Database Development in Visual StudioWhen streamlining our database development process, we first must get our databases under source control. Often, the code accesses other databases on the server. Whether it is another in-house database or a vendor database, dependencies make version ...Apr 29, 2024·4 min read
How to Avoid these 10 Pitfalls during an Oracle to SQL Server MigrationMy first IT project was a data conversion for Fashion Bug. Since then, I have been on many conversions both as an in-house developer and as a consultant. The last few conversions have been moving Oracle Databases to SQL Server. Here are 10 pitfall mi...Apr 16, 2024·5 min read
Create Your First Visual Studio Database ProjectDatabases should be under source control and have the ability for CI/CD just like application code. Visual Studio gives you this capability. Here, we will show you how to get your databases into a Visual Studio Database Project. Download Visual Studi...Apr 12, 2021·4 min read
