Monthly Archives: March 2022

Cloud migration and modernisation with Microsoft Azure (eBook)

Posted on March 31, 2022 by chanmingman

Get insight into migration and modernisation, from planning your migration to fine-tuning your strategy. Read the eBook, Cloud Migration and Modernisation with Microsoft Azure, to get an overview of the migration process and learn how to identify the best modernisation strategy … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, Microsoft Office | Tagged | 1 Comment

SQL Server using WITH NOLOCK in Entity Framework

Posted on March 27, 2022 by chanmingman

This blog article shows you how to implement WITH (NOLOCK) in T-SQL. This article expects you to have SQL Server and C# basic. You will need to using System.Transactions.IsolationLevel.ReadUncommitted in Entity Framework for WITH (NOLOCK) when execute the SQL statement. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

CTO March 2022 articles and resources

Posted on March 27, 2022 by chanmingman

These are the good reads found in this month. 17 IT management certifications for IT leaders IT managers are often responsible not just for overseeing an organization’s IT infrastructure but overseeing its IT teams as well. To succeed, you need … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

Best Practices and Lessons Learned from the Microsoft Cyber Defence Operations Centre

Posted on March 23, 2022 by chanmingman

Download the modern security operations guide to see best practices and lessons learned from the Microsoft Cyber Defence Operations Centre. We’ve created this guide to help you develop strategies to: Modernise your technology stack to ensure you have protection and visibility across … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

SQL Server T-SQL Array

Posted on March 23, 2022 by chanmingman

This blog article shows you a way to implement Array like variable in T-SQL using CURSOR. In C# you can split the string in between space and using array to store the split words in Array like the following. static … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

C# Console.ReadLine skip after Console.Read

Posted on March 21, 2022 by chanmingman

This blog post shows you one of the ways to resole the problem. Console.Readline skip after Console.Read. If you have the code like the following. Console.WriteLine(“Enter a number “); int i = Console.Read(); char ch = Convert.ToChar(i); Console.Write(“i = {0} … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | Leave a comment

SQL Server Audit on table update

Posted on March 19, 2022 by chanmingman

This blog article shows you how to enable the Audit to track changes in the records. This article requires you to have basic SQL Server knowledge. To enable the Audit on table update. 1. Open SQL Server Management Studio. Expand … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

How to call a Stored Procedure that is using a cursor in C#

Posted on March 17, 2022 by chanmingman

This blog post shows you how to call a stored procedure that is using a cursor. This article expect you have basic C# and SQL Server knowledge. I have a Stored Procedure as follow. ALTER PROCEDURE [dbo].[Customers_Cursor1] ASBEGIN SET NOCOUNT … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

Notebook in Azure Data Studio use case

Posted on March 16, 2022 by chanmingman

This blog article shows you one of the use cases for Notebook (also known as Jupyter Notebook) in Azure Data Studio. In SQL Server Management Studio you can right click some of the objects and there is a code template … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Over 100 Data and Analytics Predictions Through 2025

Posted on March 10, 2022 by chanmingman

Get ideas to help strengthen your strategic planning and improve data and analytics delivery in the coming years. Read Over 100 Data and Analytics Predictions through 2025, a leading report in the IT business industry, for forecasts on how business … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, management | Tagged | Leave a comment