Sites anglophones


Power BI and The Matrix: A Challenge

Publié le 15 avril 2019 sur simple-talk.com
 

In this article, I will show an example to demonstrate some interesting techniques using the Matrix visual. This was inspired by a friend, Albert Herd, who asked for some help in our Malta user group to solve a problem. The data used in the example is …

The BI Journey: The Expert’s Advice – Part 2

Publié le 15 avril 2019 sur simple-talk.com
 

The series so far: The BI Journey: The Analyst The BI Journey: The Expert’s Advice – Part 1 The BI Journey: The Expert’s Advice – Part 2 Ruthie, the intern at the AdventureWorks sales department was in her final stages of buildi …

Blog Relocated

Publié le 15 avril 2019 sur sqlblog.com
 

My blog here has moved to sql.kiwi Please update your bookmarks and other links….(read more)

SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio

Publié le 15 avril 2019 sur journey to sqlauthority
 

Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS) …

Canine Corgi Completion Contest

Publié le 15 avril 2019 sur sqlservercentral.com
 

At our recent SQL in the City Streamed, Kendra had this wonderful quote during one of our ad hoc, group discussions: “There is an urgent message in the bathroom at Redgate…” We eventually got to learn what the message was, but I thou …

Service Broker Part 1: Service Broker Basics

Publié le 15 avril 2019 sur sqlservercentral.com
 

Part 1: Service Broker Basics Microsoft first introduced Service Broker as part of the relational engine of SQL Server 2005. Service Broker is an asynchronous messaging framework with which you can implement scalable, distributed, high available, relia …

4 Top Tips for starting your database DevOps journey

Publié le 15 avril 2019 sur sqlservercentral.com
 

The post 4 Top Tips for starting your database DevOps journey appeared first on SQLServerCentral.

Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220

Publié le 14 avril 2019 sur journey to sqlauthority
 

Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?Answer: Yes.Let us understand the answer a bit more in detail. When the ARITHABORT is set to ON in your logon sessions, you are in safe hand but due to any reasons, if you turn …

Intel Optane Technology and SQL Server

Publié le 14 avril 2019 sur sqlskills.com - glen berry
 

You may have heard of Intel Optane Technology, but perhaps you aren’t quite sure what that term actually refers to, and whether it is relevant for SQL Server. Unfortunately, Intel Optane is an overloaded marketing term that covers several differe …

SQL SERVER – Getting Started with Azure Data Studio

Publié le 13 avril 2019 sur journey to sqlauthority
 

Do you still use SQL Server Management Studio or do you use Azure Data Studio? I was recently asked during my recent Comprehensive Database Performance Health Check, Well, the answer is I am still using SQL Server Management Studio (SSMS) as I find it …

Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE

Publié le 12 avril 2019 sur journey to sqlauthority
 

It is just 12 days before we have a SQL Server Performance Tuning Practical Workshop for EVERYONE. If you have ever attended any of my previous SQL Sessions, you know that the session will be extremely interactive. Many of you have asked me how wi …

Manage SQL Server Agent History More Effectively

Publié le 12 avril 2019 sur sqlservercentral.com
 

The post Manage SQL Server Agent History More Effectively appeared first on SQLServerCentral.

SQL Server Diagnostic Information Queries for April 2019

Publié le 11 avril 2019 sur sqlskills.com - glen berry
 

This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have been trying to fix the broken links to many Microsoft blog posts that resulted from Microsoft’s recent massive web si …

Finding Froid’s Limits: Testing Inlined User-Defined Functions

Publié le 11 avril 2019 sur brentozar.com
 

This week, I’ve been writing about how SQL Server 2019’s bringing a few new features to mitigate parameter sniffing, but they’re more complex than they appear at first glance: adaptive memory grants, air_quote_actual plans, and adapti …

SQL SERVER – FIX: Install Error: A Network-Related or Instance-Specific Error Occurred While Establishing a Connection to SQL Server

Publié le 11 avril 2019 sur journey to sqlauthority
 

One of the most common connectivity errors which I have heard about it is “A network-related or instance-specific error occurred while establishing a connection to SQL Server.” In this blog, we would learn about how to fix this error if it …


Pages :