Databases

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...

NoSQL databases introduction and dominant features. A historical perspective to their appearance in a world dominated by relational model databases.

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...

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...

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...

For building recursive queries In SQL Server 2005 we have to use a new functionality called Common Table Expressions. Let's see how we can retrieve all the employees that...

I had to recreate a table in SQL Server just because it was created with ANSI_NULLS ON Here you can check the requirements to create a persisted  computed column on...

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...

Os webcasts da MS são das formas mais interessantes de ter overviews rápidos de determinada tecnologia ou tema. De entre os webcasts dos próximos dias, seleccionei os seguintes, que...

LAG - http://msdn.microsoft.com/en-us/library/hh231256.aspx USE AdventureWorks2012; GO SELECT BusinessEntityID, YEAR(QuotaDate) AS SalesYear, SalesQuota AS CurrentQuota, LAG(SalesQuota, 1,0) OVER (ORDER BY YEAR(QuotaDate)) AS PreviousQuota FROM Sales.SalesPersonQuotaHistory WHERE BusinessEntityID = 275...