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.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers