Create and Read the Analysis Services Flight Recorder
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,534 reads
Articles
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code.
2025-11-05
Create an HTML Report on the Status of SQL Server Agent Jobs
Learn how to query your jobs to produce a report that is formatted to make consuming the data easy for DBAs.
2025-11-03 (first published: 2023-05-03)
4,282 reads
Which Should You Use: VARCHAR or NVARCHAR?
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR or NVARCHAR?
2025-11-03
Regular Expressions in SQL Server 2025
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
2025-10-31
16,048 reads
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
There are numerous use cases for multi-file imports of CSV files into a SQL Server table:
2025-10-31
2025-10-29
Docker Advice for SQL Server in Production
Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server remains the gold standard. However, there are still certain scenarios—or even specific environments—where deploying SQL Server in containerized setups using the Docker engine becomes necessary. In this article, I will offer practical tips based on my hands-on […]
2025-10-27
4,160 reads
Managing Underused Indexes in SQL Server Availability Groups – Part 2
Knowing the usage from all workloads is definitely better than focusing on only the primary or a single secondary. But what if I want to make more informed decisions, incorporating row counts, size, and index columns into this output?
2025-10-27
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Learn about implicit transaction and why you might not want to enable this setting.
2025-10-24
6,304 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?