Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...
It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...
Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...
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 ...
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 ...
SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results