Working with Tables in Azure SQL Data Warehouse
In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.
Moving from application automation to true DevOps by including the database
Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process.
Scaling out SSRS on SQL Server Standard Edition
The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.
Liable for Data Loss
Today Steve Jones looks at some data loss lawsuits against Microsoft, but asks the general question of whether software vendors need to be more liable (and careful).
More Power in Your BI
This week Steve looks at all the information and learning available for Power BI.
Performance Myths : Clustered vs. Non-Clustered Indexes
Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Creating Azure SQL Data Warehouse Databases
Learn how you can create an Azure SQL Warehouse database quickly and easily.
The Cost of Database Downtime
Do you know what the cost is for your database going down? Maybe more interesting, is do you want to know?
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.
AI Helpers or Replacements
The future will see more of our data used in machine learning and other AI-like systems. Is that something we want?
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers