(Hannes du Preez) SQL Server 2016 introduces the DATEDIFF_BIG function that allows you to obtain date differences between larger date ranges.

(Chris Webb) Many of my customers get the source data for their Power BI reports – usually Excel or csv files – sent to them as an email attachment on a regular basis.

(Pinal Dave) I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Server listed here:

(Kenneth Fisher) In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just confounding. The other day I saw the following error in the log:

(Clas Hortien) Microsoft offers its customers specific expertise to secure highest possible performance in the SAP system with the “SAP on SQL Server – Performance Tuning and Optimization Clinic” offering. It is based on many years’ experience of Microsoft engineers and consultants in the area of &#

(Rick Dobson) Our stock advisory newsletter has 50-day and 200-day moving averages in a SQL Server database on a set of stocks that we recommend our clients to watch.

(Pinal Dave) In my lab environment, I was testing a script to change service account and it worked fine. I had Always On configured on this SQL Server and soon I realized that after changing the SQL Server service account, the secondary replica went into a disconnected state.

(Mohammed Moinudheen) We have an on-premises SQL Server database and plan to migrate it to Azure SQL Database or to SQL Server on an Azure Virtual machine. Is there a tool we can use to check for any sort of compatibility issues before migrating?

(Jack Vamvas) In a Profiler trace you can see INSERT BULK statements , which are a mechanism for interface between SQL Server and a client bulk copy API.

(Melissa Coates) When working on big data systems, it can be very helpful to include file properties and other metadata directly within the data results. Capturing data lineage can come in very handy, especially if reconciling or troubleshooting issues (for instance, if retry logic occurred in the d