How SQL Clone and SQL Change Automation enable seamless Database Branch Switching
Learn how to use SQL Clone together with Git hooks and SQL Change Automation to branch your database in Git as quickly and simply as your code.
Learn how to use SQL Clone together with Git hooks and SQL Change Automation to branch your database in Git as quickly and simply as your code.
If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your results over time. Sure, it’s going to look predictable at first, but down the road, as things change – the indexes, the table, the server’s configuration, the size of your data – you can end up with some ugly surprises.
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
Steve notes we all need to learn to communicate and share information better, especially while we are remote.
A flexible approach to Database DevOps where the team maintain the current state of the database in version control, during development, and then at key stages generate and test the migrations script that will deploy the changes to the target database, safely.
We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.
Many of us have used PowerPoint, which has grown smarter through the use of Machine Learning.
In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described. Its biggest selling points include nearly full compatibility with on-premises SQL Server deployments, support for SQL Server Agent, and additional security associated with its Azure virtual network integration.
The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line....
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
By Rob Sewell
Getting clients is tough. Here's actionable advice to make building business easier.
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers