Debugging database mail issues in your SQL Server with T-SQL

Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...

Don't Rush When It Comes to Privacy Data

The Dataloss list sent the following article through yesterday afternoon:
 
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
 
This is concerning,...

Encryption Decryption Routine

In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...

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