Sites anglophones


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 …

Keyword Join or Inner Join – SQL in Sixty Seconds #099

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

Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different? We will discuss that in today’s SQL in Sixty Seconds.During the recent Comprehensive Database Perf …

Azure Data Factory : Your First Data Pipeline

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

Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move …

SQL Server Bulk Insert for Multiple CSV Files from a Single Folder

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

The post SQL Server Bulk Insert for Multiple CSV Files from a Single Folder appeared first on SQLServerCentral.

European Union Folks: Wanna Attend Mastering Index Tuning?

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

You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. I’ll teach you the most important advanced lessons in one day. In my one-day Mastering In …


Pages :