#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

SQLSATURDAY 982 / Auckland, New Zealand / Virtual Event

Posted by in SQL Server, SQLSATURDAY on Jul 15th, 2020 | 0 comments
SQLSATURDAY 982 / Auckland, New Zealand / Virtual Event
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:...
read more

SQL Server / Forwarded Records / Rebuild the Heap Tables Script

Posted by in SQL Server on Jun 9th, 2020 | 0 comments
SQL Server / Forwarded Records / Rebuild the Heap Tables Script
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....
read more

SQLSATURDAY 986 / Brisbane, Australia / Virtual Event

Posted by in SQL Server, SQLSATURDAY on May 25th, 2020 | 0 comments
SQLSATURDAY 986 / Brisbane, Australia / Virtual Event
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 Brisbane 2020 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, May 30, 2020 Add to Calendar More information:...
read more

Auckland SQL User Group Meetup Event / Online Event / Kevin Kline, Microsoft MVP / 5 Critical Considerations When Moving to the Cloud

Posted by in SQL Server on May 14th, 2020 | 0 comments
Auckland SQL User Group Meetup Event / Online Event / Kevin Kline, Microsoft MVP / 5 Critical Considerations When Moving to the Cloud
ONLINE EVENT   Join Kevin Kline as he talks to the Auckland SQL User Group  TOPIC: “5 Critical Considerations When Moving to the Cloud.” 5 Critical Considerations When Moving to the Cloud Wednesday, May 20, 2020, 11:30 AM Online event , 36 database professionals Went Join Kevin Kline as he talks to the Auckland SQL User Group about “5 Critical Considerations When Moving to the Cloud.” **RSVP to get the Teams Live Event details** Migrating an existing on-premises SQL Server application to the cloud can be a daunting...
read more

SQL Server / BACPAC / Could not extract package from specified database – The wait operation timed out

Posted by in SQL Server, SQL Tips and Tricks on May 13th, 2020 | 0 comments
SQL Server / BACPAC / Could not extract package from specified database – The wait operation timed out
Export Data-tier Application. This is usually really simple and straight forward process. But what if you have database with over 100K tables, 200K indexes? You would probably end up with following timeout error during export process using SSMS To resolve this possible “Execution Timeout Expired” issue you may use SqlPackage.exe command-line utility to export your database including database schema and user data from SQL Server Database to a BACPAC package (.bacpac file)  More information about this command-line utility tool and...
read more

SQL Server / System Stored Procedures / Auto generated System Stored Procedures ‘dt_’

Posted by in SQL Server, SQL Tips and Tricks on Feb 26th, 2020 | 0 comments
SQL Server / System Stored Procedures / Auto generated System Stored Procedures ‘dt_’
Searching through my staging/test database and looking for ‘text’, ‘ntext’ data types I stumbled upon 31 system stored procedure starting with the prefix ‘dt_’.  I was mostly interested in two of them using text datatype as an input parameter. So what are those Stored Procedures? Using different Visual Tools against SQL Server, such as Enterprise Manager or design tools, will trigger auto generated code and create set of System Stored Procedures. Prefix ‘dt_’ stands for ‘DaVinci...
read more

SQL Server / PowerShell / Exporting data from a SQL Server table to multiple comma-separated value (CSV) files using PowerShell

Posted by in Powershell, SQL Server, SQL Tips and Tricks on Jan 28th, 2020 | 0 comments
SQL Server / PowerShell / Exporting data from a SQL Server table to multiple comma-separated value (CSV) files using PowerShell
Export SQL Data to multiple CSV files. There are many different ways to do this (SSIS, TSQL) but I think that PowerShell could be really efficient tool for such small random tasks. For this example I will use test table with 17220 rows. First step is to export whole table to CSV file using export-csv cmdlet.  Export-CSV converts objects into a series of comma-separated value (CSV) strings and saves the strings to a file. If you want to find more details about Export-CSV cmdlet and see more usage examples you can read this MS article. param (...
read more

« Previous Entries