Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.

PowerBI premium capacity administration: dataset monitoring and tuning

by Additional Articles

SimpleTalk

Power BI

Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.

Using AI for the First Draft

by Steve Jones

SQLServerCentral

Artificial Intelligence (AI)

What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.

WITspiration - Year 2

by Additional Articles

SQLServerCentral

Community

A new cohort of WITspiration is strating, the women in technology mentoring circle.

Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide

by diponkar.paul

SQLServerCentral

Snowflake

This article shows how to access Snowflake information from Synapse Analytics.

DBCC CLONEDATABASE is Semi-Discontinued

by Steve Jones

SQLServerCentral

Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.

Who’s Changing the Table? Answers and Discussion

by Additional Articles

Brent Ozar Blog

Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.

On Being an "Expert"

by Grant Fritchey

SQLServerCentral

Uncategorized

I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]