Sites anglophones


Heaps in SQL Server: Part 2 Optimizing Reads

Publié le 22 juin 2020 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps are not necessarily the developer’s favourite child, as they are not very performant, especially when it comes to selecting data (most pe …

Storage 101: Cloud Storage

Publié le 22 juin 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 …

Connecting to a SQL Server Docker Container Running in macOS

Publié le 22 juin 2020 sur simple-talk.com
 

The series so far: Creating Your First SQL Server Docker Container in macOS Managing SQL Server Docker containers in macOS Connecting to a SQL Server Docker Container Running in macOS In the second part of this article series, you learned about the con …

Finally, You Can Buy Brent Ozar Unlimited Swag.

Publié le 22 juin 2020 sur brentozar.com
 

When I’m doing a webcast, the same question always comes up: “Hey, how do I get one of those coffee mugs?” We used to give ’em away during our in-person live training classes, but since I stopped doing those, we needed to come u …

DAX for SQL Folks: Part III – DAX Calculations

Publié le 22 juin 2020 sur sqlservercentral.com
 

Introduction In response to my approach in the popular MDX Guide for SQL Folks series. I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning ex …

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

Publié le 22 juin 2020 sur sqlservercentral.com
 

The post Testing SQL Server Stored Procedures and Functions with SQL Data Compare appeared first on SQLServerCentral.

What is the impact of remote working on estate management?

Publié le 19 juin 2020 sur sqlservercentral.com
 

The post What is the impact of remote working on estate management? appeared first on SQLServerCentral.

How Doug Lowing Gets the Most Out of His Live Class Season Pass

Publié le 18 juin 2020 sur brentozar.com
 

With my Live Class Season Pass, students have the ability to attend as many of my live online classes as they want for an entire year straight, plus they can view the instant replay recordings whenever they want. Doug Lowing, one of the students, share …

Provisioning Azure SQL Database with Failover groups using Terraform

Publié le 18 juin 2020 sur sqlservercentral.com
 

Introduction The world of IT infrastructure is fast changing with the introduction of cloud offerings. Although the Azure/AWS portals make life easier but imagine if you have to provision multiple resources. You will spend entire day clicking and that …

Unlocking the value of frequent database deployments

Publié le 18 juin 2020 sur sqlservercentral.com
 

The post Unlocking the value of frequent database deployments appeared first on SQLServerCentral.

Page Life Expectancy Doesn’t Mean Jack, and You Should Stop Looking At It.

Publié le 17 juin 2020 sur brentozar.com
 

Page Life Expectancy is a Perfmon counter that’s supposed to track how long pages stay in memory before they get flushed out to make room for other pages that are needed instead. Paul Randal has blogged this a few times, and rather than rehash …

Take our short readers’ survey and win a $50 Amazon voucher

Publié le 17 juin 2020 sur sqlservercentral.com
 

The post Take our short readers’ survey and win a $50 Amazon voucher appeared first on SQLServerCentral.

Monitor Deadlocks in SQL Server with system_health Extended Events

Publié le 17 juin 2020 sur sqlservercentral.com
 

The post Monitor Deadlocks in SQL Server with system_health Extended Events appeared first on SQLServerCentral.

What Was the Worst Database Decision You Ever Made?

Publié le 16 juin 2020 sur brentozar.com
 

I’m not talking about “oops” mistakes. I’m talking about things you decided to do on purpose, and then deeply regretted later. Me personally, my biggest database regret was that time almost twenty years ago when I ran a Profiler …

Understanding the State of Database Monitoring report

Publié le 16 juin 2020 sur sqlservercentral.com
 

The post Understanding the State of Database Monitoring report appeared first on SQLServerCentral.


Pages :