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 ...

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.

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.

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 only just officially released SQL Server 2019 at its Ignite conference in Orlando, Fla., but it announced some key changes to licensing a little bit earlier. Don't worry -- they're all ...

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 ...

According to Rikalous, installing Business Intelligence Development Studio is necessary. Upon installing SQL Server 2008 you need to select the Client tools option under the Client tools section of ...

In SQL Server 2014 Business Intelligence Edition, a SQL Server instance can use up to 128 gigabytes of memory. Additionally, this edition includes the Advanced corporate BI (Tabular BI semantic model, ...

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 ...

If you have a particular need for SQL Server, which the free Express Edition simply can't satisfy, then you'll be happy to hear that SBS 2003 client access licences are still valid in R2.