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 […]

Written by Sérgio Fonseca16/01/201316/01/2013

TRUNCATE TABLE GERA LOG #FicaDica :)

Desculpem ter deixado o titulo em maiúsculo, se desse ainda faria em NEGRITO. Na empresa que trabalho sou responsável por entrevistar os candidatos. E 9 a cada 10 DBAs me falam que TRUNCATE TABLE não gera log, que não dá para fazer ROLLBACK Mas é CLARO que o SQL salva log, e se der algum problema […]

Written by Sérgio Fonseca16/01/201316/01/2013

Time dimension tunning

Hoje fiz um tunning legal e gostaria de compartilhar com vocês. Para preencher uma dimensão data, acredito que não existe muito segredo, basta fazer um loop pelas datas e inserir na tabela, mas e se você precise inserir em nível de minuto ou até segundo, pode acabar ficando lento pela inserção linha a linha Segue […]

Written by Sérgio Fonseca30/12/2012

Os números de 2012 – Não foi muito bom, culpa minha

Os duendes de estatísticas do WordPress.com prepararam um relatório para o ano de 2012 deste blog. Aqui está um resumo: 600 pessoas chegaram ao topo do Monte Everest em 2012. Este blog tem cerca de 3.400 visualizações em 2012. Se cada pessoa que chegou ao topo do Monte Everest visitasse este blog, levaria 6 anos […]

Sergio Fonseca Blog

Just a SQL Server Blog and everything around that