Database Mirroring is Back in Azure SQL Database
Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.
The Journey to Change
Many of us have a journey, either to SQL Server, or in today's world of many databases, perhaps away from SQL Server. Steve looks at his, and another's, journies.
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each SPID calc the execution plan, one after the other after waiting for the prior SPID to finish?
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]
A First Look at SSMS 20
Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]
Managing Files and Folders with Python – Data Engineering with Fabric
In this article, learn how you can manage files and folders for both full and incremental loading situations.
The Cloud Database Cost Analysis
Managing costs in the cloud is something many companies are concerned about. Today Steve thinks that technical people will bear more responsibility for this in the future.
What is Eventstream in Microsoft Fabric? - Part 1
Learn about Eventstream in Microsoft Fabric to ingest, transform, and route real-time data to certain destinations in a low-to-no-code SaaS fashion.
Another View of DevOps
Steve does a lot of work with teams trying to adopt DevOps, and today has another description of what this can mean for your team.
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers