Artificial Intelligence with Power BI (2022-12-19)

SQLServerCentral Newsletter for December 19, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Artificial Intelligence with Power BI]( - [SSIS Bad Habits: Decreasing SSIS Package Performance]( - [Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back]( - [From the SQL Server Central Blogs - New Database Job – The 6 Month Plan]( - [From the SQL Server Central Blogs - SQL Homework – December 2022 – What’s new in SQL Server?]( Question of the Day - [Recursive Triggers]( The Voice of the DBA  Daily Coping Tip Give kind comments to as many people as possible today 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. The SPU Ever since I heard about the SQLOS and all the work that went into producing an operating system for SQL Server inside of the host OS, I've thought that perhaps there might be value in specializing the environment for a database platform. Given the importance of databases, especially relational ones, and the need to get every bit of performance out of them, I wondered if we wouldn't see a version of SQL Server that is installed directly on the hardware, without a host OS. In some sense, I guess that's what a PaaS database is in Azure, but I thought we might see that for the download-and-install version. Instead, maybe there's a better way to improve performance without requiring SQL Server (or Oracle, PostgreSQL, etc.) to implement some of the OS features they'd need. Perhaps we could change the hardware around and use a [SQL Processing Unit]( (SPU). The SPU is another specialized chip. Like a GPU for graphics, or even some of the other chips that are made specifically for mobiles, storage, or networking, this one would be focused on database needs. Apparently, there are a few companies that are researching how they might build chips that focus specifically on the types of computations that data analysis requires. I don't know how practical this is, or whether we'd see any major database vendor attempt to port to a new chip. Perhaps they'd add instructions that could use one of these chips, similar to how a GPU can offload work. That might seriously improve performance, something that a lot of our customers would appreciate. Especially if this is without spending a lot of developer time rewriting old code. That's not to say that developers shouldn't learn to write better code. They ought to, mostly so that their initial attempt at producing reports or batches of data handles a wide variety of data values and workloads without stressing the hardware. More efficient code is always the best way to attack any problem. Even if you had a very efficient SPU, chances are that your workload will still grow to overwhelm the hardware at some point, especially if the number of users grow. Monitoring helps find problem queries, but it's up to developers to change their habits, grow their knowledge, and produce better code sooner. Then we can use hardware to deal with the large numbers of users that need to access the system. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Artificial Intelligence with Power BI]( Ajay Kumar from SQLServerCentral Get a brief introduction to using the AI features in Power BI. [External Article]( [SSIS Bad Habits: Decreasing SSIS Package Performance]( Additional Articles from MSSQLTips.com This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided to help improve performance. [External Article]( [Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back]( Additional Articles from MSSQLTips.com Learn how to control which SQL Server transaction will get rolled back when a deadlock occurs by using DEADLOCK_PRIORITY. [Blog Post]( From the SQL Server Central Blogs - [New Database Job – The 6 Month Plan]( Tracy Boggiano from Database Superhero’s Blog So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects The post New Database Job... [Blog Post]( From the SQL Server Central Blogs - [SQL Homework – December 2022 – What’s new in SQL Server?]( Kenneth.Fisher from SQLStudies SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  Recursive Triggers How do I allow direct recursive triggers to fire? With direct recursive triggers, I mean an AFTER trigger that fires because of a data modificati0n and inside the trigger, there is another data modification to the same table, which would cause the trigger to fire again. 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) Migrating to Synapse Using the SQL Server Migration Assistant (SSMA), from which platforms can I migrate a database to Azure Synapse Analytics? Answer: Oracle only Explanation: The only platform for which the SSMA supports Azure Synapse as a target is Oracle. Ref: SQL Server Migration Assistant - [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 [Installation error]( - SQL Installation is got failed with error 1603 and no sql is installed previously .How to fix this and start the installtion again .. Administration - SQL Server 2014 [Rectify Error]( - Hi Experts, How can I rectify the below error in SQL Agent log. [298] SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001] [298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001] How can we identify when client is trying to connect. This […] SQL 2012 - General [Upload only new files from SFTP Server]( - Hi all, I'm working with SSIS'12 and I should create a package which will upload from SFTP only new files. It means that the process should run each 1 hour and check if we uploaded the files and if no, we should upload it. Could you please help me how to implement it? [SS 2012 login popup behind main window]( - I'm using SS 2012 on a Win 10 Pro laptop with a second display. Suddenly when I start Management Studio the login popup opens BEHIND the main Management Studio window, and the main Management Studio window is frozen so I can't move or kill it. I have use Task Manager to terminate the application. If […] [Looking for help installing Sql express 2012]( - So I normally have no issues with installing this software but I popped open some new systems that came in. Windows 10 pro x64 on HP probook6450b. All solid state drives, and i5 processors. All attempts to install express 2012 fail. I can launch the program without issue. Select fresh install. But while going through […] SQL Azure - Development [Substitute of trigger in a merge statement.]( - Hello Everyone I hope you all are rocking. My question is regarding the merge statement. I am using Microsoft SQL Azure (RTM) - 12.0.2000.8. I am transferring users' data from one table to another table with some manipulation of data. Everything works fine without any issues. Now I have another table that maps the user […] SQL Azure - Administration [Move Azure SQL Managed Instance across subscriptions]( - Hi, Is there a way ( with less downtime ) to move Azure SQL Managed Instance across subscriptions? One way to do it would be to take a COPY-ONLY backup to an URL and then restore to the new subscription. But this can require significant downtime for cases where the database is huge. General Cloud Computing Questions [Silly Cloud computing story]( - A few years ago I was interviewing for a position. Roughly 2016. I was speaking with the IT director (fairly small company, located in the N Chicago suburbs). One of the things he told me was that when he joined, the company was using a cloud service based in Texas. The first thing he did […] Reporting Services [RS.exe is having issue while subscription is completing the report.]( - Hi We have a report that is running via rs.exe utility and it errors out, but when we execute it via subscription it is completing. The error is below, the report is executing an oracle stored procedure  runningjobs!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: RunningJobContext.IsClientConnected; found orphaned request 35ybh2mbnhiom22ugojqi52l processing!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: DataPrefetch abort handler called for Report […] SSRS 2016 [List all data sources]( - Hi is there a way to list all the data sources in SSRS 2016, and if possible which reports use them? Cheers Alex Disaster Recovery [log shipping monitor instance]( - I tried to setup log shipping on two data centers. Server A in location A, serverB in nearby location B. On the server there are multiple databases, I created the first logshiping database, I created the monitor instances on ServerB. It works well. I then tried to create another log shipping for another database, when […] SQLServerCentral.com Test Forum [Page 2 test - Dec 2022]( - a test thread to see what happens when we get to page 2. [Page 2 test - Dec 2022]( - a test thread to see what happens when we get to page 2. SQL Server 2022 - Administration [SQL 2022 - Contained AlwaysOn restore]( - Hi,  Ive been playing around with the new SQL Contained AlwaysOn, and its looking really promising so far! But one thing im missing from the documentation / my PoC, is how to restore the master database of the contained availability group. Like we normally can do, with a bit of twerks.  The best […] SQL Server 2022 - Development [get a substring value from string]( - Hi, I am new to SQL Server. I have table create table tmp1 ( serialnumber varchar(500) ) insert into tmp1 values('1232132|2343345435|34543534534534|3344562534'),('23243|23423432432|34543534534235|3344562534') select * from tmp1 I need to fetch the value before the last pipe symbol the output would be as below 34543534534534 34543534534235 anyone can help   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -