Memory-Optimized Table Filegroups

Attaching All Databases with PowerShell–Finding My MDF Files

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Laptop Dreams

For the Memorial Day holiday, Steve Jones is thinking about the new Surface 3.

A Little Learning with Pluralsight

I’ve been working on a new presentation on testing using the tSQLt framework and was curious how other people are...

Temp table limitations

One Final Patch

Vote for final service packs for SQL Server 2008 and R2. Let Microsoft know that we want regular support across the entire lifecycle.

Log Files

Balancing Learning

How do you determine when you use a new technique or stick with a tried and true method? Steve Jones notes that we try to teach you new things at SQLServerCentral, but do you use them?

Quick Tips – SQL Prompt Stop the Yelling

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...

Attaching All Databases with PowerShell – The Overview

TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to...