How to process images and analyze charts with AI
See how ChatGPT can get data from images and conduct analysis on the data.
2025-06-16
2,089 reads
Articles
What are the Key DevOps Performance Metrics You Should Track?
Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the right DevOps performance metrics is crucial for identifying bottlenecks, improving efficiency, and maintaining high availability. Metrics provide insight into how well your team deploys software, how quickly issues are resolved, and how stable the production environment remains over time.
2025-06-16
Dimensional Modeling Case Study Part 3 - Dynamic Days Dimension
In this next installment of the date dimension series, learn how to create a table that supports different types of banding.
2025-06-13
1,899 reads
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams from IoT sensors, financial transactions, and application events with minimal latency. Snowflake offers two robust approaches to meet these real-time data needs: Snowpipe for near-real-time file-based streaming and Direct Streaming via Snowpark API for true real-time data integration.
2025-06-13
Managed Instance Gotchas – Configuration Items
Validate all of your settings and be prepared to make some changes during your migration process. Most of the incompatible options make sense when you think about the purpose of SQL MI – it is controlled by Microsoft. Hardware settings, local file access, high-availability settings, and auditing are configured differently or completely disabled.
2025-06-11
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Learn a few ways to improve performance in your Azure SQL Databases through better indexing, partitioning, and columnstore index consideration.
2025-06-09
2,793 reads
Techniques to query Azure SQL’s new JSON Datatype
The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation in SQL Databases. These features are slated to be a part of SQL Server 2025 as well. Let’s analyze some practical uses of these features
2025-06-09
SQL Automate - A DBA's Time-Saving Toolkit
SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.
2025-06-06
9,478 reads
Index Scans and Table Scans
There are several things that you can do to improve performance by throwing more hardware at the problem, but usually the place you get the most benefit from is when you tune your queries. One common problem that exists is the lack of indexes or incorrect indexes and therefore SQL Server has to process more data to find the records that meet the queries criteria. These issues are known as Index Scans and Table Scans.
2025-06-06
Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric
In this next article, we are going to explore how to install, configure and use the command line to manage a couple different Fabric Lakehouse’s.
2025-06-04
1,201 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers