Sites anglophones


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 …

Adding a Database with Polybase External Tables to Always On Availability Group

Publié le 26 mai 2020 sur sqlservercentral.com
 

Introduction I was asked to add a database with PolyBase External Tables to Always On Availability Group. I thought it would be a straightforward approach, but it got tricky when I learned that one of the prerequisites of PolyBase is that a master key …

[Video] Watch Brent Write T-SQL

Publié le 25 mai 2020 sur brentozar.com
 

This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write t …

How to Move System Databases to a New Physical Directory

Publié le 25 mai 2020 sur sqlservercentral.com
 

I was recently on a very challenging project where we had to do some SQL tasks that were both new to me as a DBA and proved to be challenging. I found myself doing certain tasks over and over. When this happens, I usually find myself automating, creati …

Learning New Skills

Publié le 25 mai 2020 sur sqlservercentral.com
 

The post Learning New Skills appeared first on SQLServerCentral.

New release: SQL Clone 4.4 supports your Database DevOps process

Publié le 25 mai 2020 sur sqlservercentral.com
 

The post New release: SQL Clone 4.4 supports your Database DevOps process appeared first on SQLServerCentral.

Azure Database Migration Guide

Publié le 22 mai 2020 sur sqlservercentral.com
 

The post Azure Database Migration Guide appeared first on SQLServerCentral.

Heaps in SQL Server: Part 1 The Basics

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

The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are …

[Video] How to Think Like the SQL Server Engine: All-Demo Edition

Publié le 21 mai 2020 sur brentozar.com
 

You’ve heard of my free How to Think Like the Engine class, and maybe you even started watching it, but…it has slides, and you hate slides. Wanna see me do the whole thing in Management Studio, starting with an empty query window and …

Hands-On with Columnstore Indexes: Part 1 Architecture

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

Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced i …


Pages :