Sites anglophones


Win a three-month subscription to Pluralsight

Publié le 19 novembre 2020 sur sqlservercentral.com
 

The post Win a three-month subscription to Pluralsight appeared first on SQLServerCentral.

Getting started with PostgreSQL on MacOS

Publié le 19 novembre 2020 sur sqlservercentral.com
 

Overview PostgreSQL has been one of the most widely used relational database management system. PostgreSQL is open-source and has very powerful community-driven support which enables it to be one of the most popular relational database management syste …

How Scalar User-Defined Functions Slow Down Queries

Publié le 18 novembre 2020 sur brentozar.com
 

When your query has a scalar user-defined function in it, SQL Server may not parallelize it and may hide the work that it’s doing in your execution plan. To show it, I’ll run a simple query against the Users table in the Stack Overflow data …

How Bad Statistics Cause Bad SQL Server Query Performance

Publié le 17 novembre 2020 sur brentozar.com
 

SQL Server uses statistics to guess how many rows will match what your query is looking for. When it guesses too low, your queries will perform poorly because they won’t get enough memory or CPU resources. When it guesses too high, SQL Server wil …

Improving SQL Monitor’s Database Performance

Publié le 17 novembre 2020 sur sqlservercentral.com
 

The post Improving SQL Monitor’s Database Performance appeared first on SQLServerCentral.

SQL Database Project with Git Feature Branch Workflow

Publié le 17 novembre 2020 sur sqlservercentral.com
 

The post SQL Database Project with Git Feature Branch Workflow appeared first on SQLServerCentral.

Ensure that SSRS is Working while Using Availability Groups

Publié le 17 novembre 2020 sur sqlservercentral.com
 

This blog post discusses SSRS in an Always On Availability Group. To make sure I’m staying laser focused on this topic, I need to cover some fundamentals. SSRS installation (SQL Server 2017 and later) Starting from SQL Server 2017, Microsoft decided to …

Wanna Win a New MacBook Air with the Apple Silicon M1 CPU?

Publié le 16 novembre 2020 sur brentozar.com
 

Jeff Atwood (@CodingHorror), the co-founder of StackOverflow.com and Discourse.org, is running a series of giveaways, and I’m particularly excited about this week’s: Make a donation of $40 or more to Fair Fight, Stacey Abrams’ foundat …

Three ways that taking the State of Database DevOps Survey helps the community

Publié le 16 novembre 2020 sur simple-talk.com
 

Redgate has recently opened the 2021 State of Database DevOps Survey. Whether or not your organization does DevOps, I would love for you to take the survey. The survey will require around 15 minutes of your time, but I think it’s a great inv …

Bridging the Divide between Data Management and DevOps

Publié le 16 novembre 2020 sur sqlservercentral.com
 

The post Bridging the Divide between Data Management and DevOps appeared first on SQLServerCentral.

An Introduction to Azure Cosmos DB

Publié le 16 novembre 2020 sur sqlservercentral.com
 

Introduction Azure Cosmos DB is Microsoft’s globally distributed, multi-model platform-as-a-service (PaaS) database. Any web, mobile, gaming, and IoT application that needs to handle massive amounts of structured, semi-structured and unstructured data …

Updated First Responder Kit and Consultant Toolkit for November 2020

Publié le 15 novembre 2020 sur brentozar.com
 

There’s a bunch of improvements & fixes in this month’s release, but before we get to those, I want to talk about you, dear reader. You make the First Responder Kit possible. When you buy my stuff, you’re funding my work on the Fi …

Securing Secrets in Azure DevOps

Publié le 13 novembre 2020 sur sqlservercentral.com
 

The post Securing Secrets in Azure DevOps appeared first on SQLServerCentral.

SQL Monitor 11.0: Monitor SQL Servers hosted on Amazon RDS

Publié le 13 novembre 2020 sur sqlservercentral.com
 

The post SQL Monitor 11.0: Monitor SQL Servers hosted on Amazon RDS appeared first on SQLServerCentral.

[Video] How to Troubleshoot Someone Else’s Temp Table Contents

Publié le 12 novembre 2020 sur brentozar.com
 

Let’s say you need to troubleshoot someone’s query performance, and they’re using temp tables. You want to peek in at their temp table contents from another session while their query is running. SQL Server makes that a little bit chal …


Pages :