SharePoint Tunning Session
Last week I delivered a session at SharePoint Portuguese Community 36th event.
My session was entitled SharePoint Tunning, focused on techniques used to improve the performance of a SharePoint farm. The main topics of the...
NoSQL First Act – a historical introduction
NoSQL databases introduction and dominant features. A historical perspective to their appearance in a world dominated by relational model databases.
Entity Framework – Update Database using Azure Pipelines
Introduction
The pipelines bring to us the opportunity to create automatic tasks to execute development operations, like deploys, migrations, tests, etc. Focused in the deploy routine, some applications need other...
Provision a database programmatically in Azure SQL database with a failover group
This post will explain how to provision a database programmatically in a Azure SQL database and add it to an Azure SQL failover group.
Introduction
An Azure SQL Server failover group...
Full-Text Search: Actualizar múltiplos cátalogos de pesquisa
Introdução
O Sql Server possui um mecanismo de pesquisa de texto com base na indexação de colunas de tabelas numa base de dados chamado Full-Text Search. Este mecanismo de pesquisa...
Converting a Vertical Table to an Horizontal Table in SQL Server
Today I've encountered a vertical table in an SQL Database and I wanted to transform it to an horizontal one. A vertical table is described as an EAV model.
Imagine...
Query performance for JSON objects inside SQL Server using JSON_VALUE function
Following up on this article about querying JSON Data I would like to talk about how to improve searches on JSON data inside SQL Server. Starting SQL Server 2016...
Strange behavior with “Merge Join” in SSIS
If the datasources of the Merge Join block in SSIS aren't sorted the merge will not work correctly.
Strange behavior will occur if the datasources aren't sorted equal by the...
Enterprise Library: Criar ligação à base de dados de forma dinâmica
Já alguma vez precisaram, usando o Enterprise Library, de estabelecer uma ligação com um número de base de dados variável e em que a base de dados a ligar...
.NET EF Core 6 support for groupby top(n) queries
EF Core 6 comes with some GroupBy queries improvements. In this post I wanna talk about the improvements related to "group by top(n)" queries.
Let's say we have the following...