Sites anglophones


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 …

The Basics of Using a Sequence as a Table Default

Publié le 28 mai 2020 sur sqlservercentral.com
 

The Sequence object was introduced in SQL Server 2012. This is a separate schema object that produces a sequence of numeric values, similar to the way an identity works. A sequence is a separate object, however, and it produces values independent of a …

Rewiring Your Culture for an AI-Augmented Future with Intelligent DataOps

Publié le 28 mai 2020 sur sqlservercentral.com
 

The post Rewiring Your Culture for an AI-Augmented Future with Intelligent DataOps appeared first on SQLServerCentral.

Attention Season Pass Holders: New Fundamentals of Parameter Sniffing Videos Available!

Publié le 27 mai 2020 sur brentozar.com
 

If you’ve got a Recorded Class Season Pass or Live Class Season Pass, time to get your learn on: yesterday’s Fundamentals of Parameter Sniffing class recordings are now available in your account here. As a reminder, here’s the class a …

How Many Databases Can You Name?

Publié le 27 mai 2020 sur sqlservercentral.com
 

The post How Many Databases Can You Name? appeared first on SQLServerCentral.

Improve Row Count Estimates for Table Variables without Changing Code

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

You probably have heard that table variables work fine when the table variable only contains a small number of records, but when the table variable contains a large number of records it doesn’t perform all that well. A solution for this problem h …

Microsoft SQL Server Utilities and Tools

Publié le 26 mai 2020 sur sqlservercentral.com
 

Useful free and paid Microsoft SQL Server utilities and tools – a complete list of 275 SQL Server Utilities updated on Jan 24, 2019. Utility types (main purpose), in braces {} current counts: : Backup solutions {6} [BI]: Business Intelligence Solutions …

SQL ConstantCare® Now Tells You Which Indexes to Drop.

Publié le 26 mai 2020 sur brentozar.com
 

Indexes slow down data changes. SQL Server doesn’t have the concept of asynchronous indexes – copies of the data that it could update later when it’s bored. It has to keep every nonclustered index up to date, every single time you cha …


Pages :