SQL Server Central Is Upgrading Our Servers
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
2023-11-01
660 reads
Articles
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
5,194 reads
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month.
2023-11-01
Why Database Discussions Have Moved From the Backroom to the Boardroom
There are good reasons why business leaders should care about their databases—and hidden costs for neglecting them. Our CMO, Kate Duggan, wrote about the risks and potential costs in this article on Bloomberg.
2023-11-01
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
2023-10-30
4,799 reads
Improve Query Performance when SQL Server Ignores Nonclustered Index
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
2023-10-30
Mastering a cloud migration: 10 video tips
If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes!
2023-10-30
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years.
2023-10-27
Power Query Editor in Power BI for Formatting Text Columns
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
2023-10-27
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
2023-10-25
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers