Blogs

Nov. 18, 2011

The SQL Server 2012 Special Ops Tour: Get Recognized for Your SQL Server Solutions

The SQL Server 2012 Special Ops Tour could come to your city and you could be featured at an event....More
Jul. 31, 2012

What would the world look like if businesses led a purpose driven life rather than focusing solely on shareholder value?

Many books exhort you to live a purpose driven life. But the notion of trying to lead a purpose driven business is rarely discussed outside faith based organizations. In fact, companies, along with officers and directors of the company, are often sued for doing anything other than worrying about maximizing shareholder value. Scot’s....More
May. 21, 2013

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
Oct. 2, 2011

Denali T-SQL at a Glance: New and Enhanced Functions

Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
Nov. 16, 2012

Notes FROM PASS 2012

At this past PASS Summit in Seattle I got a chance to sit down with PASS President Bill Graziano and Executive Vice President of Finance Douglas McDowell to talk about this year’s PASS Summit and the future directions for the PASS organization. Bill said that this year’s PASS Summit was the best attended Summit ever with 3,894 delegates....More
May. 8, 2013

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors....More
Jul. 27, 2012

Is the recovery interval guaranteed?

The recovery interval is not guaranteed in any way—it’s simply a goal....More
Oct. 31, 2011

Is SQL University's professional development week as cool as Shark Week?

I’m honored to be part of the the SQL University community project this week. Mike Walsh and I will be exploring topics related to professional development. Of course, my entire L.E.A.P. blog is focused on this topic in various ways so the SQL University theme isn’t too much of a stretch for me. I’m pretty sure that the fall 2011....More
May. 6, 2013

Cheaters Never Win, Even in TPC Benchmarks

In this portion of the series on database benchmarking, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING....More
Nov. 26, 2012

Can LUNs Be Extended Online Under VMware and Hyper-V?

There's no reason whatsoever to take any sort of outage when expanding a LUN either in a virtual or physical environment. Here's the process, explaining exactly what needs to be done to expand a LUN....More