The biggest feature in the SQL Server 2019 preview launched at Ignite is SQL Server Big Data clusters. Travis Wright, Microsoft's principal program manager for SQL Server, explains exactly what this ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...

Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. With data sprawled across on-premises infrastructure, cloud platforms, and edge ...

Regardless of the size of your organization, there's always a wide variety of items to keep track of in database systems like SQL Server -- user logins, data access, security protections and more.

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

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 before your next upgrade. 1. Should My ...

Docker containers are great for SQL Server development and test scenarios, as they allow database administrators and developers to deploy SQL Server instances within seconds. Users are able to spin up ...