If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own ...

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

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

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

We used PowerShell to get information on a single server. This time, how to get info on several of your servers. Last time, we built a PowerShell script to get server information. It used SQL SMO and ...

And, despite some misperceptions, DBAs may employ many of the same tools within their SQL Server environments, whether on Linux or Windows. Azure Data Studio, for example, is a cross-platform tool for ...

SQL Server newbie here, sorry... I have a number of views that I want to give the same permissions to, to a number of users. I can go to each view and specifically add permissions to each user or I ...

“The next frontier is all about uniting the power of the cloud with the power of data to gain insights that simply weren't possible even just a few years ago,” Kummert said. “Microsoft is committed to ...

I am working on an intranet site for about 50-100 users (with plans for expansion to several hundred), with the databases being stored on SQL Server 6.5. Right now, if I create a new database, it's ...