How to enable SQL Server trace flags
DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.
2021-07-30
Articles
Share your favorite Redgate tool – win technical training from Pluralsight!
Level up your skills with Redgate’s latest competition. Redgate is giving you the chance to win a 3-month subscription to Pluralsight, the technical skills platform. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite Redgate tool and why?’
2021-07-30
High Precision Multiplication
Learn how to multiply large numbers while minimizing the loss of precision
2021-07-28
3,586 reads
How Does Microservices Architecture Change Database Deployment?
Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.
2021-07-28
How to query blob storage with SQL using Azure Synapse
How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.
2021-07-28
Why Power Query as an Activity in Azure Data Factory and SSIS?
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
4,438 reads
How to Compare Two SQL Prompt Styles
A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.
2021-07-26
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Upsert Operation in Cosmos DB using Azure Data Factory
This article covers the basics of upserting data in CosmosDB using Azure Data Factory.
2021-07-23
15,624 reads
Managing SQL Server transaction log size
The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg Larsen explains how to manage the transaction log size.
2021-07-23
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...