What is 268435456?

Wandering Towards The Lonely Cloud?

Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.

SQL Server Cloud Migration Part I

A SQL Server migration with minimal business impact while synchronizing schema and data.

Using XML from data variable option in SSIS

Learn how you can manipulat XML documents solely in memory. No file required.

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

SQL Triggers in a Security Context

This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.

Documenting the Undocumented

Not everything in SQL Server is documented and Steve Jones doesn't think that everything should be. However some features are used often and should have additional documentation.

Session complete status and estimated completion time

A small retake on the popular percent complete script which tell how much more time an executing command will take.