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

User Contains Invalid Characters – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...