Posted by Barac in SQL Server, SQL Tips and Tricks
on Mar 12th, 2022 | 0 comments
What is the SCHEMABINDING within VIEW?It simple binds the view to the schema of the underlying objects. Tables behind the View cannot be altered in any way which could affect view definition. You can find more at this MS article: ALTER VIEW (Transact-SQL) There is a easy way to remove SCHEMABINDING, you just need ALTER VIEW statement. But what if you have 100 views that needs to be altered? Well there are no SWITCH OFF button for SCHEMABINDING in SQL Server. I had same situation and I wrote this simple script which will generate ALTER VIEW...
Posted by Barac in SQL Server
on Jan 27th, 2022 | 0 comments
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 5th running on the 14th of May 2022. 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...
Posted by Barac in SQL Server
on Oct 23rd, 2021 | 0 comments
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,...
Posted by Barac in Azure, DATASATURDAY, SQL Server, SQLSATURDAY
on Oct 12th, 2021 | 0 comments
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...
Posted by Barac in Azure, SQL Server
on Sep 2nd, 2021 | 0 comments
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...
Posted by Barac in SQL Server
on May 7th, 2021 | 2 comments
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,...
Posted by Barac in SQL Monitoring, SQL Server, SQL Tips and Tricks
on Apr 10th, 2021 | 0 comments
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...
Posted by Barac in Azure, Powershell, SQL Server
on Mar 6th, 2021 | 0 comments
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...
Posted by Barac in SQL Server, SQLSATURDAY
on Jul 15th, 2020 | 0 comments
VIRTUAL EVENT PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Auckland is back for 2020. They are going virtual in 2020. Due to the Covid-19 global impact they are still hosting the event, but it will be 100% virtual to keep all the attendees and speakers safe. Time and Date: Saturday, August 8, 2020 Add to Calendar More information:...
Posted by Barac in SQL Server
on Jun 9th, 2020 | 0 comments
I was working with a customer having DB with more than 100K HEAP tables. Number of Forwarded Records on some tables were huge. They are using Ola Hallengren‘s scripts to maintain non-clustered indexes on those tables, but rebuilding those indexes do not fix the forwarded records on those HEAP tables. You actually need to rebuild the HEAP ALTER TABLE TableName REBUILD; Or to add a clustered index to the table (permanent fix). They are in the middle of the remodeling their DB so adding clustered indexes on those HEAP tables was not an option....