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.

Thinking Time

Taking time away from life and just thinking is important.

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.

Byte Me: Entrepreneurial

Why is my clone so small?

Using very few megabytes and taking very little time, SQL Clone can quickly creates multiple copies of very large databases. How? It might sound like magic, but it's not; in this blog post Redgate developer Chris Hurley goes into the details of how the technology works.