(Pinal Dave) When you are planning data platform consolidation, it is very important to track down the changes in the overall system performance after the actual migration is done. You should understand the differences in the configurations and performance of the instances and databases.

(Daniel Farina) There have been several tips about using bash scripting to help the SQL Server DBA working in a Linux environment. In this tip you will learn about the importance of pipes and redirections for bash scripting in Linux and its usage.

(Paul White) The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts

(Pinal Dave) One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)

(Rajendra Gupta) This article will review how to get information on your SQL database restore history, including the metadata in MSDB that can be queried, as well as value added tools and features to the group, sort, report and export this critical information.

(Chris Webb) Following on from my last post on attaching manually-created Common Data Model folders in Power BI dataflows, I was asked whether defining relationships between entities in the model.json file of the CDM folder results in relationships being created between tables in a Power BI dataset.

(Hannes du Preez) Using dm_db_index_physical_stats returns size and fragmentation information for the data and indexes of the specified table or view in SQL Server.

(Jack Vamvas) Question: How can I find the SQL Server Instances on a server using Powershell ? Either the local server or remote SQL Servers.

(Grant Fritchey) You absolutely need to know about the servers you have under management in your estate. You need to know about the databases. Uptime, performance, behaviors, errors, corruption and a much longer list of items that will frankly fill this blog post, are very important to you.

(Pinal Dave) This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.