Three Days and a Notebook
Steve Jones is off to Seattle for the rest of the week attending Microsoft Build 2017.
Basic data masking for development work using SQL Clone and SQL Data Generator
This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.
Deploying Multiple SSIS Projects via PowerShell
When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).
Azure Machine Learning - Your first experiment
In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.
Dude, where’s my database? Inventory management by Foundry
Have trouble keeping track of your SQLServer estate? Redgate Foundry are currently researching the area - here's what they've been up to, and how you might be able to help.
Exploring Azure Storage for SQL Server DBAs – Part 2
Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal with the Storage Account. It is now easier to add new disks to a virtual machine, either in PowerShell or via the portal. The Storage Spaces feature in Windows Server can be used to aggregate disks together and obtain higher levels of performance. Joshua Feierman explains how to do it all.
How to Move a Table to a Different File Group
There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.
SQL Server Join Example
What are all of the JOIN options in SQL Server? What is the significance of each of the options? How does the syntax work? Jeremy Kadlec answers these questions and more.
Build Dynamic Backup Locations with Minion Backup
See how Minionware Backup gives you the ability to customize backup files and locations.
Blogs
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...
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or...
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