Find SQL Server Installation Date for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

Foreign Keys and Multi-Table Inserts in Oracle

Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.

The Basics of INCLUDE

Learn how the INCLUDE phrase of an index can change the performance of a query.

Handling Tricky Data Migrations during State-based Database Deployments

This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst preserving existing data.

SQL Server Management Studio is as Relevant as Ever

In this Simple Talk editorial Kendra Little discusses how SSMS is as relevant as ever.

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

Getting Started with SQL Server Azure Container Instances ACI

Learn how to quickly deploy a new SQL Server instance on Azure using Azure Container Instances ACI.

SQL Compare 14 now available on Linux

The latest version of SQL Compare now offers a Command Line Interface on Linux for the first time. Now teams can benefit from the industry standard tool for comparing and deploying SQL Server databases, whether they choose to work on Windows, Linux, or both.

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to

interesting discoveries and solutions.