Articles

Making the switch to SQL Monitor

Australia and New Zealand’s leading cloud account software provider Xero needed a cost-effective monitoring solution with better features and coverage. Read Xero’s story about how they switched from their old monitoring tool to Redgate’s SQL Monitor.

2019-11-26

Verify your SQL Server database backups

Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]

4.33 (3)

2019-11-22

5,083 reads

Recover SQL Server Resource Database

SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.

2019-11-22

How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans

Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.

2019-11-21

Blogs

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

Read the latest Blogs

Forums

Impact value about missing indexes

By msimone

is there relation between Impact from sys.dm_db_missing_index_group_stats and Impact from cache plan? Thanks for...

Migrating DB encrypted by master key

By CharlieRL

I'm migrating DBs from a 2008 R2 instance onto a 2017 instance.  I have...

SQL Monitoring

By SQLEYES

Hi All, I have SQL 2012 instance on a vm server  which I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers