PolyBase explained

PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop.  It is designed to...

Hilux – @BBC #TopGear

May drives a modified Hilux to the rim of that unspellable Icelandic volcano that subsequently shut down Europe’s airspace
via Search...

The CASE Statement and Performance

In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...

Dealing with the mysterious “True” column in BIML

Recently I ran into the following error when compiling BIML into SSIS packages:

The message itself is not very revealing:
The data...

Virtual Teams: 3 Ways to Improve Efficiency and Performance #virtual #teams

How to enhance the performance of virtual teams
Virtual teams have some advantages, from allowing the best talent recruitment regardless of...

Create Database Error "operating system error 112(There is not enough space on the disk.)"

I try to create database by generating script of another database, which was a huge Database. When I run the script below

USE [master]

GO

CREATE DATABASE [YourDB] ON  PRIMARY

( NAME...

Improving SQL Server Performance by using Instant File Initialization

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...

Why Sales Organizations Fail

Companies face specific challenges at each stage of their lives. This is a great article on why many sales organizations...

How to check for last SQL Server backup

As a database professional, I get asked to review the health of database environments very often. When I perform these...

THE IIF statement – SQL has it at last.

TweetG’day All,
While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came...