Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
Fast Enough
The RDBMS works great for many situations, but is it ever fast enough to meet all your needs?
Rolling Back CREATE DDL Statements
There is a myth that DDL statements can't be rolled back. This article tests and debunks the myth.
Getting Started with CQRS – Part 2
In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.
Faster Cloud Warehouses
Azure SQL Data Warehouse gets some improvements, and Steve has a few comments.
Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes
In Level 7, we looked at optimizing rowgroup elimination for a nonclustered columnstore index. For a clustered columnstore index, the same technique can be used but the steps and syntax change a bit. This will be covered later – but first, let’s take a look at another significant difference between nonclustered and clustered columnstore indexes, […]
SQL Server Reporting Services Report Builder with DAX Query Support
In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.
Customizing the Default Azure Data Studio Dashboards
Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I