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
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers