2015-12-29 (first published: 2015-12-09)
1,919 reads
Know read and write ratio before you tune database performance
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,648 reads
2015-11-26 (first published: 2015-11-02)
1,268 reads
Figure out recovery mode for each database
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
622 reads
Who are connecting to database and disconnect ...
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,854 reads
Rebuild index selectively
Rebuild index is expensive most time. So you don't rebuild all index blindly.
2015-11-04 (first published: 2015-10-05)
1,761 reads
Blogs
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and...
Friend of Redgate 2020
By Chris Yates
Last week I was excited to receive an email from Redgate notifying me that...
Azure Database for PostgreSQL
By Arun Sirpal
Having worked with Azure SQL Database and its many flavours for couple of years...
Forums
Question on restoring a backup
Hi, I am not that knowledgable on backups and the files that they create,...
Regular Expression help - Does (.) Mean new line?
Hi there I am re-writing some code which uses regular expressions Part of...
SQL AG Secondary Database Backup Throwing "not supported" error with COPY_ONLY
Hello. I am using SQL Server 2016 with 2 Node AG. There is no...
Ask SSC