This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions.
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
Learn about the Schema Compare feature in Azure Data Studio.
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
More and more organizations are turning to DevOps to improve the efficiency and quality of software delivery, and increase value to their business. But what exactly is DevOps and what does it mean for you and your organization?
Years ago I worked at a large company, and we purchased a SAN appliance to consolidate our storage. This was at a time when the majority of our servers used locally attached storage. This was a big purchase, and we knew that we had to plan for issues. So, we actually purchased two appliances and […]
Steve wants you to manage your career and actively find the job that is best for you.
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
In case you missed it: IDC’s recent Global DataSphere Forecast, 2021-2025, predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it?
In this article we present complex built-in data types in Python along with several examples of how to use complex data types.
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers