(Pinal Dave) Every consulting engagement is different and I get to learn new things. In this blog post, I will share what I learned during my recent Comprehensive Database Performance Health Check.
Tag: sql server
(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 . 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:
SQL SERVER – OLE DB Provider ‘Microsoft.ACE.OLEDB.12.0’ for Linked Server ‘(null)’ Returned Message ‘Unspecified Error’
(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.