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.
What is a Failed Deployment?
Today Steve talks about the concept of what a failure is when deploying changes.
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.
Stairway to Transaction Log Management in SQL Server, Level 4: Managing the Log in Simple Recovery Mode
Tony describes in more detail the SIMPLE recovery model, and the way it works, its advantages and disadvantages.
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.
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.
Shorten the Debate
Steve talks about the process of decision making with idea for shortening the time taken.
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
Level 1 of the Stairway to Synapse Analytics - Create a Synapse Workspace
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
Blogs
India-US Tariff War: Is the Indian IT Sector at Risk?
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
Save BIG on Microsoft Azure Certification – Up to 100% Off!
By Rohit Garg
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
OpenQuery with Application Intent specified runs on primary node.
I have an Open query that runs on an Always On server via a...
What is a Failed Deployment?
Comments posted to this topic are about the item What is a Failed Deployment?
Generating a Series I
Comments posted to this topic are about the item Generating a Series I
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers