(Sergey Gigoyan) In the previous article, we have discussed how the new features of SQL Server allows us to rewrite the old code in a more compact way. In this article, we will continue to demonstrate some other new features of SQL Server 2016/2017, allowing us to write shorter code for the same tas

(Pinal Dave) Just another day I received a question via email about how to Copy Data From SSMS Query Result to Excel? This is indeed a very simple question but trusts me not everyone knows everything and this blog is dedicated to learning new things – a complicated one or even a simple one.

(Chris Webb) I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn.

(Kenneth Fisher) Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently the least understood. Full backups are easy.

(Greg Larsen) With the introduction of SQL Server 2019, there is now a new, faster way to get a list of distinct values in a column.

(Edwin Sarmiento) We are exploring SQL Server Always On Distributed Availability Group as our disaster recovery (DR) strategy. We have multiple network connections to our DR data center and would like to utilize one of them specifically for the SQL Server Always On Availability Group data replicatio

(Hannes du Preez) You can transfer data with JSON in SQL Server. Based on an SQL query, you can output the results into JSON format.

(Thomas LaRock) Not a day, week, or month goes by without news of yet another data breach.

(Tibor Karaszi) Many SQL server installations does regular index rebuild or reorg in order to defragment indexes. One can question how much we really gain by doing this when using modern SANs, SSD, flashdisks, etc.

(Pinal Dave) During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database.