SQL Server and hyperconvergence
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
One of the constant questions I get from Redgate customers is about rolling back database changes. We build software to help you deploy changes, but what about rollbacks? I think I've heard this in almost every conversation I've had on this topic in the last 5 years. It's one reason that Flyway has undo, though […]
In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]
This statement can be the biggest hurdle in changing software development and deployment processes. So, the question comes up pretty frequently: How do you overcome it? Grant Fritchey explores techniques to understand and coach others towards change.
Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.
This article helps to create a data flow in Azure Data Factory, add conditional split logic to the flow, and transfer data from a file to an Azure SQL Database.
July is starting, and with it we move to the second half of 2021, or H2 2021 for those of you that like the planning shorthand on roadmaps and project manager boards. The first half of 2021 has felt like a big of progress in the world, as we try to recover from the pandemic […]
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
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