Monthly Archives: January 2023

SQL Azure Learning Resources

Posted on January 29, 2023 by chanmingman

This blog article provides the learning resource for SQL Azure Azure SQL fundamentals https://learn.microsoft.com/en-us/training/paths/azure-sql-fundamentals/?WT.mc_id=DP-MVP-36769 Introduction to Azure SQL https://learn.microsoft.com/en-us/training/modules/azure-sql-intro/?WT.mc_id=DP-MVP-36769 Deploy and configure servers, instances, and databases for Azure SQL https://learn.microsoft.com/en-us/training/modules/azure-sql-deploy-configure/?WT.mc_id=DP-MVP-36769 ‘ Secure your data with Azure SQL https://learn.microsoft.com/en-us/training/modules/azure-sql-secure-data/?WT.mc_id=DP-MVP-36769 Deliver consistent performance … Continue reading →

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

Find all datetime columns in SQL Server database

Posted on January 29, 2023 by chanmingman

This blog article shows you how to list all the columns with datetime data type in the Database as well as in the Database Table. I use Northwind Database in the below examples. To list all the columns with datetime … Continue reading →

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

Explore the operational technology (OT) attack trends that are impacting critical infrastructure

Posted on January 27, 2023 by chanmingman

As more of your critical infrastructure moves to the cloud, the number of online devices with the potential to access your network increases rapidly. IoT and OT are connecting to systems that were previously unconnected, which enables not just innovation … Continue reading →

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

How to get the most out of your SQL Server data on Azure

Posted on January 25, 2023 by chanmingman

Do more with less on a fully managed SQL Server instance in the cloud. Get the most out of your data, reduce costs and modernise your SQL Server workloads at scale with Azure SQL Managed Instance. Read this report from … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | 2 Comments

CTO January 2023 articles and resources

Posted on January 24, 2023 by chanmingman

These are the good reads found in this month. Tech in 2023: Here’s what is going to really matter What the analysts say A roundup of 2023 predictions… https://www.zdnet.com/article/tech-in-2023-weve-analysed-the-data-and-heres-whats-really-going-to-matter/ 9 ways IT leaders can impact sustainability initiatives Secure executive support … Continue reading →

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

SQL Server List Constraint using T-SQL

Posted on January 23, 2023 by chanmingman

This blog article shows you how to list all the SQL Server database Constraints as well as find the particular Constraint. Please note that you might find other ways to achieve the same result. I will Northwind database as the … Continue reading →

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

SQL Server Shrink Database using T-SQL

Posted on January 20, 2023 by chanmingman

This blog article shows you how to Shrink a database using T-SQL. In the below example, I have a database named COMMONDB. In order to Shrink the database. Firstly, you need to set the recovery mode to simple. Shrink the … Continue reading →

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

Architect Enterprise Applications And Services For Impact

Posted on January 19, 2023 by chanmingman

Discover how to make your business more adaptive by evolving how you work with strategic IT service partners. Read this Forrester report to get architectural and governance guidance to successfully select and manage enterprise applications, platforms and services. Learn strategies … Continue reading →

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

SQL Server Table Memory Optimization Advisor

Posted on January 15, 2023 by chanmingman

This blog article shows you how to use Memory Optimization Advisor. When I right click and select data from a database table in the SSMS, the Memory Optimization Advisor pops up. You can manually right click the database table and … Continue reading →

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

SSIS Flat file connection manager carriage return or line feed discrepancy

Posted on January 10, 2023 by chanmingman

This blog article shows you how to handle a flat file such as csv, with carriage return in some of the columns. As you can view the data below is completely messed up. Because a column has many carriage return, … Continue reading →

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