Power BI vs SSRS (2022-04-11)

SQLServerCentral Newsletter for April 11, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Power BI vs SSRS]( - [Oracle subquery caching and subquery pushing]( - [Flyway Branching Walkthrough]( - [From the SQL Server Central Blogs - Azure IoT Central]( - [From the SQL Server Central Blogs - KQL Series – how not to waste $ running ADX clusters]( Question of the Day - [Removing Text From All Rows]( The Voice of the DBA  Daily Coping Tip Commit to being more active this week 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. Moving Away From MySQL I like SQL Server as a database. I think it's very complete, solves most of my problems, and is easy to use in work. It costs money, but less than some others. It's also more complete to me than some of the open source databases out there. That being said, I think most of the top five or six relational platforms would work for me and I wouldn't hesitate to use them. I ran across [a post from Steinar Gunderson](//blog.sesse.net/blog/2021/Dec/05), who worked at Oracle on the MySQL team. It's on his last day there, and it's a bit of a why did he leave. I like that he notes he found a better opportunity, but he digs in deeper. Why did he look for a new opportunity? The answer seems to be that MySQL was a shockingly primitive piece of software, according to him. He felt there was lots of room for improvement and change, but people seem to like and accept what MySQL is and does. He is proud of what he has done, but felt that this was a product that was vastly inferior to other database platforms. That's interesting, because I think MySQL works fine and is in use in many situations. While there might be plenty of things that can be improved, I'm a practical guy. If the technology meets my needs, and those I can foresee, I see no reason to change. That being said, I wouldn't reach for MySQL to start a project. If it wasn't SQL Server, I'd lean towards PosgreSQL. There are a couple of examples in the post, and it's certainly a good post to write on your last day. If you published it when it wasn't your last day, it might quickly move in that direction. If you use MySQL, I'm curious what you think. If you don't, would you if SQL Server weren't available? Would you learn MySQL for a new job? Or are you a die-hard, this is my platform kind of person? Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Power BI vs SSRS]( Daniel Calbimonte from SQLServerCentral Power BI vs SSRS Introduction to Power BI vs SSRS ... [External Article]( [Oracle subquery caching and subquery pushing]( Additional Articles from SimpleTalk In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery. [External Article]( [Flyway Branching Walkthrough]( Additional Articles from Redgate We'll step through the process of using Flyway Teams to support database branching and merging, where the team split the development effort into isolated, task-based branches, and each branch has its own development database. [Blog Post]( From the SQL Server Central Blogs - [Azure IoT Central]( James Serra from James Serra's Blog This is a short blog to give you a high-level overview on a product called Azure IoT Central. I saw this fairly new Azure product (GA Sept 2018) in... [Blog Post]( From the SQL Server Central Blogs - [KQL Series – how not to waste $ running ADX clusters]( HamishWatson from The Hybrid DBA's Blog This blog post is based on my personal experience running an Azure Data Explorer (ADX) cluster. I was doing a presentation for Data Platform Summit in India, I spun...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Removing Text From All Rows In a database, I have some data that describes pieces and parts for a custom built PC. I have a sample of the data in this CTE: WITH ctePC AS ( SELECT expression FROM ( VALUES ('\1\cpu') , ('\1\ram') , ('\1\ssd') , ('\1\gpu') , ('\1\cooler') , ('\1\fan')) a (expression) ) Each part has a hierarchy value separated by backslashes and then the name of the part. If I wanted to get the name of each of the parts, which code should I use to complete the query? 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) Synapse Serverless How many serverless SQL pools can you have in an Azure Synapse Workspace? Answer: 1 Explanation: There is one serverless SQL pool in an Azure Synapse Workspace. This is created automatically and always available. Ref: Synapse Terminology - [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 [Measuring Ad-hoc workload on a per database level]( - Ok so I need to see how much workload on a server (per database) is ad-hoc. Gut feel its high for one db in particular . is the following a valid way to determine this or is there a better approach ? SELECT Convert(INT,Sum ( CASE a.objtype WHEN 'Adhoc' THEN 1 ELSE 0 END) * […] [Slow Sql server]( - Hi All, We have a QA server on which a bunch of databases are hosted. It hosts like 20-25 databases. All these databases are not active all the team. At set of databases indicates each environment like QA1 , QA2 , QA3 etc... In each set , there is 1 big db which is around […] SQL Server 2016 - Development and T-SQL [Extracting the clientapp for the victim of a deadlock report]( - Given a deadlock report, I need to extract the clientapp that was the victim process. The query I've written works and is below: DECLARE @path [nvarchar](MAX) SELECT TOP 1 @path = REPLACE([path] + '\system_health*.xel', '\\', '\') FROM [sys].[dm_os_server_diagnostics_log_configurations] WHERE [is_enabled] = 1 DECLARE @data TABLE ([deadlock] , [exec_time] [datetime]) INSERT INTO @data SELECT CONVERT(XML, [event_data]).query('/event/data/value/child::*') […] SQL Server 2019 - Administration [Bringing Data from SQL Server to AWS automatically]( - We have a requirement where we want to bring data present in SQL Server to AWS - SQL Server (i.e. AWS RDS). At present the data is present in on-prem SQL Server and on 1st of every month, the data is then transferred from SQL server to excel sheet. The excel sheet contains 7 different […] [Windows 11 Pro]( - Hi everyone I just got a new machine. It is running Windows 11 Pro. I am trying to install SS2019 but I am coming across issues. I am getting below error: "Oops... A required file could not be downloaded. This could mean the version of the installer is no longer supported. Please download again from […] SQL Server 2019 - Development [Trying to re-id a database table and getting error on the first select keyword]( - I have a small table ( < 1000 lines). I deleted the first entry ID 1 as it was invalid. I know it is not necessary to Re-ID it, however I want the first entry to be ID 1 not ID 2. I tried the following script; CREATE TABLE Codelines_backup AS SELECT ID, Rail_Road, NCS_Codeline, […] [Do you dream about SQL Server and things IT?]( - Even though I retired 12 years ago it seems that databases and IT in general are so much a part of my life they are even heavily in my dreams. While you could wish to dream of beautiful women such as my dear wife, fabulous wealth, and magical vacations, most of my dreams involve my […] [Update a sql_variant column]( - Trying to update a sql_variant column gets me a conversion error I dont understand. Can someone see/tell me, what I am doing wrong... --drop table #test create table #test (test sql_variant) insert into #test values('1234X ') SELECT SQL_VARIANT_PROPERTY(test, 'BaseType') from #test --varchar update t set t.test = CASE WHEN SQL_VARIANT_PROPERTY(t.test, 'BaseType') IN ('char', 'varchar', 'nchar', […] [Question on last valid Date in the system]( - Hi Experts, I have several more than 60+ Dates and I need to know which is last valid date for a particular record ? All the timers are extracted in a row for a particular record. [Converting varchar to Int for date difference]( - Hi Experts, Constraints: I do not have create permissions and I am learning This is my code Basically testing to fix the T-SQL putting junk 1900 dates and if valid then find the difference between FADate and TDate Unfortunately, even after trying to convert the varchar to Int using convert(int, a.FAdate) I get conversion error. […] SQL Azure - Development [Self-Service BI (Synapse and PBI)]( - Dear Experts, We have created a MDP (modern data platform) composed of : Azure Datalake Synapse PBI ADF Data Bricks In synapse, we have our stagging area (1-0-1 with the ADLS2) and our dimensional modeling, and then, we import different datasets into PBI. On top of that we have our PBI reports that connect to […] Amazon AWS and other cloud vendors [AWS S3 with video editing?]( - I'm looking for a solution where I can add the cloud storage as a shared network drive or folder on my PC and then directly edit heavy videos from the cloud via my connection. I have a 10 Gigabit internet connection and all the hardware to support that amount of load. However it seems like […] General Cloud Computing Questions [Aws reporting question]( - Looking for an idea / workflow to automate reporting for system manager nodes . I know I can get a list of nodes and also get a list of running ec2 instances but what I want is to get a list of the running instances rhat are NOT showing up as managed nodes (so ec2 […] Azure Machine Learning [performance management / other gotchas]( - I'm moving into a project where ML will be a component, primarily it will be as a DBA although I do have some DEV (SSIS / Tsql) experience. I'm wondering are there any good resources yet on how to admin MS ML on SQL Server , I'm finding a lot of info on how to […] Analysis Services [Error when trying to browse dimension/role, but not when browsing the cube]( - Ahoi, i have an annoying problem since upgrading vom 2016 to 2019. I have users modifying my the roles in my multimendionsal project. The users have role access to one of the cubes and can browse it using: SSMS/Excel WITHOUT ANY RESTRICTIONS But they can not browse the dimensions, even though they can browse the […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -