Recursive Queries in SQL Server 2005

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

Provision a database programmatically in Azure SQL database with a failover group

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

SharePoint Tunning Session

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

Reset Identity value

0
Today, i needed to reset the Identity value for one column in the SQL Server database. I used the following commando to view the current identity value: ...

Converting a Vertical Table to an Horizontal Table in SQL Server

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

SQL Persisted Computed Column ANSI_NULLS

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

Strange behavior with “Merge Join” in SSIS

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

Full-Text Search: Actualizar múltiplos cátalogos de pesquisa

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

Webcasts: SOA, WSE, Biztalk

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