DBA

Boost your SQL Performance by using the new features of SQL Server 2014

SQL server 2014 contains several new Transact-SQL-statements and functions that allow developers to write more efficient code. We give an overview with several examples of how to use these statements. The new in-memory database capabilities offer...

Enhance the quality of your data warehouse by using SQL Server Data Quality Services and Master Data

When creating a data warehouse quality of the stored data is a typical issue. To prevent storing data multiple times, to prevent storing inconsistent data, to prevent storing similar data at different locations,... Microsoft SQL Server offers 2...

SQL Server Self-Service BI with Microsoft Excel

Microsoft SQL Server offers several new tools for information workers who want to analyse and report about data in their databases. Power Tools for SQL Server deliver this interface for information workers. Without being expert in SQL, MDX or DAX,...