ChatGPT in Visual Studio tutorial
In this article, you will see how ChatGPT works with a database project.
2023-05-01
11,968 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
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,484 reads
ChatGPT and PowerShell – Some practical examples
See how well ChatGPT works with questions on generating PowerShell code.
2023-03-20
13,988 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,719 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
45,690 reads
What is ChatGPT – Is it the rise of the Skynet era?
An interesting conversation with the ChatGPT artif...
2023-02-13
13,035 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,926 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
2,003 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,977 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
22,033 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers