Reason No. 3 to upgrade to SQL Server 2008 R2: StreamInsight StreamInsight is the name for Microsoft's new complex event processing engine, which is implemented as a set of .Net classes.

Microsoft hasn’t announced when it expects to ship SQL Server 2022, but it’s common for new releases to arrive around the time of Microsoft Ignite, which is at the end of October this year.

Other improvements include persistent memory (PMEM) support in SQL Server 2019 for Linux, enabling SQL Server to bypass the file system for files on DAX formatted PMEM volumes. There are new TCP/IP ...

Joey on SQL Server So You Need To Move Off SQL Server 2016 As of July 13, SQL Server 2016 no longer has mainstream support. Your next steps as a DBA include understanding Microsoft's support model ...

Each version of Microsoft ’s SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask as your version hits the five-year mark: ...

As today's database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

Each version of Microsoft 's SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask as an agency’s current version hits the ...

If when installing SolidWorks, Microsoft SQL Server fails to install, first change block sizes and the instance name and see. More solutions here.

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Under SQL Server 7.0, for example, you can specify that logins — both successful and failed — be written to the Windows 2000 (or Windows NT) application log, which you view using the Event Viewer.