This page shows the posts published with the category 'SQL'

Deploying a SQL Server Database with Data-Tier Application (dacpac)

The deployment of a database gives rise to several problems: What should the target database contain? How to update an existing database? Does the production base have the right schema? To answer this problem, there are several approaches: Manual management The user creates the specific scripts to create or update each database. Source of errors and waste of time… in short, it's not the recommended… [read more]

Comparing execution plans with SQL Server 2016

The CTP3 of SQL Server 2016 has just been announced. So it's time to take a look at the new features provided by this version. As we have seen in previous articles, the SQL Server engine has evolved and brings many new features. Today we will see that SQL Server Management Studio has not been left behind. Indeed a new feature requested for quite some time appeared: the comparison of execution plans. When… [read more]

SQL Geography, Google Maps & Geolocalisation

The geography type has appeared with SQL Server 2008R2. Its purpose is to store and manipulate spatial data. Basically it allows to represent points, lines or polygons on the globe and to make calculations such as measuring the type distances between 2 points, checking if 2 areas intersect, etc. We will make a web application to offer interesting places near the location of the user. These places are… [read more]

SQL Server - Discovering the HierarchyId data type

The hierarchyid type was introduced with SQL Server 2008. This type is used to represent and manipulate hierarchical data. Hierarchical data contain the notion of parent / child but also the notion of order between elements having the same parent. Values ​​of this type are actually stored in a binary form, for example 0x5AC0 or 0x58, but in practice we use character strings of the type '/' for the root or… [read more]