Sites anglophones


Explaining SQL Server Statistics with Playing Cards

Publié le 17 août 2020 sur brentozar.com
 

When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio: Here’s the demo script I use in the video. T …

Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102

Publié le 17 août 2020 sur journey to sqlauthority
 

What I love most about my job Comprehensive Database Performance Health Check, is that I get to work with different people and answer questions. Today we will see a very interesting question – Are Not Equal (<> or !=! to Operators Equal to …

Create Azure Data Factory inventory using Databricks

Publié le 17 août 2020 sur sqlservercentral.com
 

The post Create Azure Data Factory inventory using Databricks appeared first on SQLServerCentral.

The Two Ways Containers Will Revolutionize Database DevOps

Publié le 17 août 2020 sur simple-talk.com
 

Table of Contents Revolution 1 – Database Provisioning as a Service Why didn’t this happen earlier with SAN automation and virtualization? Why do containers change this? They aren’t inherently stateful Steve Jones shows what the futur …

How to override Date Filters in Power BI

Publié le 17 août 2020 sur sqlservercentral.com
 

Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select …

Do MAX Function Scan Table? – Interview Question of the Week #289

Publié le 16 août 2020 sur journey to sqlauthority
 

Question: Do MAX Function Scan Table to retrieve the data?Answer: Yes, if there are no indexes to help retrieve data.I personally hate answers which are ambiguous and I also do not like to say it depends as well. Let me say in simple possible words wha …

SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)

Publié le 15 août 2020 sur journey to sqlauthority
 

The other day, I received an email from my client of Comprehensive Database Performance Health Check. The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)The …

Negative Identity Column – SQL in Sixty Seconds #101

Publié le 14 août 2020 sur journey to sqlauthority
 

I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.Real-World StoryRecently I had the opportunity to work on a project where my client had a negative identity column. T …

Updated First Responder Kit and Consultant Toolkit for August 2020

Publié le 13 août 2020 sur brentozar.com
 

A couple of big new features this month: sp_Blitz’s @SkipChecksServer parameter lets you centralize a list of checks that you want to skip across different servers, and sp_BlitzIndex’s missing index recommendation list now includes the data …

Patch Your SQL Server – SQL in Sixty Seconds #100

Publié le 13 août 2020 sur journey to sqlauthority
 

When did you last time patch your SQL Server? I often discuss this question with my clients of Comprehensive Database Performance Health Check, I get many different kinds of answers. When I recently asked this question to my friend Binod, he was really …

The Basics of PowerShell Day By Day

Publié le 13 août 2020 sur sqlservercentral.com
 

I wrote an article on using PowerShell to call stored procedures, but a friend sent me a few questions in email about how PowerShell works. I have assumed most people have tried it by now, but perhaps not, so I decided to write a few basic items on Pow …

Using Simple Linear Regression to Make Predictions

Publié le 13 août 2020 sur sqlservercentral.com
 

The post Using Simple Linear Regression to Make Predictions appeared first on SQLServerCentral.

Database modeling – Relationships

Publié le 12 août 2020 sur sqlservercentral.com
 

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible …

How Do I Know If My Query Is Good Enough for Production?

Publié le 12 août 2020 sur brentozar.com
 

When I ask that question, here are some of the things I think about: How many times am I going to run it? Is it a one-off task, or is it going to run thousands of times per second on the front page of a popular web site? What time of the day/week will …

List All Parallel Queries – SQL in Sixty Seconds #098

Publié le 12 août 2020 sur journey to sqlauthority
 

During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries which are running in the server along with the count of times the query has executed.Yes, it is indeed possi …


Pages :