ETL Error Handling

In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...

DBA Resolutions

It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...

Using Memory Optimized tables for reporting

I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...

Survey Results: Skipping the Holidays

Last week I posted a brief survey about working the holiday. To those who normally are not required to work...

Query Data Store–SQL Server 2016

SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to...

New Formatting in #SQLPrompt

I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...

A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...

Query Store- Part 5: Checking forced plans and Query Store Failures

Most of you would know that using query store one can force query plans. Is there a need to check...

Configure Internal and Private Networking for Hyper-V Virtual Machines

In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....

User Contains Invalid Characters – Back to Basics

While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
Related Posts:

Changing Default Logs Directory - Back...