Nasty Fast N-Grams (Part 1): Character-Level Unigrams
An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.
Creating Calculated Columns Using DAX
In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.
Another Reason to Care About Security
Just before the US holiday, Steve wants you to think about the security of our systems.
Executing Integration Services Packages in the Azure-SSIS Integration Runtime
n this tip we will explain how you can deploy, execute and schedule SSIS packages in the Azure cloud.
Installing SQL Server 2019 CTP 2.0
Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers