Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes

Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.

Deleting Documents from a MongoDB Collection

So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.

Configure Microsoft Fabric Database Mirroring for Snowflake

In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.

Four steps towards tackling the complexity of managing multiple database platforms

79% of us are now using two of more database platforms - fantastic for leveraging a range of benefits, but not so great when it comes to levels of complexity. Looking for ways to overcome this? Here are four steps to take towards multi-database simplicity.

Prompt+ EAP: your AI-powered database development partner in the making

Last year, we introduced AI capabilities to SQL Prompt via the Prompt+ Early Access Program (EAP). Using generative AI-powered insights and context-based awareness, Prompt+ takes natural language queries and turns them into SQL coding suggestions. Check out this blog to learn more about Prompt+ and how to join the EAP waitlist.

XML Performance Tuning and Added Options

SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Server is optimized to manage.

Add Indexes to Improve SQL DELETE Performance

This article examines whether creating indexes can help when deleting data from a SQL Server table.

Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16

PASS Data Community Summit 2024 is taking place in Seattle from November 4-8. With over 150 sessions and over 140 different speakers, this year's event promises something for everyone, with a broad variety of topics covered by a range of data industry experts.

If you're looking to connect, share and learn with the data community this year, make sure you register for PASS Summit before the next price bump and save $200 on a 3-day ticket. Beat the price bump by registering for your ticket before July 15, 23:59 PM PT.

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.

• Printed book:
  • US
• Kindle book:
  • US

Docker Logging Guide Part 1: Basic Concepts and Importance

Docker has gained popularity as a containerization platform that allows you to develop, deploy, and execute applications faster. It packages applications and their dependencies into standardized entities known as containers. These containers are lightweight, portable, and capable of operating independently.