Backup Strategy in Azure SQL?
Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.
2016-08-08
1,653 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,175 reads
Azure SQL Limitations compared with a SQL Server Enterprise
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
2016-07-26
15,125 reads
Power BI to Azure SQL and Google Analytics
In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics
2016-07-05
1,367 reads
Data Mining Part 40: Big Data and Microsoft Data Mining
This article will introduce about big data and HDInsight and Hadoop.
2016-05-10
1,335 reads
Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining
In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.
2016-05-04
2,027 reads
Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
1,995 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,543 reads
Data Mining Part 36: Verifying the accuracy of the model
In this new chapter we will show how to verify the accuracy of the mining models.
2016-02-29
1,551 reads
Data Mining Part 35: Text Mining using the term extraction tool
The following article will show how to extract terms occurrence from a SQL table.
2016-02-22
3,042 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers