Create Your First Pipeline in Microsoft Fabric (2023-08-02)

SQLServerCentral Newsletter for August 2, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Create Your First Pipeline in Microsoft Fabric]( - [PASS Data Community Summit 2023]( - [Modifying MySQL data from within Python]( - [From the SQL Server Central Blogs - How do I tell if a user is orphaned or actually created without a login?]( - [From the SQL Server Central Blogs - Steps to Have a Service Principal Take Over a Dataset in Power BI When Using Data Gateways]( - [Azure SQL Revealed: A Guide to the Cloud for SQL Server]( Question of the Day - [Changing the Default]( The Voice of the DBA  Constitutional AI I will admit that I don't know a lot about AI (Artificial Intelligence) systems and how they are built. I've been [playing with them a bit]( and haven't been overly impressed with the results. I think some of this is that lots of the nature of my work is creative and I'm both used to being creative and I find the AIs less creative. And less accurate. And require a lot of editing. From my understanding, a lot of the models behind AI systems (chatbots, recommenders, etc.) are built with humans giving them feedback on their responses in what's known as RLHF (Reinforcement Learning from Human Feedback). Essentially paid (often low paid) people that help to "guide" the AI into responses that are useful. I don't quite know how that looks, and I certainly don't want a job doing that. Definitely not if it's looking at a lot of UIs like the one in [this article](. Can you imagine being paid to read things like this and then try to rank them? I can't imagine they keep getting great input from evaluators across the day. Maybe 9am-10am, but I'd bet the 4pm-5pm responses are quick clicks. There was [an article]( about a company trying something different: constitutional AI training. There's [a better description]( on the Anthropic website. It seems in this case they are creating some principles and limited human feedback, but then relying on an AI to give feedback to another AI? Or itself? I have to admin that I'm not completely sure of what happens here. Ultimately, I like the idea here, but I think the idea of a single LLM/AI model that suits every situation, or one that works in every geography doesn't make sense. We have different thoughts among people and different cultures all over the world. I'd expect that we might have different types of AIs in different situations or environments. The one that helps decide how to deal with nuclear safety likely needs to be different from the one governing traffic signals. I certainly don't want [one TruthGPT]( to be the one true voice on all things. The idea of AI systems, assistants and more seems more complex and more strange than anything I'd have imagined from reading science fiction. As with many things, the reality is far different from the speculation I've had about how I would respond or want a system to behave. I think that's the nature of science fiction; it picks specific situations and tailors the story to fit. The real world is much more messy. I don't know where we go, but I'm curious as many of you have had more exposure to AI. Is it helping? Hurting? Useful? Are you excited or worried for the future? I'm curious what you think, mostly because I'm not sure what I think. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Create Your First Pipeline in Microsoft Fabric]( arindamxs from SQLServerCentral Learn how to get started with a Microsoft Fabric pipeline. [Technical Article]( [PASS Data Community Summit 2023]( Additional Articles from PASS Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates. [External Article]( [Modifying MySQL data from within Python]( Additional Articles from SimpleTalk In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector. [Blog Post]( From the SQL Server Central Blogs - [How do I tell if a user is orphaned or actually created without a login?]( Kenneth.Fisher from SQLStudies One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading [Blog Post]( From the SQL Server Central Blogs - [Steps to Have a Service Principal Take Over a Dataset in Power BI When Using Data Gateways]( Angela Henry from SQL Swimmer A little background for those new to using Power BI and Data Gateways. If the data source for your Power BI dataset lives on-prem or behind a private endpoint,... [Azure SQL Revealed]( [Azure SQL Revealed: A Guide to the Cloud for SQL Server]( Site Owners from SQLServerCentral Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Changing the Default I have run this code in SQL Server 2019, which has no objects in the dbo schema: CREATE USER apiuser FOR LOGIN apiuser WITH DEFAULT_SCHEMA=webapi GO ALTER ROLE db_datareader ADD MEMBER apiuser GO CREATE TABLE webapi.states (stateid INT NOT NULL CONSTRAINT statespk PRIMARY KEY, statecode VARCHAR(2), statename VARCHAR(20)) GO INSERT webapi.states (stateid, statecode, statename) VALUES (1, 'AK', 'Alaska') GO I log in to a second query window as apiuser and run this code: SELECT TOP 10 s.statename FROM states AS s; GO This works and I get Alaska returned. I now run this code in my first, administrative window, knowing there are no objects in the Sales schema: ALTER USER APIUser WITH DEFAULT_SCHEMA=Sales GO I return to my second window, which is still logged in and connected to the SQL Server. What happens when I run this code? SELECT TOP 10 s.statename FROM states AS s; GO 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) What will be inserted? I query my sys.identity_columns and sys.objects views and get this data back (only a few columns shown): TableName ColumnName last_value increment_value DataWithTime myid 1002 1 I run this code: INSERT dbo.DataWithTime (Mydata, mytime) VALUES ('F', NULL) If I query the table for "F", only one row comes back. What is the value for myid? Answer: 1003 Explanation: The last_value is the last value inserted. The next insert will use the last_value with the increment added. Ref: sys.identity_columns - [ [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 - Development [tsql help]( - Hi All, Need some TSQL help. Need to extract a portion of the string of [tran_log_writes] column, convert that value to GB and display it as seperate column as "TLOG-gen-GB". Below is the sample data. CREATE TABLE [dbo].[test2]( [tran_log_writes] [varchar](8000) NULL ) GO INSERT [dbo].[test2] ([tran_log_writes]) VALUES (N'db1: 245471085 (68491820 kB)') GO INSERT [dbo].[test2] ([tran_log_writes]) […] SQL Server 2016 - Administration [WSFC - DR question.]( - I'm trying to write a DR doc with no test system for someone with no experience of SQL / clustering. I know! Don't ask. It's a weird old place where I work but they pay, I do. So, 2 nodes at site 1. 2 at site 2. 2016. AG. WSFC underlying on 2016. File share […] [SQL 2016 Patches and CUs marked "duplicate (do not use)]( - What's the story with a lot of SQL 2016 patches being marked "duplicate (do not use)"? It's not just one or two, it goes all the way back to CU1, and seems to be almost all of the patches, but there's no explanation or reference to what should be used or how to know if […] SQL Server 2019 - Administration [Odd Connect Issue With FQN]( - I have a 2019 SQL server that I can connect to with the NetBIOS name, but get "Access Denied" when I try to connect to it using the FQN. I have tried from multiple clients, including the console of the problem server. I have verified the normal things, access rights, group membership, that the domain […] [Need to enter the port to connect...]( - This is one of the mysterious things that clearly something changed, and n0body knows what. We have our monitoring software installed on a SQL 2019 server. Last week, it stopped connecting to two servers, SQL 2016 and SQL 2014 versions. Both are named instances. The connections were set up as ServerName\InstanceName, and this has been […] [failed jobs - if then else]( - i'd like to list out the failed jobs within the last 24 hrs. if there's none, print "none". however i'm getting an error. error: Msg 128, Level 15, State 1, Line 39 The name "none" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are […] SQL Server 2019 - Development [Audit data]( - Hi Team , We have a requirement from the client , in which we have get the data about all users(ip address , machine etc) who have performed DML operation on any table in the database . If there were few tables I would have created a DML trigger . Is there any tools in […] General Cloud Computing Questions [Not a question - Just making sure everyone knows.]( - I'm posting this because I just want to make sure that people are aware.  I don't believe a "panic" is required but I do believe that "awareness" is required.  We all "knew" the following would "never happen", right? You might also want to check on the "Related" links near the bottom of […] Azure Data Factory [using ADF to extract Dynamics 365 data]( - Hello, we a migrating from on premises CRM to cloud D365 and need to ETL data into on-premises sql server/data warehouse. I have come across 2 options... KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 / SSIS Productivity Pack Azure Data Factory. We are a company that uses Microsoft products and services and already have […] Reporting Services [showing character "?'' as total of pages in the top toolbar navigation panel.]( - Hello fellow, I would like to post this issue which is driving me insane referred to the pagination control on the navigation top menu. On initial element listing paging shows up like image above. Whereas I'm moving forward thru next pages, it remains as such: Same issue continues till get the last page. The only time […] Powershell [Append MMYYYY to File to Copy]( - How can I adjust this script to add MMYYYY to the file name before the extension on the Copy? thanks Before: dys_ihhist.txt After Copy to Dest dys_ihhist_072023.txt  $source="c:\fileloading" #location of starting directory $destination="c:\filecopy"; #location where files will be copied to $files=@("*dys_ihhist*") New-Item -ItemType Directory -Force -Path ($destination); Get-ChildItem -recurse ($source) -include ($files) | Copy-Item […] Analysis Services [Can workspace database be recreated in tabular cube?]( - Hi All, I need to modify an old tabular model for which workspace database has been deleted accidentally. Is there a way to recreate the workspace database? I deployed the cube but it only creates main DB not the workspace database. Strategies and Ideas [What is the meaning actually for DWH]( - Hello.. Im working on a data facility almost since 8 years on a BI and DWH design … and there was always a question on my head about designing the DWH when we talk about storing data .. are we talking about every part , column , row , cell of data or are we […] Integration Services [Script task to get oauth 2.0 token error]( - I am trying to figure out a way to get oauth2.0 bearer token from the rest API. So from Postman I can do a POST method for " And in the body, I choose x-www-form-urlencoded and put grant_type as "password" and put the values for my username and password. This gives me a token which […] SQL Server 2022 - Administration [Find Version Mismatch]( - Hello, I'm looking for a way to generate a cross-sever report [using TSQL(without LinkedServers) or Powershell ] to show SQL Server AlwaysOn replicas that are not in the same version. Can someone please guide me? Thanks in advance   [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -