Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Script to find the Fragmentation of indexes

Below is the script to find the fragmentation of the indexes created on a database.

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...

SSIS 2012 Design Patterns by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford

During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services...

Using Power BI to access on-premise data

The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on...

Execution Plans, Performance Tuning and Rum

This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...

IT Pro Airlift 2015 Portugal – Microsoft Data Platform

On 22 of January 2015, Microsoft Portugal is organising a new IT Pro Airlift 2015 – – Microsoft Data Platform event. This...

Looking back on 2014

When a new year comes around it is always a great time to reflect on the previous year.

2014 was a...

Things I Learned in 2014

2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...

T-SQL Tuesday #62 - Invitation to HealthySQL

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and
that 2015 will bring peace and...

Using an alternate TypeScript compiler inside Visual Studio

TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:

https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204

He...