Instances and Ports with PowerShell

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...

Optimizing the Modern Data Platform with SQL Server 2014

Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server...

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