Sites anglophones


Attention Live Class Season Pass Holders: New Mastering Parameter Sniffing Videos Available!

Publié le 4 juin 2020 sur brentozar.com
 

Time to get your learn on: this week’s Mastering Parameter Sniffing class recordings are already available in your account here if you’ve got a Live Class Season Pass. (What’s that? You don’t have one yet? Well, tell you what: c …

Help Redgate to build the next generation of Database DevOps solutions

Publié le 4 juin 2020 sur sqlservercentral.com
 

The post Help Redgate to build the next generation of Database DevOps solutions appeared first on SQLServerCentral.

How to Download Stocks on Schedule Using R

Publié le 4 juin 2020 sur sqlservercentral.com
 

Introduction In order to assess stocks before buying them or to evaluate performance of stocks that you might own, you have to be able to download data about the stocks regularly. This post demonstrates how to schedule stock downloads using R. Download …

Updated First Responder Kit and Consultant Toolkit for June 2020

Publié le 3 juin 2020 sur brentozar.com
 

If you’re saving the contents of sp_BlitzFirst, sp_BlitzCache, and sp_BlitzWho to tables every 15 minutes, you should definitely install this month’s updates. There are several key improvements for you in here to help make it easier to trou …

SQL Server Business Continuity – Know Your Options

Publié le 3 juin 2020 sur sqlservercentral.com
 

The post SQL Server Business Continuity – Know Your Options appeared first on SQLServerCentral.

Automate Oracle database deployments with Redgate Change Automation

Publié le 3 juin 2020 sur sqlservercentral.com
 

The post Automate Oracle database deployments with Redgate Change Automation appeared first on SQLServerCentral.

Updating Statistics Causes Parameter Sniffing.

Publié le 2 juin 2020 sur brentozar.com
 

In my free How to Think Like the Engine class, I explain that SQL Server builds execution plans based on statistics. The contents of your tables inform the decisions it makes about which indexes to use, whether to do seeks or scans, how many CPU cores …

SQL ConstantCare® Population Report: Spring 2020

Publié le 1 juin 2020 sur brentozar.com
 

Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the spring 2020 version of our population report. Our SQL ConstantCare® service lets users send …

The State of Database Monitoring in 2020

Publié le 1 juin 2020 sur sqlservercentral.com
 

The post The State of Database Monitoring in 2020 appeared first on SQLServerCentral.

Installing SQL Server 2019 using the Azure Cloud Shell

Publié le 1 juin 2020 sur sqlservercentral.com
 

Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate t …

Updated First Responder Kit and Consultant Toolkit for May 2020

Publié le 29 mai 2020 sur sqlservercentral.com
 

The post Updated First Responder Kit and Consultant Toolkit for May 2020 appeared first on SQLServerCentral.

Recycle Fulltext Catalog Log Files

Publié le 28 mai 2020 sur sqlskills - jonathan kehayas
 

It’s not often that I have the need or opportunity to work with FullText Indexes, and it’s also not often that I come across a new thing to add to regularly schedule maintenance tasks in SQL Server.  Today I happened to do at the same …

How to Create an Ubuntu PowerShell Development Environment – Part 3

Publié le 28 mai 2020 sur simple-talk.com
 

The series so far: How to Create an Ubuntu PowerShell Development Environment – Part 1 How to Create an Ubuntu PowerShell Development Environment – Part 2 How to Create an Ubuntu PowerShell Development Environment – Part 3 Over the la …

[Video] Watch Brent Write Queries

Publié le 28 mai 2020 sur brentozar.com
 

This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a vari …

Storage 101: Convergence and Composability

Publié le 28 mai 2020 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …


Pages :