PowerShell Solutions - Several tips for daily tasks
In this tip, we will talk about PowerShell and SQL Server Log and Data Files.
2016-09-27
3,799 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database
In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.
2016-08-22
3,422 reads
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,654 reads
How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,189 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,142 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,370 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,336 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,033 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
2,000 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,544 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
The string_agg function
Comments posted to this topic are about the item The string_agg function
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers