In this article, I am going to discuss How to Implement PIVOT and UNPIVOT in SQL Server with examples. Please read our previous article where we discussed Change Data Capture in detail. The PIVOT and ...

SQL Server jobs are used to regularly perform the same sequence of commands in your SQL Server database. This tutorial provides an example of how to create a SQL ...

In Oracle SQL, data transformation is often essential — sometimes you need to turn rows into columns, and other times, columns into rows. That’s exactly where the powerful PIVOT and UNPIVOT clauses ...

It's important to plan for security before you configure your replication topology. This tutorial shows you how to better secure a replication topology. It also shows you how to configure distribution ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the ...

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available ...

Hadoop has introduced a lot of agility into the world of analytics and data integration. Concepts such as schema on read and the radical flexibility of processing data stored in files have allowed ...