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

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

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

A small social media poll from Visual Studio guru Mads Kristensen split respondents over whether the IDE should add more database tooling, while the discussion quickly turned to existing SQL project ...

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

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

If you’re looking for proof of the hybrid, multi-platform nature of today’s data environments, look no further than many SQL Server sites. Linux—not too long ago seen as a competitive platform to all ...

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