This blog article shows you how to how to debug T-SQL statements using Visual Studio. In the blog article Querying All Tables in a Database Using Dynamic SQL in Microsoft SQL Server we have the SQL code as follows.
Start Visual Studio, go to Tools then select SQL Server -> New Query…
Login to SQL Server. Click Connect.
Paste the SQL code into the Visual Studio.
Select Execute with Debugger.
You can step through the T-SQL code now.
This blog article shows you how to add GitHub Copilot Completion and GitHub Copilot Chat to Visual Studio 2022. This article expects you to know how to create a Console App in Visual Studio 2022. The figure below is before add in the GitHub Copilot.
To add GitHub Copilot, click on Extensions, then select Manage Extensions…
In the Search box type github copilot. Click on Download for GitHub Copilot Completions.
You will then see the alert as follows:
Save your work and close Visual Studio then the installation of the GitHub Copilot Completions will begin.
Click Close when the installation is completed.
Also: Generate Code using GitHub Copilot, Gemini, ChatGPT, and Bing Chat
When you reopen your project, you need to click on Add GitHub Account. Visual Studio will ask you for sign in. Type in your user name and password.
Click on Re-enter your credentials for GitHub.
Type in your username and password.
You will see the Success screen.
Now you can see the auto completion is with GitHub Copilot.
Add GitHub Copilot Chat from Manage Extensions
Re-open the project. Right Click on the code page and select Add Copilot.
You can now ask Copilot to write some code for your project.
Note, GitHub Copilot is a pay service.
These are the good reads found in this month.
Is Kubernetes worth it?
· What to consider
· The importance of a TCO analysis…
https://www.infoworld.com/article/3714768/is-kubernetes-worth-the-price-tag.html
How to set – and achieve – DEI goals in IT
· Take stock
· Get specific
· Measure progress and be prepared to adjust tactics…
Why companies are leaving the cloud
· Cost, not cloud
· Don’t feel sorry for the public cloud providers…
https://www.infoworld.com/article/3712861/why-companies-are-leaving-the-cloud.html
3 Signs It’s Time to Move off the Cloud
· Timing
· Cost
· The Cost of Not Moving…
https://thenewstack.io/three-signs-its-time-to-move-off-the-cloud/
The cloud is benefiting IT, but not business
· Who benefits from the cloud (besides vendors)?
· ROI of cloud computing and AI
https://www.infoworld.com/article/3715300/the-cloud-is-benefiting-it-but-not-business.html
8 Essential Qualities of Successful Leaders
1. Authenticity
2. Curiosity
3. Analytical prowess…
https://hbr.org/2023/12/8-essential-qualities-of-successful-leaders?ab=HP-hero-for-you-text-1
Resource:
Case Studies in Cloud Modernisation
Are you dealing with a database where you need to query every table, but you’re not keen on writing out individual SELECT statements for each one? Microsoft SQL Server offers a solution through dynamic SQL and cursors, enabling you to automate the process efficiently. Let’s delve into how you can achieve this.
Dynamic SQL
Dynamic SQL refers to generating SQL statements dynamically at runtime. It allows you to construct SQL statements based on variables or conditions, offering flexibility in query generation.
Cursors
Cursors in SQL Server are database objects used to retrieve data row by row, which is particularly useful when you need to iterate through a result set or perform operations on each row individually.
Combining Dynamic SQL and Cursors
We can harness the power of dynamic SQL and cursors to iterate through all tables in a database and execute a SELECT statement for each table.
Here’s how you can do it in Microsoft SQL Server:
DECLARE @TableName NVARCHAR(255)
DECLARE @SQL NVARCHAR(MAX)
— Declare a cursor to loop through all table names
DECLARE TableCursor CURSOR FOR
SELECT name
FROM sys.tables
— Open the cursor
OPEN TableCursor
— Fetch the first table name from the cursor
FETCH NEXT FROM TableCursor INTO @TableName
— Start looping through tables
WHILE @@FETCH_STATUS = 0
BEGIN
— Build the dynamic SQL statement
SET @SQL = ‘SELECT * FROM ‘ + QUOTENAME(@TableName)
— Execute the dynamic SQL
EXEC sp_executesql @SQL
— Fetch the next table name
FETCH NEXT FROM TableCursor INTO @TableName
END
— Close and deallocate the cursor
CLOSE TableCursor
DEALLOCATE TableCursor
Also: Find the Common Number for the Numerator and the Denominator T-SQL
Explanation
– We declare a cursor (`TableCursor`) to loop through all table names retrieved from the `sys.tables` system catalog view.
– Inside the loop, we construct a dynamic SQL statement to select all columns from the current table.
– The dynamic SQL statement is executed using `sp_executesql`.
– The cursor continues fetching the next table name until all tables have been processed.
By leveraging dynamic SQL and cursors in Microsoft SQL Server, you can streamline the process of querying multiple tables within a database. This approach not only saves time and effort but also enhances the automation capabilities of your database queries. So next time you find yourself needing to query every table in a SQL Server database, remember this efficient method at your disposal.
Source code download: https://github.com/chanmmn/database/tree/main/2024/script/LoopAllDatabaseTables?WT.mc_id=DP-MVP-36769
This blog article shows you how to download the file from Azure Storage folder using PowerShell. Below is the code snippet to download the files from Azure Storage Container.
Connect-AzAccount -Tenant TanantId -Subscription SubscriptionId
$resourceGroupName=”resourcename”
$storageAccName=”accname”
$directoryPath=”document”
$container = “container”
Function Getfiles
{
$ctx=(Get-AzStorageAccount -ResourceGroupName $resourceGroupName -Name $storageAccName).Context
$files = Get-AzStorageBlob -Container “document” -Context $ctx | Where-Object {$_.LastModified -gt “2023-12-04” -and $_.LastModified -lt “2023-12-05”}
foreach ($file in $files)
{
write-host -ForegroundColor Yellow $file.Name
Get-AzStorageBlobContent -Container “document” -Context $ctx -Blob $file.Name -Destination “C:\test\test”
}
}
Getfiles
Also: Azure Storage Filter Last Modified Date
Source code download: https://github.com/chanmmn/powershell/tree/main/2024/AzureStorageGetFile/?WT.mc_id=DP-MVP-36769
Create highly differentiated digital experiences and deliver continuous innovation with Azure Innovate, a new offering to help you plan and deploy Microsoft solutions across apps, data and AI to build intelligent applications.
Get started with the Azure Migrate and Modernize + Azure Innovate Resource Kit to explore cloud migration and modernisation scenarios and find resources to help you build new apps in the cloud.
Use the resource kit to:
This resource kit includes comprehensive advice and resources to help you adopt Azure across all stages of your cloud innovation journey.
This blog is originated form here (https://chanmingman.wordpress.com).
The content is extracted from a Microsoft email.
(Read it now, I am not sure how long Microsoft will leave the link alive).
Read: https://bit.ly/4ag8pqd
Six Strategies for AI Implementation: Responsible AI practices on Azure
Position your org for long-term success by responsibly implementing and scaling AI using Azure. Ensure compliance, mitigate risks,and build trust using the strategies for responsible and ethical AI in this eBook.
Get Six Strategies for AI Implementation: How to apply responsible AI practices on Azure to learn about:
This blog is originated form here (https://chanmingman.wordpress.com).
The content is extracted from a Microsoft email.
(Read it now, I am not sure how long Microsoft will leave the link alive).
Read: https://bit.ly/3WEO6jf
This blog article shows you how to call a C# Web Api using JavaScript. For JavaScript to call the Web Api, you might need to add the CORS allows code in Program.cs in your Web Api like below.
app.UseCors(builder => builder.AllowAnyHeader().AllowAnyMethod().WithOrigins(“https://localhost:7046”));
With the JavaScript below, you can call the Web Api at port 7271 from the link https://localhost:7046.
<script>
// Define the API URL
const apiUrl = ‘https://localhost:7271/WeatherForecast’;
// Make a GET request
fetch(apiUrl)
.then(response => {
if (!response.ok) {
throw new Error(‘Network response was not ok’);
}
return response.json();
})
.then(data => {
// Work with the JSON data here
const weatherDataElement = document.getElementById(‘weatherData’);
weatherDataElement.textContent = JSON.stringify(data, null, 2);
console.log(data);
})
.catch(error => {
console.error(‘Error:’, error);
});
</script>
You can download the code and try it out.
Source code download: https://github.com/chanmmn/WebApi/tree/master/2024/JavaScriptCallWebApiCS/WebAppEmpty?WT.mc_id=DP-MVP-36769
This blog article shows the basics on how to create Web Api using Visual Studio 2022. Start Visual Studio 2022. Click on Create a new project.
In the search box, type web api, choose ASP.NET Core Web Api. Click Next.
Type in the Project name, for example, WebAppBasic. Click Next.
Select .NET 8, leave everything as default. Click Next.
You will see the following screen when the project is finished creating.
Also: Console App call Web Api C#
The below is the application structure for the Web Api.
You can see the following method when opening the Controllers.
Click Run then the browser will pop up as follows.
Click on GET then Try it out.
Click on Execute then you will see the result.
Video: https://youtu.be/j9vvERrKi9o?WT.mc_id=DP-MVP-36769
Source code download: https://github.com/chanmmn/WebApi/tree/master/2024/JavaScriptCallWebApiCS/WebAppBasic?WT.mc_id=DP-MVP-36769
This blog article shows you the common mistakes that people make when creating VLOOKUP in Excel. For example, we want to find the price of the server like below.
The first mistake is to start with the wrong column, The column should start from column B and not A.
=VLOOKUP(E2,A2:C6,2,FALSE)
The second mistake is only selecting the column to search. B2 to B6 as the example below.
=VLOOKUP(E2,B2:B6,2,FALSE)
The third missing is type in the wrong index column. From the search column to the value column maximum index is 2 and there is no 3.
=VLOOKUP(E2,B2:C6,3,FALSE)
The correct VLookup as follow.
=VLOOKUP(E2,B2:C6,2,FALSE)
Video: https://youtu.be/U0IxmZuTeqU?WT.mc_id=DP-MVP-36769
Source file download: https://github.com/chanmmn/vba/blob/master/2024/vlookup.xlsx?WT.mc_id=DP-MVP-36769
Chanmingman's Blog 