Heaps in SQL Server: Part 2 Optimizing Reads
In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning.
Using SQL Data Compare to Sync Reference Data
Let's say your QA team maintain two similar test databases. They run tests to verify that different versions of the same application still produce the same, correct results. Therefore, any differences in the test data, between the two databases, needs to be corrected before the tests start. This is the sort of task for which SQL Data Compare is ideally suited, and Bob Sheldon explains how it all works.
Using SQL Server Query Store & Plan Guides to Fix Problem Queries
This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.
Beating the Cloud Vendors
Can you run a system better than cloud vendors? You should know and be able to prove it.
Loading data in Azure Synapse using Copy
Learn how to create a Synapse resource and upload data using the COPY command.
Connecting to a SQL Server Docker Container Running in macOS
Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running.
SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies
Louis Davidson provides a pair of SQL Prompt snippets that will help you deal with dependencies, whenever you need to drop columns or tables.
Controlling Intelligent Query Processing Features
I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
Moving away from an RDBMS
Today Steve looks at an article the migrates a relational model to CosmosDB.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Taman Permata Indah II TLP/WA 08216977749
blok M, Ruko, Jl. Taman Permata Indah 2 Jl. Kp. Gusti No.27, Pejagalan, Daerah...
BCA KCP Lindeteves Trade Center TLP/WA 08216366654
Gedung Lindeteves Trade Center Ruko RA 33 - 35 - 36, Jl. Hayam Wuruk...
Alamat kantor resmi BCA KCU PANTAI INDAH KAPUK Telp:0817866887
WhatsApp:0817866887 Jl. Pantai Indah Kapuk Utara I Blok F, Kamal Muara, Kecamatan Penjaringan, Jkt...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers