Kohera
22/02/2017
Azure SQL Database autotuning is not just a wizard
SQL Server provides custom recommendations by using the Azure SQL Database Advisor, enabling maximal performance. The SQL Database Advisor makes recommendations for creating and dropping indexes, parameterizing queries, and fixing schema issues.
31/01/2017
SQL Server 2016 May update
SQL Server 2016 SP1 is better. Why? It is more efficient, quicker, thus more economical. How? Thanks to row compression, your SQL Server database requires less storage capacity to execute the same processes. This allows it to be faster than before. Besides that, in-memory tables,...
Advertorial
Business-oriented Data Modelling Masterclass door Alec Sharp
Datamodelleren in de praktijk vanuit een non-technisch perspectief. Contextuele, conceptuele en gedetailleerde modelleertechnieken waarbij maximale betrokkenheid van de gebruiker centraal staat. Alec Sharp staat garant voor een interactieve cursus datamodelleren op 16 t/m 18 november in Utrecht.
31/01/2017
R-Services
R is not new. The most used open source programming language for statistical computing has been around for over two decades. Now, however, its possibilities have been incorporated into SQL Server 2016, resulting in the R Services. Why is this useful to you? R and SQL Server 2016 ...
31/01/2017
SQL Server 2016 vNext
With SQL Server running on Linux, we’ll go through some new syntax introduced in SQL server vNext and SQL server 2016 SPI which allow you to delete tables with a minimal of coding. We’ll also be demonstrating you how to clone databases directly in order to trace performance i...
06/07/2016
Corporate Performance Management with Findo
Wil je de laatste nieuwtjes weten over SQL Server, Microsoft BI, Power BI en CPM? Registreer je voor onze gratis webinars waarin we onze kennis en expertise met u delen. Heb je een van onze webinars gemist of kon je er niet bij zijn? Bekijk dan onze webinar replays wanneer je maa...
02/04/2016 | Sammy Deprez
New features in SQL 2016: Dynamic data masking
As a running up to the new release of SQL 2016, Sammy Deprez shares some research he did about the new features that will be available. He will talk about Dynamic Data Masking. It is a nifty, small but quite interesting new feature.
10/10/2015 | Koen Jacobs
How to make Self-Service BI successful in your organization?
The BI industry has been evolving over the last five years to place more emphasis on self-service, end-user-driven analytical reporting. In response to market needs, many vendors have been broadening their portfolios to offer a wide range of tools that promise to deliver advanced...
05/10/2015 | Franky Leeuwerck
Your first data warehouse model
A data warehouse is a relational database just like any other relational database. However, the database model is designed in a different way. It should facilitate business users querying large amounts of data, but also let them explore the data from different points-of-view by m...
27/09/2015 | Steffen Daneels
Excel in SSIS: fixing the wrong data types
Imagine your client gives you an Excel file as the SSIS source for a new project. When you load the data you find that the data type is not aligning as expected and some of the rows are not filled with the data provided. You then try to change the input data type in the Excel ...
19/09/2015 | Yves Groenen
How to connect to IBM DB2 from Power Query
Situation For a proof of concept I was asked to make a connection from Excel powerquery to an IBM DB2 database. Since I didn’t have a server somewhere with DB2 installed on it, so I went searching for a solution. A thing to keep in mind is that this post isn’t a deep dive int...
- meest gelezen blogs | cases
- 15/09 Juha Korpela about Modelling the Mesh
- 01/09 Data Modeling Is Changing: From Design to Discovery
- 26/08 The Broken Assumptions of Data Governance
- 13/08 Alec Sharp on Concept Modelling with Normal People
- 06/08 Rick van der Lans over een holistische data-architectuur aanpak
Partners
