Articles

Technical Article

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

5 (1)

You rated this post out of 5. Change rating

2020-12-09 (first published: )

54,472 reads

External Article

Take the 2021 State of Database DevOps survey

It's your last chance to take part in the 2021 State of Database DevOps survey! If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund. Take the survey here.

2020-12-09

SQLServerCentral Article

Boost performance of your SQL Server tables with a TURBO button

Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let's talk about HEAP tables, aka tables with no clustered indexes that […]

2.13 (8)

You rated this post out of 5. Change rating

2020-12-08

7,204 reads

SQLServerCentral Article

Steps for Installing AlwaysOn Availability Groups - SQL 2019

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]

4.5 (2)

You rated this post out of 5. Change rating

2020-12-07

140,971 reads

Blogs

The Book of Redgate–Being Reasonable

By

As a part of the Book of Redgate, we have a series of (red,...

Azure Data Factory Pipeline Debugging Fails with BadRequest

By

I recently had a new pipeline fail. It was actually a copy of an...

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

By

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Read the latest Blogs

Forums

Sever Migration

By Arjun SreeVastsva

Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...

Changing Machine Type

By Arjun SreeVastsva

Hi, presently my azure server running under Standard_D64ds_v4 .i am planning to upgrade the...

Rolling Back CUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Rolling Back CUs

Visit the forum

Question of the Day

Rolling Back CUs

Can I rollback a cumulative update and remove it from my SQL Server instance?

See possible answers