Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to ...

Inspiration: https://superuser.com/a/1555144/2119739 and https://blog.codeinside.eu/2019/07/31/sql-server-named-instances-and-the-windows-firewall/ For reference ...

在把Oracle查询转换为SQL Server的时候要特别当心一些不容易注意到的问题。我们知道，T-SQL是SQL Server的语言引擎，而Oracle的语言引擎却是PLSQL。这两种查询语言都对ANSI SQL-92标准进行了扩展以提供额外的支持力度。你所创建的应用程序几乎都要用到这些补充特性。

运行在老旧硬件或操作系统上的SQL Server故障转移集群，往往很难以无宕机方式迁移至现代系统。我之前就面对过这类需求，将一个由HPE SAN支持的实时SQL集群迁移至Windows Server 2022新服务器，同时须保证依赖该集群的应用程序零中断正常运行。以下是我们在完成这 ...

The surprise came when Microsoft SQL Server was announced as the DBMS of the year for 2016 by DB-Engines.com. For the 12 months of 2016, SQL Server experienced a steep rise in popularity as a search ...

Microsoft Corp.’s SQL Server has landed Solid IT GmbH’s database management software of the year award for 2016, beating out Oracle Corp.’s MySQL and the open-source PostgreSQL, which finished second ...