Recent Blog ArticlesMost RecentMost LikesAnnouncing new security and observability features in Azure Database for PostgreSQL Today we’re excited to announce new enterprise grade security features available in Azure Database for PostgreSQL – Flexible Server to give developers more control and peace of mind when develo...Retiring Azure Database for PostgreSQL Single Server in 2025 Migrate to Azure Database for PostgreSQL – Flexible Server before March 2025 Re: What is Flexible Server in Azure Database for PostgreSQL? Oliver - it should be in minutes. Essentially the time taken is to run the recovery. Assume the maintenance window chosen is low activity window, it should be couple of minutes Re: Change data capture in Postgres: How to use logical decoding and wal2json Brent - The idea of consumer is to ingest changes in the database in a neutral format like JSON. The Consumer can then send the data to any target.For example, in thisPGConf.EU presentationWebed...What is Flexible Server in Azure Database for PostgreSQL? A technical overview of the new Flexible Server option (now in Preview) in Azure Database for PostgreSQL. Clustered Columnstore Index: Massively Parallel Trickle InsertFirst published on MSDN on Jun 04, 2018 A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows.Columnstore Index: How do I find tables that can benefit from Clustered Columnstore IndexFirst published on MSDN on Jun 13, 2017 Most of us understand that clustered columnstore index can typically provide 10x data compression and can speed up query performance up to 100x.Columnstore Index – How to Estimate Compression SavingsFirst published on MSDN on Mar 22, 2017 SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedba...Columnstore Index Performance: SQL Server 2016 – Window Aggregates in BatchModeFirst published on MSDN on Jan 15, 2017 SQL product team has made significant improvements in columnstore indexfunctionality, supportability and performance during SQL Server 2016 based on the feedba...Columnstore Index Performance: SQL Server 2016 – String Predicate PushdownFirst published on MSDN on Jan 15, 2017 SQL product team has made significant improvements in columnstore indexfunctionality, supportability and performance during SQL Server 2016 based on the feedba...
MicrosoftMicrosoftMicrosoftMicrosoft
