T-SQL Tuesday #051: Bets and Results

The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17...

T-SQL Tuesday #051: Bets and Results

The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been...

Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out. In scenarios...

Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby...

Windows 2012 for the SQL DBA: .NET 3.5 Fails to Install

Hello Dear Reader!  I know it has been a while since last we spoke.  Sorry for the long absence.  I've...

Configure Kerberos for SQL with Virtual Accounts

At a conference recently I had someone ask how they would configure Kerberos for accounts that look like “NT Service\MSSQLServer”...

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

Data Scientist versus Data Engineer #datascience #bigdata #analytics

One of the main differences between a data scientist and a data engineer has to do with ETL versus DAD:
ETL...

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

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