Meme Week: Setting Fill Factor to Fix Fragmentation
I just shake my head when I see people setting fill factor in an attempt to “fix” fragmentation. The default fill factor is 100%. That means during an index rebuild, SQL Server packs 100% of your 8KB pages with sweet, juicy, golden brown an …
Frustrated with your database monitoring challenges?
The post Frustrated with your database monitoring challenges? appeared first on SQLServerCentral.
Sentiment Analysis with Python
The post Sentiment Analysis with Python appeared first on SQLServerCentral.
Chaos Engineering in Azure
Introduction Chaos engineering is all about breaking your application! It sounds counterproductive; however, it is the exact opposite. It is a methodology to test how resilient your application is in the actual production world. In this article, we wil …
Meme Week: NOLOCK? NOSQL.
When you find yourself using NOLOCK, consider NOSQL instead. NOLOCK has 4 big problems: Your query can see the same rows twice Your query can skip rows altogether Your query can see data that was never committed Your query can fail altogether If you …
Meme Week: SET DEADLOCK_PRIORITY HIGH
Hey, this seems harmless. Seriously, don’t SET DEADLOCK_PRIORITY HIGH. Even setting it to low can be a bad idea. I’ve heard people say, “Well, I’ve got a big process that runs nightly, but if it gets in anybody’s way, I wo …
Moving from ‘Chaotic’ to ‘Managed’ Database Development using Flyway
The post Moving from ‘Chaotic’ to ‘Managed’ Database Development using Flyway appeared first on SQLServerCentral.
Getting started with MySQL
The post Getting started with MySQL appeared first on SQLServerCentral.
Using Azure File and Blob Storage with Azure VMs – Step by Step
Introduction Azure provides different storage solutions that enterprises can use. This article will go through how we can use two main features of Azure Storage – Azure Files and Azure Blobs. Azure Files typically can be used to replace an enterp …
Meme Week: Queue in the Database
When you have a hammer, everything looks like a nail. Unfortunately, a lot of people don’t even know how to use a hammer correctly. You really shouldn’t be doing queues in the database because: They’re a blocking nightmare, constantly …
Meme Week: SQL Server 2012 as of 2022
This week, I’m writing blog posts that can be summed up in one image. Here’s the first one: You could probably stop reading right there, but if you’re not convinced, allow me to elaborate. SQL Server 2012 support ends July 12. No, the …
Build SQL Server CLR Triggers
The post Build SQL Server CLR Triggers appeared first on SQLServerCentral.
How to Compare Tables in Azure Data Studio
Introduction In this article, we will show how to compare tables in Azure Data Studio. This time we will show how to use the SQL Server Schema Compare extension to compare different database objects like tables, view, functions, or stored procedures. T …
DevOps 101 with Grant Fritchey
The post DevOps 101 with Grant Fritchey appeared first on SQLServerCentral.
Running SQL Server on Oracle and Google Cloud
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google Cloud Platform (GCP) offer to host a Microsoft SQL Server database. This information can prove to be handy while de …