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

SQL Server & Containers – Part Four

In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of...

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...

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

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

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

Column and table constraints

Column and Table Constraints
Constraints can be column constraints or table constraints.A column constraint is specified as part of a column...

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

Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes...