(William Brewer) When the different teams that are involved throughout the life a database fail to reconcile their different roles and priorities, and so fail to cooperate, or work adaptively, the result is gridlock: databases defined as though carved in stone rather than by code and data. DLM offer

(Pinal Dave) When two SQL enthusiasts meet, often the conversation drifts to questioning each others understanding and implementation. Now, when two DBA’s meet it is always a great to see how the conversation goes because each carry a ton of baggage which can sometimes contradict too.

(Kris Wenzel) In this article find out how to find duplicate values in a table or view using SQL. We’ll go step by step through the process. We’ll start with a simple problem, slowly build up the SQL, until we achieve the end result.

(Koen Verbeeck) Power Query, an Excel add-in from the Power BI family, allows you to extract and manipulate data from various sources. When you define transformations on the data, it is possible that those transformations are sent back to the source, in order to improve performance.

(Chris Webb) As you probably know, whenever you are doing any kind of date or time-based calculations in DAX you should always have a separate Date table in your Power Pivot model. There are a number of ways of building these tables (see, for example, my Power Query query here) but they are all a bi

(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co

(Kris Wenzel) In this article find out how to find duplicate values in a table or view using SQL. We’ll go step by step through the process. We’ll start with a simple problem, slowly build up the SQL, until we achieve the end result.

(Koen Verbeeck) Power Query, an Excel add-in from the Power BI family, allows you to extract and manipulate data from various sources. When you define transformations on the data, it is possible that those transformations are sent back to the source, in order to improve performance.

(Chris Webb) As you probably know, whenever you are doing any kind of date or time-based calculations in DAX you should always have a separate Date table in your Power Pivot model. There are a number of ways of building these tables (see, for example, my Power Query query here) but they are all a bi

(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co