2020-11-16
557 reads
2020-11-16
557 reads
2020-10-22
8,225 reads
2020-10-15
426 reads
2020-09-21 (first published: 2020-08-25)
2,328 reads
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,272 reads
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
2020-04-03
221 reads
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
2019-07-02
106,226 reads
In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.
2019-05-31
2018-11-15
698 reads
2018-07-16
695 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Hello, so I was reading on partitioning a large table, Which i successfully did,...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...