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

Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....

Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....