MDX in Power BI tutorial (2022-11-07)

SQLServerCentral Newsletter for November 7, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [MDX in Power BI tutorial]( - [SQL Server Indexes to Improve Query Performance]( - [Sign up to PASS Data Community Summit 2022]( - [From the SQL Server Central Blogs - The SQL Server Central Casino Party #SeattleSummitMoments]( - [From the SQL Server Central Blogs - What can you do with a SELECT statement without a FROM clause?]( Question of the Day - [The Assert Transformation]( The Voice of the DBA  Daily Coping Tip Identify three things that give you hope for the future I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. DevOps is Culture DevOps is a culture shift in your organization. Technology enables things inside of this culture, but the culture is important. If you don't know how to build a new culture and support individuals as they adopt it, often you're just renaming an existing broken process inside your organization. Often, I think the failure to reach the efficient levels of a Spotify, Capital One, or any other DevOps success story is because of a failure of management to change culture. There are any number of anti-patterns for organizations wanting to adopt DevOps. Renaming teams without changing how they work together, including incentives and punishments, doesn't help. Just buying technology without process and culture is just spending money on new toys. Keeping your existing organizational constraints in place without encouraging and supporting teamwork, changing incentives, eliminating silos/fiefdoms for managers will ensure that you will struggle to make a digital transformation that enables your organization to realize a return on their efforts. What things do help with culture change? Certainly, many changes start with a team or two, learning about how to build a better software pipeline, both with better code and more automation. They have to be allowed to fail fast, make some mistakes, and review issues without blame. Management must support this. We need to optimize systems, meaning the flow of code from developer to production system, without optimizing the effort in any team. People need to put theie name on work, owning failures, and celebrating the success of others. Collaborate and pitch in to work together, regardless of the title, position, or responsibility you have been assigned. If someone needs help, they need to be supported and not punished. We need psychological safety to do the best we can, but understand we all need to ask for, or be ready to give, help at some point. DevOps is teamwork. It's coordinating and collaborating to agree on the best code and process that gets code to production quickly. Safe, secure, performant, and high-quality code of which everyone is proud. If we're not, then we ought to be working together to make the code better or agree an exception is allowed for some reason. Above all, we need to respect the autonomy of individuals and teams. Trust them to get the work done their way and take responsibility for it. Most people are accountable, especially when they can accept and help fix their mistakes without punishment. We all make mistakes, so let's do our best to move forward and help everyone avoid repeating mistakes with learning, not yelling. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [MDX in Power BI tutorial]( Daniel Calbimonte from SQLServerCentral Learn a bit about MDX and how you can incorporate it into your Power BI reports. [External Article]( [SQL Server Indexes to Improve Query Performance]( Additional Articles from MSSQLTips.com In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance. [External Article]( [Sign up to PASS Data Community Summit 2022]( Additional Articles from Redgate There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE. Register now. [Blog Post]( From the SQL Server Central Blogs - [The SQL Server Central Casino Party #SeattleSummitMoments]( Steve Jones - SSC Editor from The Voice of the DBA Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of... [Blog Post]( From the SQL Server Central Blogs - [What can you do with a SELECT statement without a FROM clause?]( Kenneth.Fisher from SQLStudies Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  The Assert Transformation What does an Assert Transformation in Azure Data Factory do? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) The Azure Database Timezone How can I check the current timezone of an Azure SQL Database or a Managed Instance from a client? Answer: SELECT CURRENT_TIMEZONE() Explanation: CURERNT_TIMEZONE() is a function that is available in Azure SQL Database and Managed Instance to give you the current timezone of the instance or server. For an Azure SQL Database, this is always UTC. Ref: CURRENT_TIMEZONE - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Uninstalling SQL 2012 Native Client breaks Failover Clustering]( - Is anyone aware of issues where uninstalling SQL 2012 Native Client breaks Failover Clustering? We were recently asked to remove unsupported software from our servers and the list included SQL 2012 Native Client. Version 11 was installed, so we removed it from test & dev servers without any issues. When it came to the Live […] [Log full error 9002]( - Hi Experts. I want to call a sql agent job when 80% of the Transaction Log file is full. I wanted to do some data collection when the log is getting full. How to do it? Thanks, Bob SQL Server 2016 - Administration [Last login for user on spesific table]( - Hi Is it possible to get a report for each table in a databse of who last viewed, updated, delteted and so on ? I know I can get last login to a databse, but I want to check what table for last login for that user [WinRm run Invoke-ProcessPartition : A connection cannot be made]( - I have a script which is used to connect to a remote SQL Server. It works well when in local Windows environment. However, when I run it use winrm on another server, this exception happens: Invoke-ProcessPartition : A connection cannot be made. Ensure that the server is running CategoryInfo : NotSpecified: (:) [Invoke-ProcessPartition], ConnectionException FullyQualifiedErrorId […] SQL Server 2016 - Development and T-SQL [Table Header with Dynamic Dates]( - Hello, I need to create a dynamic table that produces a Date Column Header based on Date parameters entered, is this possible? My table is as follows, followed by the desired results: CREATE TABLE #t (CustID int, StaffID int, JobID int, Dt datetime, Units money) INSERT INTO #t (CustID, StaffID, JobID, Dt, Units) VALUES (101, […] SQL Server 2019 - Administration [Sqlagent data transfer issue]( - I am not an sql person but have been asked to investigate strange behaviour when transferring large amounts of data from Linux to windows using sqlagent.exe. wireshark seems to suggest that for every packet sent, an ack is returned and appears to be ignoring tcp window size. Pic below and any advice/pointers would be great. […] [Fix for SSPI context error uses RC4 - any alternatives?]( - Hello experts, I've been trying to resolve an issue that seems to happen when SQL Server 2019 runs on Windows Server 2019. This may be actually an issue with our Systems-mandated security settings to lock down the servers, but I am wondering if you have some advice for other ways to work around the issue. […] SQL Server 2019 - Development [Multiple Database Deployment using DACPAC]( - Dear All, I am able to deploy single database using DACPAC and VS Solution ,Post deployment scripts .But now I have to deploy multiple databases to same instances .Can you please guide how to do that using DACPAC. Do need to create DACPAC and VS solutions for each database ? [Trying to go remote through a Cox Technicolor Modem/Router]( - I'm really not sure how to ask or what to ask for. This is NOT an Openvpn question. This is about accessing my SQL Database remotely. So does anyone access their home computer from a laptop in another location not using Openvpn? Below is my setup and situation. My setup: Windows 10 Pro Sql Server […] [Replace value from]( - Hi guys I hope everything's ok with all of you I have this example to do it in SQL. I want all characters after the space between. like this Please beware the number of characters. The ideal would be something like "give all characters from space to the right" I hope I was clear. Thanks […] SQL Azure - Administration [Unable to Connect to Azure PaaS Instance using SSMS 18.x]( - Good Morning Team, When we try to connect to Azure PaaS instance using SSMS 18.x from our VDI's; we are unable to connect and receive Error Message 10060. The same Azure PaaS Instances are reachable from our Azure VM's using SSMS without any issues. However on the VDI's; In SSMS->Additional Connection Parameters; if we specify […] Reporting Services [Is it possible to view (display) a Varchar(max) saved in in a Table.]( - I have an old database sql server 2008R2 from Microsoft Dynamics CRM 2011 which users need to view old data. I have been able to recreate searches for entries however have stumbled on one problem. 1 table contains documents/spreadsheets/messages/text etc stored as a varchar(max) with a filename and a mimetype. [MimeType] [nvarchar](256) NULL, [DocumentBody] [varchar](max) […] [Adding report inputs to history by extension or js]( - Is there a way to add all queries/inputs you queried with to be added to the normal browser history so you can look through them the other day?? And go back and forward at anytime? SSRS 2012 [Repeating Rectangle/Tablix]( - Hi there, I'm trying to enable a rectangle or tablix to repeat on every page i.e like an invoice but I don't want it to be in the header. Even when I set to repeat on pages to true it still won't repeat. Is there another way to do this? Thanks in advance Liam General [What's been your most favorite/fun project you've worked on?]( - I'm looking for something fun to make. I love learning about all the intricacies of programming and how something was made like RCT2 or small programs that made you money without knowing it would. What's coolest thing you've programmed?   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -