SQL Server Archives

Tech Optimizer

May 26, 2026

Devart adds AI assistant & PostgreSQL tools to dbForge

Devart has released dbForge 2026.1, which includes enhancements to its database software suite with advanced AI capabilities and expanded tools for PostgreSQL. The dbForge AI Assistant has been upgraded to utilize database index metadata for generating and refining SQL queries, allowing it to generate context-aware queries, optimize SQL commands, identify redundant or missing indexes, and analyze errors. The update introduces a new visual Query Builder for PostgreSQL, enabling users to create queries through a drag-and-drop interface, and an enhanced SQL Editor with syntax highlighting and index name suggestions. A visual Table Editor for PostgreSQL has also been added for managing table properties. Improvements to schema comparison and synchronization for PostgreSQL and Amazon Redshift have been made, supporting a wider array of servers and offering more mapping options. The update includes pinned document tabs for easy access to frequently used scripts and queries. dbForge 2026.1 is available for various products in the dbForge lineup, and customers with active subscriptions can access the update immediately.

Winsage

May 25, 2026

How I Changed the SID on My Windows Server Without Reinstalling (And Why You Should Care)

Cloning a Windows Server machine can lead to issues with duplicate Security Identifiers (SIDs). A Security Identifier (SID) is a unique string assigned to every machine, user, and group in Windows, functioning like a fingerprint. Duplicate SIDs can cause problems such as domain join failures, incorrect WSUS reporting, inconsistent Group Policy application, and licensing issues. The author initially attempted to use sysprep to change the SID after cloning, which resulted in stripping the domain join and causing SQL Server to fail. The author then discovered Wittytool Disk Clone, which includes a SID changer that successfully generated a new SID and updated all necessary references without disrupting the server's configuration or applications. The process took only six minutes and worked similarly on Windows Server 2019. It is more efficient to generate a new SID during the cloning process rather than afterward. Important precautions include taking a snapshot or backup before making changes and being aware that changing the SID on domain controllers is more complex. Reactivation of Windows may also be required after the SID change.

Tech Optimizer

May 18, 2026

Google Pushes AI for PostgreSQL Development

Google is integrating artificial intelligence into PostgreSQL engineering while ensuring engineers remain responsible for their code contributions. This initiative aims to improve productivity and streamline processes, particularly in version upgrades, replication behavior, and production recovery. Sailesh Krishnamurthy, Google Cloud's VP of Databases, emphasized the importance of human oversight in this AI-driven approach. Between July and December 2025, Google's PostgreSQL engineering focused on logical replication, improvements to pg_upgrade, and upstream bug fixes. Logical replication allows selective database change transfers, which is beneficial for migrations and upgrades. The roadmap includes Automatic Conflict Detection and logical replication of sequences to minimize manual synchronization issues. Enterprise teams are particularly interested in these developments due to the challenges posed by write collisions and misaligned sequence values. The demand for PostgreSQL services at Google is increasing due to migration needs from Oracle and SQL Server. Recent data shows PostgreSQL's rising popularity, ranking fourth in the DB-Engines ranking and gaining 8.37 points year over year, while its competitors experienced declines.

Tech Optimizer

May 18, 2026

Google tells database devs to lean hard on AI for PostgreSQL work

Google is encouraging developers to use AI coding tools for open source projects like PostgreSQL, highlighting the productivity improvements seen internally. Sailesh Krishnamurthy, Vice President of Databases at Google Cloud, emphasized that developers remain accountable for their contributions, regardless of AI usage. The suitability of AI tools for open source projects is due to the accessibility of the codebase, which aids in training generative models. PostgreSQL is noted for its extensibility, allowing for rapid experimentation and innovation. A recent Stack Overflow survey identified PostgreSQL as the most favored database among developers in 2023, attributed to increased investments from major cloud providers. Microsoft has made significant contributions to PostgreSQL, including the development of pg_documentdb_core and pg_documentdb_api, and has introduced a distributed PostgreSQL database service called HorizonDB. Research from Gartner shows that only Microsoft has grown its market share among leading database vendors over the past 15 years, while Google and other cloud providers are shifting momentum towards open source solutions like PostgreSQL.

Winsage

May 13, 2026

Windows 11 security update fixes critical Bing and Azure flaws

Microsoft released its May 2026 Patch Tuesday updates for Windows 11, addressing 97 security vulnerabilities across various components, including Windows, Microsoft Office, Azure services, SQL Server, SharePoint, Hyper-V, and .NET. The updates are encapsulated in KB5089549 for Windows 11 versions 24H2 and 25H2, elevating systems to builds 26100.8457 and 26200.8457. Notable vulnerabilities include CVE-2026-32169, a critical flaw in Azure Cloud Shell with a CVSS score of 10.0, and CVE-2026-21536, a critical remote code execution vulnerability in the Microsoft Devices Pricing Program with a CVSS score of 9.8. Other critical vulnerabilities include CVE-2026-32191 and CVE-2026-32194, impacting Microsoft Bing Images, both with CVSS scores of 9.8. The update also addresses multiple Windows privilege escalation vulnerabilities and remote code execution vulnerabilities in Microsoft Office and Excel. Microsoft has warned of upcoming Secure Boot certificate expirations starting in June 2026 and has improved boot reliability related to BitLocker recovery issues. Users can install the updates via Settings → Windows Update, with a system restart required.

Winsage

May 1, 2026

April KB5083769 Windows 11 update causes backup software failures

The KB5083769 security update released in April 2026 has disrupted the functionality of various third-party backup applications on Windows 11 versions 24H2 and 25H2, primarily due to issues with the Volume Shadow Copy Service (VSS). Affected applications include Acronis Cyber Protect Cloud, Macrium Reflect, NinjaOne Backup, and UrBackup Server. Users have reported receiving an error message indicating that backups have failed due to VSS timeouts. Acronis has acknowledged the issue, stating it affects both Windows 11 Pro and Home editions, and warns of potential broader system issues. A temporary solution involves uninstalling the KB5083769 update or pausing Windows updates. Additionally, Microsoft has issued out-of-band updates for critical issues affecting Windows Server systems and warned that some Windows Server 2025 devices may encounter BitLocker recovery prompts after installing the KB5082063 update.

Tech Optimizer

April 15, 2026

Connecting .NET Lambda to Amazon Aurora PostgreSQL via RDS Proxy

Many organizations are modernizing legacy .NET applications while reducing database costs and enhancing scalability, particularly during migrations to AWS Lambda and transitions from SQL Server to Amazon Aurora PostgreSQL-Compatible Edition. The process involves connecting Lambda functions to Aurora PostgreSQL using Amazon RDS Proxy, with AWS Secrets Manager managing secure credential storage. The architecture includes a .NET Lambda function interfacing with Aurora PostgreSQL via RDS Proxy, which provides connection pooling to minimize database connection overhead. The solution requires a CloudFormation template to provision resources such as a VPC with private subnets, an Aurora PostgreSQL cluster, RDS Proxy, and Secrets Manager. The RDS Proxy is configured with parameters including PostgreSQL engine family, idle client connection timeout, and Secrets Manager secret. A Windows EC2 instance is provisioned, and access is facilitated through AWS Systems Manager Fleet Manager. The solution includes creating a sample table named "employee" in the database and a new .NET Lambda project that utilizes Npgsql for database connections. The Lambda function is deployed using the AWS CLI, and testing involves invoking the function and retrieving logs from Amazon CloudWatch. Finally, resources created during the process should be deleted to prevent ongoing charges.

Winsage

March 30, 2026

Microsoft’s March Security Update of High-Risk Vulnerability Notice for Multiple Products

On March 11, NSFOCUS CERT reported the release of Microsoft’s March Security Update, addressing 83 security vulnerabilities in products like Windows, Microsoft Office, Microsoft SQL Server, and Azure. The update includes eight critical vulnerabilities and 75 important ones, with risks such as privilege escalation and remote code execution. Key vulnerabilities include: - CVE-2026-26110: Microsoft Office Remote Code Execution Vulnerability (CVSS score: 8.4) - CVE-2026-26113: Microsoft Office Remote Code Execution Vulnerability (CVSS score: 8.4) - CVE-2026-26144: Microsoft Excel Information Disclosure Vulnerability (CVSS score: 7.5) - CVE-2026-23669: Windows Print Spooler Remote Code Execution Vulnerability (CVSS score: 8.8) - CVE-2026-24294: Windows SMB Server Privilege Escalation Vulnerability (CVSS score: 7.8) - CVE-2026-23668: Windows Graphics Component Privilege Escalation Vulnerability (CVSS score: 7.0) Affected product versions include various editions of Microsoft Office, Windows Server 2012 R2, Windows Server 2016, Windows 10, and Windows 11. Microsoft has released security patches for these vulnerabilities, and users are encouraged to install them promptly.

Tech Optimizer

March 18, 2026

Microsoft promises all-in-one database wrangling hub on Fabric

Microsoft has launched a new database management tool called Database Hub, which is part of its Fabric data platform. This tool allows for the management of multiple databases using a single SQL engine and serves as a centralized location for overseeing various database services, including Azure SQL Server, Azure Cosmos DB, Azure Database for PostgreSQL, SQL Server with Azure Arc, and Azure Database for MySQL. Currently in early access, Database Hub aims to provide a unified management experience across on-premises, PaaS, and SaaS environments. The tool will incorporate AI capabilities to enhance database management, featuring "agent-assisted" and "human-in-the-loop" approaches for analyzing estate-wide signals. Microsoft’s LLM tool, Copilot, will offer insights into the database estate's status, including aggregate health views and trend analysis. However, specific details on the Database Hub's database tuning and optimization capabilities were not provided. Additionally, a study from Carnegie Mellon University indicated that vector embedding algorithms could improve the performance of PostgreSQL services significantly. Microsoft has also launched various database systems, including a document database platform based on PostgreSQL and a distributed PostgreSQL database service. Other vendors like Databricks and Snowflake have introduced their own transactional database services within their platforms.

Tech Optimizer

March 12, 2026

Why Postgres® has won as the de facto database: Today and for the agentic future

The AI economy is projected to reach a trillion by 2028, leading 95% of major global enterprises to establish AI and data platforms within two years, although only 13% have succeeded so far. Successful integration of agentic AI requires moving away from outdated architectures to a cohesive data and AI approach. Currently, 81% of successful enterprises utilize open-source strategies, with over 40% standardizing on PostgreSQL. PostgreSQL's extensibility allows for the integration of diverse data types, essential for AI applications. It provides a unified database engine that mitigates issues associated with fragmented architectures. PostgreSQL benefits from a large independent developer community, which enhances its innovation and adaptability. To thrive in the future, organizations must abandon legacy systems and leverage PostgreSQL's capabilities for a sovereign data platform.