(Nat Sundar) How can we create a date dimension table in Power BI? We need data such as month name, year, financial quarter, etc. Also, how can we access this data directly with DAX?
Tag: sql server
Dynamic SQL Doesn’t Have To Be That Hard
(Denny Cherry) There’s a lot of misunderstandings about dynamic SQL out there. I have heard this from clients on occasion, and I see it from other consultants on their blogs. If done correctly, dynamic SQL is not difficult to use or troubleshoot.
SQL SERVER – How to Check if a Column Exists in SQL Server Table?
(Pinal Dave) Question: How to check if a column exists in SQL Server table?
Multi-Statement TVFs in Dynamics CRM
(Andy Mallon) If you’re familiar with supporting the database behind Microsoft Dynamics CRM, you probably know that it’s not the fastest-performing database. Honestly, that shouldn’t be a surprise–it’s not designed to be a screaming-fast database.
How to query prediction results from a data mining model in SQL Server Analysis Services
(Siddharth Mehta) SQL Server Analysis Services (SSAS) contains features for developing data mining models using various data mining algorithms for predictive analysis.
SQL SERVER – How to Identify Columns Used In A View?
(Pinal Dave) The views are very tricky. Sometimes they help performance and sometimes they negatively impact performance. Recently, during Comprehensive Database Performance Health Check, I realized that one of the view was the real performance killer.
Linux Administration for SQL Server DBA’s: Checking Network I/O
(Daniel Farina) You are a SQL Server DBA and you are new to Linux. You know that Microsoft has decided to expand SQL Server to Linux servers and you need to know how to check for network latency and I/O. In this tip I will show you some tools that will help you.
Creating Animated Reports In Power BI With The Drilldown Player Custom Visual
(Chris Webb) Last week I had the chance to do something I have not done before: build a Power BI report to be displayed on a big screen hanging on a wall.
Azure Analysis Services web designer
(James Serra) Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow developers to start creating and managing Azure Analysis Services (AAS) semantic models quickly and easily.
Creating an SSIS project
(Kenneth Fisher) Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open up Visual Studios 2015 or SQL Server Data Tools 2015 (SSDT is really just a set of modules added to Visual Studio).