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.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Comments posted to this topic are about the item URL Safe or Not?
Comments posted to this topic are about the item No Defaults Passwords Ever
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers