(Rick Dobson) Demonstrate techniques for use of SQL Server Windows functions to compute simple moving averages. More specifically, highlight the use of the Windows aggregate avg function for computing simple moving averages for one entity at a time or concurrently for multiple entities.

(Kenneth Fisher) I get asked this every now and again, along with the companion When was the last time this login was used? It’s a pretty easy question to answer but there are some caveats.

(Pinal Dave) The reason, I like SQL Server as a product is that there are multiple solutions to one problem and one can use the method they find most convenient. Almost three years ago, I wrote a blog post about how to solve the error: Configuration Manager – Cannot Connect to WMI Provider. You Do N

(Daniel Janik) I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from Aug ‘19; though, I haven’t seen any release notes on corruption in Azure.

(Sergey Gigoyan) In a previous article, we discussed the History Cleanup Task, which cleans old historical records in the msdb database generated by Maintenance Plans, Backup and Restore operations and SQL Server Agent Jobs.

(Pinal Dave) One of my clients enabled query store features to perform some troubleshooting by themselves. Since they were not able to find the cause and fix the issue, the contacted me via my famous service Comprehensive Database Performance Health Check.

(Matteo Lorini) The simple task of helping the line of business to load, read and analyze their data can sometimes be a challenge because of the division of roles and responsibilities that may prevent business users from having direct access to SQL Server.

(Pinal Dave) One of my clients contacted me for assistance with whom I worked earlier to perform a Comprehensive Database Performance Health Check. They were trying to upgrade SQL Server 2016 to SQL Server 2017 in a clustered environment. First the upgrade passive nodes, it went fine.

(Bojan Petrovic) This is the fourth article in a series of learning the CREATE VIEW SQL statement. So far, we have done a great deal of creating and altering views using T-SQL. In this last part, I want to take a big look at how to work with indexed views.

(Eduardo Pivaral) IoT (internet of things) allows any electric-powered device to have access to the internet, so we can monitor, control and communicate with such devices.