Win a three-month subscription to Pluralsight
The post Win a three-month subscription to Pluralsight appeared first on SQLServerCentral.
Getting started with PostgreSQL on MacOS
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
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
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
The post Improving SQL Monitor’s Database Performance appeared first on SQLServerCentral.
SQL Database Project with Git Feature Branch Workflow
The post SQL Database Project with Git Feature Branch Workflow appeared first on SQLServerCentral.
Ensure that SSRS is Working while Using Availability Groups
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?
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
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
The post Bridging the Divide between Data Management and DevOps appeared first on SQLServerCentral.
An Introduction to Azure Cosmos DB
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
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
The post Securing Secrets in Azure DevOps appeared first on SQLServerCentral.
SQL Monitor 11.0: Monitor SQL Servers hosted on Amazon RDS
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
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 …