Some Thoughts About Microsoft’s Cloud Platform Roadmap

There have been a lot of changes in and around Microsoft in the past few months.  Under the leadership of...

Consolidating time series metadata for users in Tabular

Background
DAX offers many powerful time intelligence functions that can be applied at virtually any level of a date / time hierarchy....

Microsoft product roadmap now public

Ever wonder about Microsoft’s product roadmap?  With Microsoft rapidly releases products and services, they realized the need to provide better...

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...