SQL DB now supports 4TB max database size
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost.
Customers using...
2017-03-10
297 reads
James Serra's Blog
Power BI and Excel options for Hadoop
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
571 reads
Azure Data Factory and SSIS compared
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS....
2017-03-01
447 reads
IoT Hub vs. Event Hub
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...
2017-02-08
335 reads
Microsoft Products vs Hadoop/OSS Products
Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This...
2017-01-18
345 reads
Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
270 reads
Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
417 reads
What is HTAP?
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
323 reads
Total Cost of Ownership (TCO) Calculator
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,227 reads
Azure Advisor
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
314 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers