Lorenz system

by ⋅ Leave a Comment

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /homepages/28/d448670958/htdocs/wp-content/plugins/latex/latex.php on line 47

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /homepages/28/d448670958/htdocs/wp-content/plugins/latex/latex.php on line 48

The Lorenz system is a system of ordinary differential equations first studied by Edward Lorenz. It is notable for having chaotic solutions for certain parameter values and initial conditions. In particular, the Lorenz attractor is a set of chaotic solutions of the Lorenz system. In popular media the 'butterfly effect' stems from the real-world implications … Read More →

Analysez les risques de votre projet

by ⋅ Leave a Comment

Analysez les risques dès le début du projet
Un projet se déroule généralement en 5 étapes :

La formalisation du besoin.

L’étude de faisabilité.

La conception.

La réalisation.

La finalisation.

1. La formalisation du besoin
C’est le moment où vous posez les bases de votre projet. Pour les gros projets, vous pourrez être amené à réaliser une étude d’opportunité mais le plus souvent pour … Read More →

Stairways

by ⋅ Leave a Comment

Stairways
To keep up to date with all the technologies in SQL Server, the DBA or developer who wants to stay ahead is faced with the struggle of constant learning.
The SQL Server Stairways is our solution to this problem. Designed to smooth out even the steepest learning curve, each Stairway is a SQL tutorial series focused … Read More →

From SQL to DAX - Joining Tables

by ⋅ Leave a Comment

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables
The SQL language offers the following types of JOIN:

INNER JOIN
OUTER JOIN
CROSS JOIN

The result of a JOIN does not depends on the presence of a relationship in the data model. You can use any column of a table in a JOIN condition.
In DAX there are two ways you can obtain a JOIN behavior. First, you can … Read More →

Unit Testing with SQL Server

by ⋅ Leave a Comment

Introduction
In this article (Italian), we have already discussed Continuous Integration and DLM. We described the main reasons for putting a database under source control and for testing our databases. In this article, we are going to discuss a real scenario of SQL Server unit testing with the tSQLt framework.
What Is Unit Testing
In computer programming, unit … Read More →

Automating Analysis Services Tabular Projects - Part 1: Deployment

by ⋅ Leave a Comment

Automating Analysis Services Tabular Projects - Part 1: Deployment
My team recently starting using Microsoft’s Tabular Model databases at work, as an intermediate layer between an operational data store and the end users who consume this data from Power BI. Tabular Models are an OLAP technology, providing an in-memory data cube, with measures being defined using … Read More →

Analysis Services Developer Documentation

by ⋅ Leave a Comment

In Analysis Services, almost every object and workload is programmable, and often there is more than one approach to choose from. Options include writing managed code, script, or using open standards like XMLA and MSOLAP if your solution requirements preclude using the .NET framework.
What you can accomplish in code
Typical programming scenarios include server and database … Read More →

Microsoft SSAS - Tabular modeling (1400 compatibility level)

by ⋅ Leave a Comment

https://docs.microsoft.com/fr-fr/sql/analysis-services/tutorial-tabular-1400/as-adventure-works-tutorial?view=sql-server-2017
What you learn

How to create a new tabular model project at the 1400 compatibility level in Visual Studio with SSDT.
How to import data from a relational database into a tabular model project workspace database.
How to create and manage relationships between tables in the model.
How to create calculated columns, measures, and Key Performance Indicators that help … Read More →