Category: SQL Server

Azure SQL DB, Azure SQL DW, Blog, Data Warehousing, DCAC, Microsoft Technologies, Python, SQL Server

pandas.DataFrame.drop_duplicates and SQL Server unique constraints

By: Meagan Longoria

Published On: August 20, 2022

Read Blog >

Azure SQL Database, Blog, performance tuning, SQL Server, standards

RunAsRadio- Query Performance Tuning Strategies

By: Monica Rathbun

Published On: April 13, 2022

Read Blog >

Back to Basics, Blog, DBA, Indexes, performance tuning, Posts with Scripts, SQL Server, Stored Procedures

Quick Tip: Remove CONVERT\CAST from your WHERE\JOIN clauses

By: Monica Rathbun

Published On: March 28, 2022

Read Blog >

Azure, Blog, DCAC, Microsoft Technologies, SQL Server

Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines

By: Meagan Longoria

Published On: February 22, 2022

Read Blog >

backup, Blog, filestream, SQL Server, SQL Server 2016, sql server 2017, Storage

PREEMPTIVE_OS_FILEOPS Waits and Filestream Restores

By: Joey D'Antoni

Published On: February 22, 2022

Read Blog >

Azure, Blog, Cloud, SQL Server

Why You Shouldn’t Use Amazon RDS for your SQL Server Databases

By: Joey D'Antoni

Published On: February 17, 2022

Read Blog >

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?