Sites anglophones


Getting Started with GitHub for SQL Server Developers

Publié le 9 janvier 2019 sur sqlservercentral.com
 

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 sqlservercentral.com
 

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 brentozar.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 simple-talk.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 SQLAuthority.com. Since the year 2017, I have been deli …

The 2019 Data Professional Salary Survey Results

Publié le 6 janvier 2019 sur brentozar.com
 

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 brentozar.com
 

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 :