(Greg Larsen) The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups.

(Koen Verbeeck) SQL Server 2016 comes with many brand new features for Master Data Services (MDS). One of those new features is the ability to model a many-to-many relationship in a derived hierarchy. In this tip, we’ll go over the necessary steps you need to take to set-up such a hierarchy.

(Pinal Dave) One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error.

(Kenneth Fisher) I ran into an interesting error the other day while doing a partition switch.

(James Serra) The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data science. It has many popular data science and other tools pre-installed and pre-configured to jump-start building intelligent applications for advanced analyti

(Grant Fritchey) To get started with SQL Server, you need to install it. However, I’m not going to teach you how to do a SQL Server install.

(Chris Webb) When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need:

(Selvar) Recently, i was working on a deployment where we need to configure SQL Server Reporting Services 2016 with ARR so that reporting services is exposed over the internet without exposing the machine itself.

(Denny Cherry) Recently Microsoft Azure introduced the ability to have multiple front end IP addresses on an Internal Load Balancer. This allows for

(Manoj Pandey) If you are new to PowerShell like me then you would have encountered this ans similar errors.