Microsoft delivered fixes for issues affecting everything from Windows to Office, .NET, and SQL Server, and several patches that should be deployed ASAP. Microsoft this week released 139 updates ...

Description: Script is creating objects for monitoring of replication subscriptions health state. Very simple solution for sending you emails when some subsciption is not running or containing warning ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

The increasing adoption of AI technologies is presenting new challenges for our customers’ data estate and applications. Most organizations expect to deploy AI workloads across a hybrid mix of cloud, ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

How much time elapses between a transaction being committed at the Publisher and the corresponding command being inserted in the distribution database at the Distributor. How much time elapses between ...

From performance to programmability, the right database makes all the difference. Here are 13 key questions to guide your selection. Picking the “right” database can often be critical to the success ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...