How to work with ChatGPT in Visual Studio Code
Learn how you can connect ChatGPT to VS Code and use it to help you fix your code.
2023-04-10
67,366 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
ChatGPT and PowerShell – Some practical examples
See how well ChatGPT works with questions on generating PowerShell code.
2023-03-20
13,936 reads
ChatGPT in SQL Server - Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go to that article. We will show some […]
2023-03-06
48,313 reads
How to Forecast Data in Power BI
Learn how you can use Power BI to forecase the future trends of data.
2023-02-27
43,545 reads
What is ChatGPT – Is it the rise of the Skynet era?
An interesting conversation with the ChatGPT artif...
2023-02-13
12,979 reads
How to Import Data in Power BI Using R
This article shows how you can use an R script to import data into Power BI.
2023-01-23
1,907 reads
How to work with web information, maps, and images in Power BI
In this article, you will learn how you can add the map and image visuals to your Power BI report and have them update as you select different data values.
2023-01-16
1,972 reads
How to Create a Power BI report using MySQL data
Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]
2023-01-09
3,884 reads
How to create a Power BI report using REST API data
In this article, we will learn how to use a REST API from Power BI to get data for a report.
2022-12-16
21,424 reads
Tutorial to Create a Power BI Report Using PostgreSQL
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
5,844 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
changing over to a tab delimited file in my pkg that walks thru folders
hi, we just decided to change over to a tab delimited format in a...
how to query that stores mulit select field data
Hi everyone, I have a table as below, I would like to strip out...
Getting all ancestral parents of a table
From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server I can find all the child dependencies starting from my...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;