(Tim Smith) We’ve been experiencing longer transaction latency with data for our near real-time reports, which require precise times for the data to appear for the reports that we send to our clients.

(Jack Vamvas) Question: Do you have a powershell script to backup SQL databases on a single SQL Server Instance , and direct them to a network share or a local drive? Also , I’d like an email notification with a screen output sent to my email box.

(Glenn Berry) A number of ongoing and upcoming developments in software, hardware, and storage technology are shaping up to make the next twelve to eighteen months an ideal time to migrate from a legacy version of SQL Server to a modern version of SQL Server.

(Greg Larsen) There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data in my database will contain unprintable characters erroneously.

(Pinal Dave) One of my clients was doing a remote installation of SQL Server via command prompt. During the testing phase, they encountered an error. In this blog, we would learn how to fix error The Reporting Services catalog database file exists.

(Kenneth Fisher) Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z permissions. And all too often the conversation goes like this:

(benjamin perkins) I am updating, or should I say, re-coding a website I have from ASP.NET Web Forms (aspx) to ASP.NET Core Razor Pages (chtml). The database it connects to only has a global admin, full access user identity.

(Jayendra Viswanathan) I came across Graph processing in SQL Server which to me is an advanced version of using Common Table Expressions (CTE). SQL Server offers graph database capabilities to model many-to-many relationships.

(Pinal Dave) One of my clients reported that they are seeing below error in SQL Server ERRORLOG. He noticed a strange error of the network packet.

(Mohammed Moinudheen) We have an on-premises SQL Server database and we have used the Data Migration Assistant (DMA) to check for any compatibility issues before migration to Azure SQL database. Is it possible to use this tool to perform the actual migration of the database to the new target?