2026-06-03
89 reads
Cloud Computing
What should you move first in a cloud migration? 5 key guidelines
Learn how to choose which application to move first in a cloud migration with five practical guidelines
2026-05-27
The Dangers of Dependencies
Single points of failure are bad, but what if an employee's action is the single point of failure for access to services? That would be a bad day for any organization.
2026-05-06
130 reads
How to minimize downtime in a cloud migration
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and system failure.
2026-04-20
How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’
In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to the cloud. It features practical advice and guidance to avoid migration failures and surprises.
2026-04-01
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operating system, patching, and backups, while the user manages their data and databases.
2025-12-03
Reducing Cloud Cost
Cloud costs are high and growing. Some orgs think they're out of control and are trying to limit spend. Some orgs are looking to leave the cloud. A lot of IT spend over the years has been seen as a cost center, with many executives trying to limit the growth or spend, even while they […]
2025-10-29
185 reads
Zero-Trust Architecture for Cloud-Based AI Systems
Zero-Trust Architecture (ZTA) emerges as a strong security paradigm for cloud-based AI systems, fundamentally operating on the principle of “never trust, always verify.” Unlike conventional security models, ZTA assumes potential compromise exists within the network and requires continuous verification of every access request regardless of origin.
2025-07-09
The complexity of using Power BI in US Sovereign Clouds
If you do a search for “sovereign cloud,” you will find that most of the cloud providers have their own Sovereign Cloud if you are interested in the concept for any other cloud services you need to use. In this article, I am going to look specifically at how you extend this support to Power BI, and make a few suggestions for how I think it could work better.
2025-04-11
Beyond Single-Cloud: A Peek into Multi-Cloud
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalability and innovation, organizations are turning their focus to how to get more from their investment. One such consideration is multi-cloud.
2025-03-26
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers