content linked to SQL

Custom Job scheduling, Remote queries, and avoiding false negatives using PowerShell and SQL Agent

In-Memory logging and log "compression"

Manipulating SQL Agent Jobs through PowerShell

Loading and using SQL Server Management Objects in PowerShell

Using conditional COUNT(*)s

Bitesize SSIS - Compressing files from the SSIS Script Task

Bitesize SSIS - Deploying the SSIS Catalog

Transaction Log, Delayed Durability, and considerations for its use with In-Memory OLTP – Part I

Problem removing files from TempDB

Incrementing SQL Sequences

Restoring CDC enabled databases

Bitesize SSIS - Passing SSIS variables into script components

Messy Meta-Described Views

ROLLBACK damn you!

Why don’t you go and LOCK OFF!

How to run SQL Server 2012 on the Kindle Fire HD

Baby baby baby, where did our ROLLBACK go?

The Curious Case of the Non-Escalating transaction locks

Using the SQL Server Installation Wizard on Server Core!

Remember your OS when upgrading to SQL 2012

whoisactive on SQL 2000

Weight doesnt ALWAYS have to be AlwaysOn

What are the impersonation rights for my database users?

Keep your Availability Group listener name short

Lock Compatibility Matrix 1.2

Fancy a decent Compatibility Matrix?

When should you use NOLOCK?

Review of Inside the SQL Server Query Optimizer

Database corruption - Your mistake, my problem!

Using SQL Server Scalable Shared Database

How to run SQL Server on Linux

Categorise your SQL Agent jobs

Automating your SQL snapshots

Where to go for WAIT stat information