The Connection to the Primary Replica is not Active
In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.
Do you want the chance to win Redgate goodies and books?
Visit the Redgate Forums today to enter the competition to win a Redgate goodie bag including a copy of Grant Fritchey’s SQL Server Executions Plans (Third Edition), plus your choice of the classic novel about DevOps, The Phoenix Project, or the follow-up book, The Unicorn Project.
Power BI Advanced Q&A
What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?
Export/Import Data using BCP - SQL Server on Linux
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
Cloning all the Databases on a Server
Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.
SQL Server Attach and Detach Database Examples
In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.
Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database
In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
Why A Query May be Faster the Second Time it Runs
Today, Kendra Little explains why a query may run faster the second time you run it.
Removing the Square Bracket Decorations with SQL Prompt
If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers