T-SQL UNION Set Operator

T-SQL UNION
Set operators allow you to combine data from two or more queries and return the results in a single...

Index Fragmentation in Azure SQL Database

Index Fragmentation in Azure SQL Database
FEBRUARY 4, 2015

Recently, I read the articles Stop Worrying About SQL Server Fragmentation and When Does Index Fragmentation Matter?, and that got me starting to...

Index Fragmentation in Azure SQL Database

Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...

Excel BI Tip #19: Using the TEXT Function

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Storage Benchmarking with SQLIO Batch

The goal of the storage performance analysis is to identify the performance characteristics of a target storage device. To determine...

Get Out There and Challenge Yourself

It’s been almost five months since I posted my last article, and so much has changed since then. I have...

TSQL Tuesday #63 – How do you manage security?

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...

POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!

UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...

The most recent backup problem

When I first began this blog, back at the beginning of my DBA career, it was purely a place for...

Parsing SQL Saturday Data – Getting the Titles

I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...