Sites anglophones


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 …

SQL Server Agent Job Monitoring for Last Execution

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

The post SQL Server Agent Job Monitoring for Last Execution appeared first on SQLServerCentral.

Mentoring 2020 – want some help from me?

Publié le 11 août 2020 sur sqlskills.com - paul randall
 

Back in 2015 I mentored 54 people for a few months in a huge variety of non-technical subjects, including: General career development Deciding whether or not to change jobs Becoming a consultant Résumé review and enhancement How to hire p …

How to Find Out Whose Queries are Using The Most CPU

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

You’ve got a bunch of users on the same SQL Server, and you wanna know who’s using the most resources. SQL Server doesn’t make this easy. You can query some management views to see which queries or databases have been using the most r …

So, You Want to Be a DBA…

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

When did you begin to think that you might want to be a database administrator? Maybe you worked in another arena of IT and found the work of a DBA interesting. Perhaps you heard someone talking about it in a boot camp and wanted to find out more. Mayb …


Pages :