Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
2019-01-25
2,931 reads
Additional Articles
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.
2019-01-24
2,922 reads
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.
2019-01-23
2,297 reads
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.
2019-01-22
2,188 reads
Creating Measures Using DAX
In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model.
2019-01-21
2,447 reads
Do Functions Stop You From Using Indexes?
If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.
2019-01-18
3,536 reads
Logging SQL and Change-Tracking Events in EF Core
Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.
2019-01-18
2,083 reads
Saving Data to Various Formats, Using SQL
You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.
2019-01-17
3,509 reads
Using T-SQL to Fix Bad Data in XML Documents Using FLWOR
Learn how to use T-SQL to fix contents of an XML document using FLWOR
2019-01-17
2,558 reads
Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers
In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.
2019-01-16
2,635 reads
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
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers