Azure SQL PaaS / Platform as a Service Azure SQL redundancy options / Local, Zone and GEO redundant availability

Posted by in SQL Server on Dec 11th, 2021 | 0 comments
Azure SQL PaaS / Platform as a Service Azure SQL redundancy options / Local, Zone and GEO redundant availability
This video covers the zone redundancy options available with Azure SQL. You’ll learn about zone redundancy for each service tier including Hyperscale. Agenda: Redundancy options Standard availability model Basic, Standard, and General Purpose service tier locally redundant availability General Purpose service tier zone redundant availability Premium availability model Premium and Business Critical service tier locally redundant availability Premium and Business Critical service tier zone redundant availability GEO redundant availability...
read more

#DataWeekender v4.2 / Virtual Event / 6th of November 2021

Posted by in SQL Server on Oct 23rd, 2021 | 0 comments
#DataWeekender v4.2 / Virtual Event / 6th of November 2021
VIRTUAL EVENT   #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 4th running on the 6th of November 2021. ​ Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL,...
read more

DATA SATURDAY #13 MINNESOTA / Virtual Event / One-day free virtual event

Posted by in Azure, DATASATURDAY, SQL Server, SQLSATURDAY on Oct 12th, 2021 | 0 comments
DATA SATURDAY #13 MINNESOTA / Virtual Event / One-day free virtual event
WHAT IS DATA SATURDAY #13 – MINNESOTA   Free virtual event for all data learners and professionals seeking to learn! Data Saturday Minnesota is training event for professionals who use the Microsoft data platform. Community speakers will offer sessions about cloud, analytics, database administration, business intelligence, AI and more. Don’t miss out on this FREE event!!! Sessions: Schedule Date and Location: Central Daylight Time (US), Saturday, 16th October, 8am – 7pm  NZ time, Sunday, 17th October 2021 and starts at 2am...
read more

DIFINITY CONFERENCE 2022 / Auckland, New Zealand / The largest Data and AI conference in New Zealand

Posted by in Azure, SQL Server on Sep 2nd, 2021 | 0 comments
DIFINITY CONFERENCE 2022 / Auckland, New Zealand / The largest Data and AI conference in New Zealand
WHAT IS DIFINITY CONFERENCE Microsoft AI, Data, and Power Platform Conference Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand focusing on Data Platform, AI, Business Intelligence, Business Applications, Power Platform, and Analytics. IT Decision Makers, Developers, Business Analysts, IT Professionals, BI Managers, BI Professionals, Database Administrators, Architects, Digital & Big Data business leaders, and Consultants will gather for two consecutive days of...
read more

#DataWeekender v3.1 / Virtual Event / 15th of May 2021

Posted by in SQL Server on May 7th, 2021 | 2 comments
#DataWeekender v3.1 / Virtual Event / 15th of May 2021
VIRTUAL EVENT   #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 3rd running on the 15th of May. ​ Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL, Logic Apps,...
read more

SQL Server / Availability Group / Readable Secondary Replica Delay / Parallel Redo Operations

Posted by in SQL Monitoring, SQL Server, SQL Tips and Tricks on Apr 10th, 2021 | 0 comments
SQL Server / Availability Group / Readable Secondary Replica Delay / Parallel Redo Operations
One of the most common issues with Availability Group and using readable secondary replica is with Parallel REDO operations. On your readable secondary replica, you will notice a few different types of waits commonly related to this, but in this article, I will cover just one of them PARALLEL_REDO_TRAN_TURN PARALLEL_REDO_TRAN_TURN This type of waits happens in readable secondary replica and it is caused by page splits or forwarded records on heap tables triggered by new inserts or updates on primary replica. There are few ways to fix this...
read more

Azure / PowerShell / Deploy Azure SQL database DR environment with integrated azure SQL Analytics Solution using PowerShell

Posted by in Azure, Powershell, SQL Server on Mar 6th, 2021 | 0 comments
Azure / PowerShell / Deploy Azure SQL database DR environment with integrated azure SQL Analytics Solution using PowerShell
Script Download: AZ_Module_Deploy_Azure_SQL_Database_DR_Environment_With_AzureSQL_Analytics_Solution_Blog-1Download Summary: Use PowerShell to create cloud DR environment using Azure SQL Databases (PaaS) with integrated azure SQL Analytics Solution and send Email Report with the connection string details. Description: Use PowerShell to deploy cloud service with Azure SQL Database (PaaS) with good resilience to outages (GEO Replications, Failover Groups) and with integrated azure SQL Analytics Solution. PowerShell: The script will include the...
read more