Community-driven free Azure tips eBook
We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.
Monitoring Transactional Replication in SQL Server
If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in T-SQL as an agent job.
Our Race with Machines
A future world where the machines rule, as shown in films like Terminator and the Matrix, isn't what most people want. However the fears of machines taking over much of our world are very real. Steve Jones thinks it's not as bad as you might believe.
SQL Saturday #220 - Atlanta
Join us for a free day of SQL Server training and networking in Atlanta on May 18th.
Using Policy-Based Management to Check Number of SQL Server Data and Log Files
To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.
Deploying CLR Assemblies with T-SQL
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
Small Data
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
Managing Slowly Changing Dimension with Slow Changing Transformation in SSIS
The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.
Microsoft Research
Research in industry can help a company leap ahead of it's peers. Steve Jones thinks this is a good idea for many companies to engage in and highlights some of the great work being done at Microsoft Research.
The State of the Cloud
The state of cloud computing is confusing and unstable. Steve Jones has a few thoughts about the good and bad things in this industry.
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers