Overview of Published Articles – 2015Q1

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

Padding Fields for Fixed-Position Data Formats

Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49

- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking

For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...

Exam Prep 70-463: Installing Master Data Services

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...

How to Configure E-mail in SQL Server Step by Step–TIP #96

 
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...

In Memory Optimized Table in SQL Server 2014

To increase performance of highly accessible tables, a new feature incorporated in Sql Server 2014 “In-Memory OLTP”.You can define a...

Moving SQL Server data between filegroups – Part 1 – Database Structures

Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...