Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
Steve sees that poor database design is the reality of the world and we have to work around that.
In part 2 of this series, I showed an example implementation of distributing a long-running workload in parallel, in order to finish faster. In reality, though, this involves more than just restoring databases. And I have significant skew to deal with: one database that is many times larger than all the rest and has a higher growth rate.
Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.
What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.
A new cohort of WITspiration is strating, the women in technology mentoring circle.
This article shows how to access Snowflake information from Synapse Analytics.
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers