Sites anglophones

Getting Started with GitHub for SQL Server Developers

Publié le 9 janvier 2019 sur

Learn some of the basics of GitHub and how this can be utilized for your SQL Server development projects.

Stairway to DAX and Power BI – Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

Publié le 9 janvier 2019 sur

As a part of his « Function / Iterator Pairs » mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He the …

SQL SERVER – Cleanup Plan Cache For a Single Database

Publié le 9 janvier 2019 sur journey to sqlauthority

During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database. After making the improvements in the database, we reached to the point where we needed to clear the cache of the server …

Consultants: want a utility to gather SQL Server data?

Publié le 8 janvier 2019 sur

When you’re a consultant, you need to get diagnostic data from your clients. When you’re talking to a new sales prospect – do you waste a lot of time asking basic investigation questions like what version they’re on, how much da …

Azure DWH part 29: MicroStrategy Desktop with Azure

Publié le 8 janvier 2019 sur

In this article, we will show how to connect MicroStrategy Desktop with ASDW.

Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace

Publié le 8 janvier 2019 sur

IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.

Azure Data Explorer

Publié le 8 janvier 2019 sur

Read this white paper to get a better understanding of the architecture and technology powering Azure Data Explorer, a fast and highly scalable data exploration service.

SQL SERVER – How to Optimize Your Server Performance by Reducing IO Waits?

Publié le 8 janvier 2019 sur journey to sqlauthority

SQL Server performance tuning is often considered as a complex subject and many DBAs and Developers often see SQL Server Engines as a black box. However, the reality is very different as SQL Server Performance tuning is often a simple art of balancing …

Protecting SQL Server Data Using Static Data Masking

Publié le 7 janvier 2019 sur

Are you providing adequate protection to your sensitive and confidential data? I’m sure we all do our best to protect our confidential data in a production environment by allowing only approved methods to access production data. But how are you p …

Bootstrap 4 and Self-validating Forms

Publié le 7 janvier 2019 sur

Validating the user input of a web form is important for security and data quality. In this article, Dino Esposito explains how to validate a form and add undo capability with Bootstrap 4.

Keep Column Headers Visible in SSRS

Publié le 7 janvier 2019 sur

Keep column headers visible while scrolling down the page of SSRS reports.

SQL Server Performance Tuning Practical Workshop – Relaunched

Publié le 7 janvier 2019 sur journey to sqlauthority

In the year 2017 just for an experiment, I decided to start a SQL Server Performance Tuning Practical Workshop. I had no idea, that I will be the biggest and most popular service delivered by Since the year 2017, I have been deli …

The 2019 Data Professional Salary Survey Results

Publié le 6 janvier 2019 sur

How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it …

When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207

Publié le 6 janvier 2019 sur journey to sqlauthority

Question: When to Use sort_in_tempdb for Rebuilding Indexes? Answer: This question was received during one of the recent Comprehensive Database Performance Health Check consulting engagement. One of the last thing which we did during the cons …

[Video] Office Hours 2019/1/2 (With Transcriptions)

Publié le 5 janvier 2019 sur

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database in order to run sp_databaserestore, restoring production statistics on dev servers to simulate productions behavior, dealing with duplicate SPNs, tools …

Pages :