(Prashanth Jayaram) In this article, we’ll walk-through the concept of the SQL Order by clause and understand how the SQL engine works with the ordering result in a query.

(Kenneth Fisher) We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 server to another.

(Manoj) 1. Open RUN by pressing Windows + R keys, type powershell command and hit Enter.

(Nai Biao Zhou) We live in a world of data. Data are the facts and figures that are collected to make a decision [1]. Companies who use Microsoft technologies usually store their data in SQL Server databases. To extract business values from these data, we usually apply statistical techniques.

(Glenn Berry) Microsoft has a number of security features in SQL Server 2017 that are useful for different purposes, depending on what you are trying to protect and what threat(s) you are trying to protect against.

(Robert Dorr) SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents:

(Pinal Dave) There are many situations where you have to create a linked server to Microsoft Excel and read data from there.

(Jason Brimhall) Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to the tool – sort of. Now we have the power to run traces on SQL Server via ADS.

(Derek Colley) Your development, QA and production database environments are out of synchronization. Your present solution relies on a mix of scripts and manual actions to periodically restore production downstream.

(Pinal Dave) In recent past, while doing Comprehensive Database Performance Health Check I encountered an interesting issue. In this blog, I am sharing my knowledge about how to clean up the SSISDB database using the script.