Geometry in the Cloud - where geospatial data meets the cloud.

Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...

Great Idea: Tribal SQL

Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...

Guide to SQL Server Table Indexes – (Part 4)

Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...

Introduction to Integrity: Chain Linkage Problems

We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...

Manage your SQL Server databases with SQL DMVs

Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....

Planning for Recovery

A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...

SQL 2014 SSMS is Killing my C:

I could hear SQL saying to my C: Drive "Why You Little...." Hello Dear Reader! 

The Blog about SQL Saturday 232 coming...

SQL Server – How to Add More Than One Column as a Primary Key

Sometimes you might want to add more than one column as primary key. For example, if you have three columns...

SQL Server Data Tools (SSDT) – August 2013 update

SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0,...

Understanding SQL Query Optimization – (Part 1)

Most of the activity of the database server is related to queries. Because of this, query optimization is often a...