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
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
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
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
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
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
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
2023-10-25
There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation.
2023-10-23
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
2023-10-23
Learn about the different tables that can be created using Azure Databricks with a dive deep into the importance of Delta Lake tables.
2023-10-20
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers