Written by Sergio Fonseca05/05/201906/05/2019

Lesson Learned #2 Linked Server from SQL 2008 R2 to Azure SQL Managed Instance

You should know by now that the SQL 2008 and 2008 R2 is at end of support on 2019-07-09 and mainstream support also ended a long time ago https://www.microsoft.com/en-us/sql-server/sql-server-2008 https://support.microsoft.com/en-us/lifecycle/search?alpha=SQL%202008 The best path to do this migration would be to use DMA (Data Migration Assistant) and DMS (Azure Database Migration Service), however in some scenario […]

Written by Sergio Fonseca15/04/2019

Lesson Learned #1 Column Store compressed rowgroups (Clustered vs NonClustered)

I worked on a case recently and I would like to share this information When loading data in Columnstore index using Bulk loading there are some differences between Clustered Columstore index and Non Clustered Columnstore index Looking on documentation, it says that every some thousands it will create compressed row group the rest will be […]

Written by Sergio Fonseca31/03/2019

Azure SQL DB and Log Analytics better together – Part #2 – Alerts

As you could see on previous post (AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1) using Azure SQL DB + Log Analytics is quite easy. Let see how can we improve even further with ALERTS

Written by Sergio Fonseca30/03/2019

Azure SQL DB and Log Analytics better together – Part #1

As a DBA you may want to query SQL Audit and SQL Diagnostics information. The easiest way to do this is sending to Log analytics that is part of Azure Monitor You can also send this data to Event Hubs and storage accounts. On this post I will focus on Log Analytics

Written by Sergio Fonseca27/03/201931/03/2019

Change collation of existing Azure SQL database

Another article I wrote to Azure SQL DB Support blog https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/11/09/change-collation-of-existing-azure-sql-database/ There is no easy way at this moment to change an existing database collation. The workaround is to modify manually the BACPAC file

Written by Sergio Fonseca27/03/201903/04/2019

How to get Azure SQL database size

This is a copy of original post I wrote to Azure SQL DB Support blog. Also updated with some news in Azure Metrics https://blogs.msdn.microsoft.com/azuresqldbsupport/2019/02/08/how-to-get-azure-sql-database-size/ There are multiple ways to achieve this and there are also some storage types you should be aware

Written by Sergio Fonseca26/03/201927/03/2019

Incremental statistics… How to Update Statistics on 100TB Database

I’ve recovered this post using (Google cache) from a post I made a long time ago from retired blog of brasilian SQL PFEs https://blogs.msdn.microsoft.com/pfebrasilsql/2016/03/18/estatisticas-incrementais-ou-como-atualizar-estatisticas-em-base-de-100tb-vldb/ And the english version also retired, translated by (Chris Lound / Alexandre Mendeiros) https://blogs.technet.microsoft.com/dataplatform/2016/04/03/incremental-statistics-how-to-update-statistics-on-100tb-database/ Find below this article I really like the idea of Incremental Statistics and what it can offer […]

Sergio Fonseca Blog

Just a SQL Server Blog and everything around that

Author: Sergio Fonseca