Microsoft Archives - Virtual-DBA Remote DBA Services & Support - Certified Database Experts https://virtual-dba.com/blog/microsoft/ Remote Database Administration Tue, 27 Jan 2026 22:31:31 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Microsoft Archives - Virtual-DBA Remote DBA Services & Support - Certified Database Experts https://virtual-dba.com/blog/microsoft/ 32 32 How Can a DBA Use AI to Improve Their Efficiency? https://virtual-dba.com/blog/how-dba-use-ai-to-improve-efficiency/ Tue, 07 Oct 2025 14:24:00 +0000 https://virtual-dba.com/?p=243391 SUMMARY: An experienced SQL Server DBA can leverage an AI assistant as a co-pilot to significantly boost efficiency by offloading complex, messy, and time-consuming tasks, thereby acting as a powerful partner for advanced database administration. By partnering with AI to handle rote operations, DBAs are empowered to shift their focus to strategic elements, architectural decisions, […]

The post How Can a DBA Use AI to Improve Their Efficiency? appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> The Billion-Row Scan: Why Your SQL Query for MAX Is Slow and How to Fix It https://virtual-dba.com/blog/billion-row-scan-why-sql-query-for-max-is-slow-and-how-to-fix-it/ Wed, 25 Jun 2025 15:38:00 +0000 https://virtual-dba.com/?p=243082 SUMMARY: Database professionals facing surprisingly slow SELECT MAX() queries on massive SQL Server tables can eliminate costly billion-row Clustered Index Scans by intentionally introducing a non-partitioned Non-Clustered Index to provide the query optimizer a globally sorted shortcut. Understanding deeper architectural features, such as how table partitioning affects a clustered index’s global sort order, is crucial […]

The post The Billion-Row Scan: Why Your SQL Query for MAX Is Slow and How to Fix It appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Why SQL Server 2025 Is AI-Ready with Microsoft Fabric—and How XTIVIA Can Help https://virtual-dba.com/blog/why-sql-server-2025-is-ai-ready-with-microsoft-fabric-how-xtivia-can-help/ Wed, 25 Jun 2025 00:31:09 +0000 https://virtual-dba.com/?p=243058 SUMMARY: SQL Server 2025 is designed as Microsoft’s AI-ready database platform, integrating machine learning directly into the database engine and leveraging Microsoft Fabric for unified data management. This enables businesses to achieve predictive analytics and operational streamlining with comprehensive implementation support from XTIVIA. This powerful synergy provides businesses of all sizes with a comprehensive and […]

The post Why SQL Server 2025 Is AI-Ready with Microsoft Fabric—and How XTIVIA Can Help appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Transitioning to the Windows App: Essential Information for Remote Access https://virtual-dba.com/blog/transitioning-to-windows-app-essential-information-for-remote-access/ Thu, 10 Apr 2025 18:06:49 +0000 https://virtual-dba.com/?p=242803 SUMMARY: Microsoft is replacing the Azure Virtual Desktop Preview with the unified Windows App to ensure uninterrupted service by centralizing access to cloud PCs, virtual desktops, and local resources through a single, cross-platform gateway. Completing the transition to the Windows App is a critical step for organizations to maintain secure, high-performance remote connectivity as legacy […]

The post Transitioning to the Windows App: Essential Information for Remote Access appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Azure Removing Default Outbound Access for Virtual Machines https://virtual-dba.com/blog/azure-removing-default-outbound-access-for-virtual-machines/ Tue, 18 Mar 2025 20:06:02 +0000 https://virtual-dba.com/?p=242783 SUMMARY: Microsoft is retiring default outbound internet access for new Azure Virtual Machines on September 30, 2025, to enhance cloud security by requiring administrators to replace unmanaged, ephemeral IP addresses with explicit routing solutions like NAT Gateways or Load Balancers. Organizations should immediately audit their deployment templates and transition to explicit outbound configurations to prevent […]

The post Azure Removing Default Outbound Access for Virtual Machines appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Azure Deprecating TLS 1.0 and 1.1 https://virtual-dba.com/blog/azure-deprecating-tls-1-0-and-1-1/ Tue, 04 Mar 2025 16:22:00 +0000 https://virtual-dba.com/?p=242795 SUMMARY: Microsoft is deprecating Transport Layer Security (TLS) versions 1.0 and 1.1 across Azure SQL services, requiring organizations to upgrade client connectivity to TLS 1.2 by August 31, 2025, to ensure data security and compliance. Teams should proactively enforce TLS 1.2 immediately, using the Azure portal or PowerShell to avoid potential service disruptions when the […]

The post Azure Deprecating TLS 1.0 and 1.1 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Azure Monitor Best Practices: Essential Metrics for SQL Managed Instances https://virtual-dba.com/blog/azure-monitor-best-practices-essential-metrics-for-sql-managed-instances/ https://virtual-dba.com/blog/azure-monitor-best-practices-essential-metrics-for-sql-managed-instances/#respond Thu, 16 May 2024 23:48:57 +0000 https://virtual-dba.com/?p=242268 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 can be overwhelming. This blog post delves into the best practice metrics you should configure in […]

The post Azure Monitor Best Practices: Essential Metrics for SQL Managed Instances appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/azure-monitor-best-practices-essential-metrics-for-sql-managed-instances/feed/ 0 SharePoint 2013 Workflows Retirement and the Power Automate Solution https://virtual-dba.com/blog/sharepoint-2013-workflows-retirement-and-the-power-automate-solution/ https://virtual-dba.com/blog/sharepoint-2013-workflows-retirement-and-the-power-automate-solution/#respond Thu, 14 Sep 2023 21:02:22 +0000 https://virtual-dba.com/?p=241988 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 2, 2026, it will be fully removed from existing tenants. This […]

The post SharePoint 2013 Workflows Retirement and the Power Automate Solution appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/sharepoint-2013-workflows-retirement-and-the-power-automate-solution/feed/ 0 Microsoft Defender for Cloud Part 1: Comprehensive Features and Updates https://virtual-dba.com/blog/microsoft-defender-for-cloud-part-1-comprehensive-features-and-updates/ https://virtual-dba.com/blog/microsoft-defender-for-cloud-part-1-comprehensive-features-and-updates/#respond Tue, 29 Aug 2023 18:58:11 +0000 https://virtual-dba.com/?p=241930 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 that safeguards and oversees cloud tasks on various platforms such as Azure, […]

The post Microsoft Defender for Cloud Part 1: Comprehensive Features and Updates appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/microsoft-defender-for-cloud-part-1-comprehensive-features-and-updates/feed/ 0 15 Reasons to Choose XTIVIA Virtual-DBA Remote DBA Managed Services for Your Microsoft SQL Server Environments https://virtual-dba.com/blog/15-reasons-to-choose-xtivia-virtual-dba-remote-dba-managed-services-for-microsoft-sql-server-environments/ https://virtual-dba.com/blog/15-reasons-to-choose-xtivia-virtual-dba-remote-dba-managed-services-for-microsoft-sql-server-environments/#respond Wed, 09 Aug 2023 21:43:24 +0000 https://virtual-dba.com/?p=241827 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 maintain their Microsoft SQL Server database systems without the need for an on-site team. Here are the top 15 […]

The post 15 Reasons to Choose XTIVIA Virtual-DBA Remote DBA Managed Services for Your Microsoft SQL Server Environments appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/15-reasons-to-choose-xtivia-virtual-dba-remote-dba-managed-services-for-microsoft-sql-server-environments/feed/ 0