How to Exclude Specific Queries from Query Store in SQL Server

by

SQL Server’s Query Store captures all queries by default (when using QUERY_CAPTURE_MODE = ALL) or resource-intensive queries (when using AUTO). However, you may want to exclude certain queries from being tracked. These might include monitoring queries, maintenance scripts, or queries from specific applications that add noise to your performance data.

SQL Server doesn’t provide a built-in mechanism to exclude specific queries from Query Store by query text or pattern. But you can achieve similar results through several approaches.

Read more

Getting Started with the Netflix Sample Database in SQL

by

If you’re learning SQL or looking for a real-world dataset to sharpen your database skills, the Netflix sample database could be an option. This free, open-source database is based on publicly available information from Netflix’s Engagement Report and Global Top 10 weekly lists, making it both relevant and engaging for practice purposes.

Read more

What is Database as a Service (DBaaS)?

by

Database as a Service (DBaaS) is a cloud computing model where a provider hosts and manages your database for you. Instead of installing database software on your own servers, configuring it, and handling ongoing maintenance, you access a fully managed database over the internet. The provider takes care of all the technical heavy lifting while you focus on using the database for your applications.

Read more

Dynamic PIVOT in SQL Server for Unknown Column Values

by

Most pivot operations in SQL tend to use hardcoded column lists. This is where you explicitly specify every column name in the IN clause. That works great when you know exactly which values will appear in your data. But what happens when those values change? When new categories get added, when you’re working with user-generated data, or when you’re building a query that needs to work across different datasets?

That’s when you might want to consider dynamic PIVOT. Instead of hardcoding column names, you query the data to discover what columns you need, build the PIVOT query as a string, and execute it dynamically. It’s more complex than static PIVOT, but it’s pretty much essential when your column values aren’t predetermined.

Read more

Calculating Days Between a Fixed Date and Dynamic Dates with DATEDIFF()

by

Sometimes you need to measure how many days have passed between a specific reference point and a constantly moving target. SQL Server’s DATEDIFF() function handles this elegantly by letting you combine hardcoded dates with dynamic functions like GETDATE(). This can be useful for calculating things like age, days since an event, or time remaining until a deadline.

The main point here is that DATEDIFF() doesn’t care whether its date arguments are literals, functions, or even subqueries. It just needs two date values to compare. When you use GETDATE() or similar functions, you’re telling SQL Server to calculate the difference based on the current moment, which means the result changes every time you run the query.

Read more

What is a Distributed Database?

by

A distributed database is a database system where data is stored across multiple physical locations. This could be either on different servers in the same data center or across multiple data centers in different geographic regions. Instead of all your data residing on a single machine, it’s spread across several computers that work together as a unified system.

From an application’s perspective, a distributed database often looks like a single database. You connect to it and run queries as usual. Behind the scenes, however, the database system coordinates multiple servers to store data, process queries, and maintain consistency across all locations.

Read more

Restoring SQL Server Backups in Docker on macOS with VS Code

by

Whether you are a long-time Mac user or recently transitioned from Windows, running SQL Server on macOS brings a unique set of challenges. Most tutorials assume you’re on Windows using SQL Server Management Studio (SSMS), which is a tool that doesn’t exist for Mac. Instead, you’re likely running SQL Server inside a Docker container and using a tool like VS Code.

Read more

What is an Attribute in a Database?

by

In database terminology, an attribute is a piece of information that describes an entity. If an entity is a thing you want to store data about, attributes are the specific details you’re storing. They’re the characteristics, properties, or facts that define what you know about each entity.

When you create a relational database, attributes become the columns in your tables. Each attribute represents one type of information you’re tracking.

Read more

What is a Database Entity?

by

In database design, an entity is something you want to store information about. It’s a person, place, thing, event, or concept that matters to your application and has data associated with it that you need to track.

Entities are the building blocks of database design. Before you create tables, write queries, or think about indexes, you need to identify what entities exist in your domain and what information you need to store about them.

Read more