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

2016-12-27

674 reads

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

by Kenneth Fisher

SQLStudies

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

2016-12-26

474 reads

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

by Nagaraj Venkatesan

SQL and SQL Only

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

2016-12-26

1,896 reads

Configure Internal and Private Networking for Hyper-V Virtual Machines

by Dharmendra Keshari

SQL Geek

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

2016-12-25

2,897 reads

User Contains Invalid Characters – Back to Basics

by Jason Brimhall

SQL RNNR

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

2016-12-24

249 reads

User Contains Invalid Characters – Back to Basics

by Jason Brimhall

SQL RNNR

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

2016-12-24

1,918 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

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

2016-12-23

5 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

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

2016-12-23

13 reads