Sites anglophones


SQL Server Diagnostic Information Queries for October 2019

Publié le 3 octobre 2019 sur sqlskills.com - glen berry
 

This month, I have just done some minor formatting and documentation improvements.I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This work …

SQL SERVER – 7 Resources From Techorama Netherlands 2019

Publié le 3 octobre 2019 sur journey to sqlauthority
 

Just earlier today I completed my second edition of Techorama Netherlands. It was fantastic and I had a great time presenting at a day-long training and also two sessions on technology. In this blog post, I will include a few resources which I promised …

You just Build It don’t you? 12 Common Database Build Blockers

Publié le 3 octobre 2019 sur sqlservercentral.com
 

The post You just Build It don’t you? 12 Common Database Build Blockers appeared first on SQLServerCentral.

Getting a List of the Striped Backup Files

Publié le 3 octobre 2019 sur sqlservercentral.com
 

I had an interesting challenge recently with a customer. They were looking to work with the SQL Clone product from Redgate, but had to deal with striped backups. This isn’t a problem for the product, but this customer wanted to automatically build an i …

SQL SERVER – Drop Multiple Columns from a Single Table

Publié le 2 octobre 2019 sur journey to sqlauthority
 

Recently, while working with a client, we determined that they have many unused indexes and unused columns in their table. I worked along with them doing a Comprehensive Database Performance Health Check. I noticed that DBA was dropping the unused colu …

Azure Data Factory If Condition Activity

Publié le 2 octobre 2019 sur sqlservercentral.com
 

The post Azure Data Factory If Condition Activity appeared first on SQLServerCentral.

I’m coming to Gothenburg & Oslo next summer.

Publié le 1 octobre 2019 sur brentozar.com
 

The Nordic countries are some of the most beautiful places I’ve ever seen. Erika and I are scheduling a few trips over there in 2020, and the first one I can announce is SQL Saturday Gothenburg and SQL Saturday Oslo. I’m teaching my one-day …

SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism

Publié le 1 octobre 2019 sur journey to sqlauthority
 

One of the interesting questions, I received during the recent Comprehensive Database Performance Health Check by one of the attendees. The question was – Is it possible to Override Server’s Configuration of Max Degree of Parallelism?Of cou …

Reporting Services Basics: Adding Groups to Reports

Publié le 1 octobre 2019 sur simple-talk.com
 

The series so far: Reporting Services Basics: Overview and Installation Reporting Services Basics: Creating Your First Report Reporting Services Basics: Data Sources and Datasets Reporting Services Basics: Parameters Reporting Services Basics: Adding G …

Adding a dynamic ColumnId to a DAX Calculated Table

Publié le 1 octobre 2019 sur sqlservercentral.com
 

This article will discuss about the ability to add a dynamic ColumnId to a calculated table into a tabular model. In order to do add the dynamic ColumnId we will use a DAX expression. For the purpose of this article, we will use a simple model. …

How to Create a Pareto Chart in Power BI Desktop

Publié le 1 octobre 2019 sur sqlservercentral.com
 

The post How to Create a Pareto Chart in Power BI Desktop appeared first on SQLServerCentral.

SQL Server 2016 SP2 CU9 Released

Publié le 30 septembre 2019 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2016 SP2 CU9, which is Build 13.0.5470.0. This cumulative update has 21 public hotfixes. Keep in mind that both the SQL Server 2016 RTM and SQL Server 2016 SP1 branches are out of support, so there won’t be any m …

A month till our next live, online classes!

Publié le 30 septembre 2019 sur sqlskills.com - paul randall
 

We have two live, online classes coming up in October and November that round out our training schedule for 2019. These class will be delivered live via WebEx over three days (roughly 12-13 hours of content including Q&As; about the same …

New Free Azure and SQL Server 2019 Training from Microsoft

Publié le 30 septembre 2019 sur brentozar.com
 

Folks often email me and ask, “Brent, why don’t you do training classes on Azure?” The answer is simple: the products change faster than I can recoup the cost of building the training material. By the time the class gets enough revenu …

SQL SERVER – ColumnStore Indexes Without Aggregation

Publié le 30 septembre 2019 sur journey to sqlauthority
 

During the recent Comprehensive Database Performance Health Check, I noticed there were lots of aggregation going on with various data in the table. I suggested that the client can experiment with the columnstore indexes and it may help the performance …


Pages :