With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.

Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

by Additional Articles

SQLPerformance.com

Performance Tuning

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

Backups Over Time

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about backups, and the challenges they present over time.

Automatic SSRS report output of all report parameter combinations

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.

Guess the RTM Build

by Steve Jones

SQLServerCentral.com

Editorial

Have some fun and guess which build will be released for SQL Server 2016.

Migrating an on premise SQL Server Database to Azure

by Arun Sirpal

SQLServerCentral.com

SQL Server

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.

Database Version Control

by Additional Articles

SimpleTalk

Version Control

By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.