A Simple Query with a Devious Problem It's a scenario every database professional has encountered: a seemingly simple query brings a powerful server to its knees. In this case, 64 Core / 1TB RAM / all SSD. … AND the query was as basic as it gets: SELECT @LastMaxID =...
Microsoft Blog Posts
Why SQL Server 2025 Is AI-Ready with Microsoft Fabric—and How XTIVIA Can Help
In today's rapidly evolving tech landscape, artificial intelligence (AI) is no longer a futuristic concept—it's now a crucial part of how businesses manage data, streamline operations, and drive insights. SQL Server 2025, the latest version of Microsoft's flagship...
Transitioning to the Windows App: Essential Information for Remote Access
Windows App: Everything You Need to Know As of November 27, 2024, the Azure Virtual Desktop Preview app is no longer available for download or installation, with support ending on December 27, 2024. Transitioning to the Windows App is essential to maintaining...
Azure Removing Default Outbound Access for Virtual Machines
Microsoft has announced that it is retiring default outbound internet access for new Azure Virtual Machines (VMs) on September 30, 2025. What is default outbound access? Outbound access is a way for a VM to connect to the internet. Previously, VMs could be created...
Azure Deprecating TLS 1.0 and 1.1
Microsoft has begun deprecating TLS versions 1.0 & 1.1 across all services in Azure. This requires clients connecting to Azure resources to use TLS 1.2 at a minimum, preferably 1.3 if supported. While many deadlines have passed, Microsoft has extended support for...
Azure Monitor Best Practices: Essential Metrics for SQL Managed Instances
Ensuring the performance and availability of your Azure Managed SQL databases is crucial for maintaining a smooth user experience and maximizing business productivity. Azure Monitor offers a robust suite of monitoring tools, but navigating the vast array of metrics...
SharePoint 2013 Workflows Retirement and the Power Automate Solution
Mark your calendars: SharePoint 2013 workflows are set to retire in 2026. The process will be carried out in stages to ensure a smooth transition for all users. Starting April 2, 2024, SharePoint 2013 workflows will be disabled for new tenants. Subsequently, on April...
Microsoft Defender for Cloud Part 1: Comprehensive Features and Updates
Welcome to the first part of my Microsoft Defender for Cloud series, where we will explore its features and updates by providing examples to help you better understand and utilize this powerful security solution. Microsoft Defender for Cloud is a robust security tool...
15 Reasons to Choose XTIVIA Virtual-DBA Remote DBA Managed Services for Your Microsoft SQL Server Environments
As more businesses embrace remote work and cloud-based technologies, the need for remote database administration (DBA) services has increased. XTIVIA Virtual-DBA Remote DBA managed services provide businesses with the technical expertise they need to manage and...
Comparing Azure and AWS for Kubernetes
Choosing between Azure and AWS for Kubernetes depends on an organization's specific needs and requirements. Both cloud providers offer robust Kubernetes services with similar features and capabilities. However, there are several additional factors to consider when...