Table of contentsA Simple Query with a Devious ProblemWhen Partitioning Works Against YouThe Counterintuitive Fix: Adding a "Duplicate" KeyDon't Trust the Icon: Read the Real Execution PlanKey Takeaways for Data Professionals A Simple Query with a Devious Problem It's...
Microsoft Blog Posts
Why SQL Server 2025 Is AI-Ready with Microsoft Fabric—and How XTIVIA Can Help
Table of contentsWhy SQL Server 2025 is AI-Ready: The Future of Data Management1. Seamless AI Integration in SQL Server 20252. Performance Enhancements for AI Workloads3. Predictive Analytics and Automated InsightsThe Role of Microsoft Fabric in SQL Server 20251....
Transitioning to the Windows App: Essential Information for Remote Access
Table of contentsWindows App: Everything You Need to KnowWhat is the Windows App?Use CasesKey BenefitsKey Differences: Windows App vs. Azure Virtual Desktop (AVD)Transitioning from Azure Virtual Desktop Preview to Windows AppKnown Limitations on Windows MachinesUsing...
Azure Removing Default Outbound Access for Virtual Machines
Table of contentsWhat is default outbound access?What is changing?What are the options?How to implement each optionNotes & Best Practices Microsoft has announced that it is retiring default outbound internet access for new Azure Virtual Machines (VMs) on September...
Azure Deprecating TLS 1.0 and 1.1
Table of contentsWhat is TLS?Why the change?What services are impacted?How to prepare?Azure SQL DatabaseAzure SQL Managed InstanceWhat to change in Azure?Azure SQL DatabaseAzure SQL Managed Instance Microsoft has begun deprecating TLS versions 1.0 & 1.1 across all...
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...