Monica Rathbun

Are My SQL Server Indexes Being Used?

Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...

2019-09-11 (first published: )

1,939 reads

Quick SSMS Tip

It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...

2019-09-11

76 reads

Comparing Execution Plans

When you run a query twice, and get dramatically different run times, your first step can be to try to identify the differences in execution plans. For many that...

2019-07-05 (first published: )

794 reads

Filtered Index Basics

In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...

2019-06-10 (first published: )

703 reads

DMV’s for the Beginner

I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...

2019-05-29 (first published: )

1,856 reads

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Seed AG Primary and Secondary with Log Shipping

By lmarkum

I am planning a SQL Server migration from 2008/08R2 up to SQL Server 2017...

SQL Server Restore precheck gets free space wrong

By BobAtDBS

I'm trying to move a large database (22 TB) from a stand alone server...

2nd Server min requirements for transaction log shipping & reducing license cost

By guht

I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers