Getting Started with Azure Purview (2021-02-18)

 SQLServerCentral Newsletter for February 18, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Getting Started with Azure Purview]( - [SQL Server triggers: The good and the scary]( - [From the SQL Server Central Blogs - ADF, XML objects and XPath in the expression language]( - [From the SQL Server Central Blogs - Zooming In on a Power BI Report]( Question of the Day - [Accelerated Data Recovery Editions]( The Voice of the DBA  Daily Coping Tip Get Moving. Do something physically active, ideally outdoors 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 Growth of Terabytes Years ago, fresh out of university, I joined the [IEEE](. As one of the benefits, I got their magazine, with various articles that might expand my knowledge. In one issue, I remember reading about the challenges of video on demand. At the time, calculating what it would take to store digital movies and broadcast them to each PC seemed like an impossible task. This was in the days if hardwired 10Mbps Ethernet and dial-up Internet. Not too long ago I had some Internet bandwidth issues, and got some stuttering during video meetings. I run [Rainmeter]( as a skin on my PC, and once I got things working, I was curious what sort of bandwidth I was using. These days, if I'm not doing any streaming of audio/video, my PC seems to need about 1-3kpbs to keep Tweetdeck, Outlook, Slack, etc. going. Youtube seems to get bursts to 1.5Mbps every few seconds, but plenty of low < 100kbps times in between. Netflix seems to be a steady 2Mbps to get video. All of that doesn't seem to add up to much for my household. Even when 5 of us lived here, with lots of streaming from the kids, our symmetrical 15MBps connection worked fine. I don't know what our total usage was for the month, but I doubt we used 1TB a month. Actually, if I calculate it out, full use of 15Mbps for a month is about 4TB, so maybe the kids got there? Apparently, more and more people are getting there. [A report shows that 14% of some weighted set of subscribers use over 1TB a month](. This is over their broadband connection, and likely leaves out mobile usage. While lots of this usage and bandwidth is transient data, like streaming movies, this also means that some data professionals, and network professionals, need to manage the data that flows. For many data professionals, this isn't necessarily a problem, and in some sense, this is good for us. Heavy usage pushes the network staff to increase the speed and capacity of links. That means those of us transferring data (CSVs, backups, etc.), can get our jobs done faster. So watch more movies, stream more music, and root for the carriers to increase speeds and capacities. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Getting Started with Azure Purview]( Johan Åhlén from SQLServerCentral Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data governance and metadata frameworks. Apache Atlas was created by Hortonworks and big names within finance, pharma, etc. […] [SQL Server triggers: The good and the scary]( Additional Articles from SimpleTalk SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues. From the SQL Server Central Blogs - [ADF, XML objects and XPath in the expression language]( Ed Elliott from Ed Elliott's Sql Developer Blog When you use ADF, there are two sides to the coin. The first is the data itself that ADF does very well, from moving it from one site to... From the SQL Server Central Blogs - [Zooming In on a Power BI Report]( Meagan Longoria from Data Savvy Have you ever tried to use your browser to zoom in on a visual in a Power BI report? If you simply published your report and then zoomed in,...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Accelerated Data Recovery Editions In SQL Server 2019, which editions can use Accelerated Database Recovery? 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) An R Loop What does this loop do in R? x <- 1:20 for (val in x) { if ((val %% 2) == 0) {next} print(val) } Answer: prints all odd numbers from 1 to 20 Explanation: This loop skips to the next iteration if a number is even, otherwise it prints the number from 1 to 20. This means all odd numbers are printed. [results showing odd numbers printed] Ref: - Next in R - - arithmetic operators - - for loop - [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 2016 - Administration [Connection options to encrypted servers.]( - I've applied certificates and enforced encryption on two SQL 2016 SP2 servers. Using the same login credentials I can create an encrypted connection to one of the servers by selecting 'encrypt connection' in the connections options. With the second server unless I also select 'trust server certificate' I get a connection error: A connection was […] SQL Server 2016 - Development and T-SQL [BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ whatsAAP : + 1(845) 243-3187?](e2%80%ac) - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […] [Parsing an XML field within a table]( - I am trying to parse a field that is XML in a table and insert into a table. Where would be a good example to do this> I have attached the values from that field in a notepad++ file. [Sequencing query]( - Hello,  I have a query regarding the best way to deal with a sequencing problem.  This may be a little hard to explain. I have the following data (table and data script attached) where I need to regroup the depths columns by 1 foot increments and join the corresponding data which falls within […] Administration - SQL Server 2014 [removing database from AG and putting it back in]( - Lets say a database was removed from AG for maintenance purpose. The primary node would have the w/r copy of it and secondary would have it in restoring state. What would be the best way to put it back in the AG again after maintenance? From primary --> add to AG and then join? Development - SQL Server 2014 [BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€]( - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […] [get Actual backup file name from the sql backup path]( - Hey everyone, sorry, i am trying to get the actual file name accurately from the path, what i currently have is: E:\Backup\Server1\Database1\Database1_131983519013.bak and want to get just: Database1_131983519013.bak trying to use trim or left etc. but finding it difficult as some other database names might be longer or shorter, so its random, any idea how […] SQL Server 2019 - Administration [SQL server for an oracle developer/dba]( - I have a few years experience developing with oracle and have now moved to a place where they use SQL server (2005). Where would be a good place to learn things like SQL Server query optimization, basic dba stuff and sql server gotchas for someone with my background. [HA solution using mixed SQL Server on-prem and Azure SQL Server]( - trying to come up with an architecture for HA. I was thinking of using our on-prem SQL Server as primary, with Azure as secondaries. IT has mandated that putting everything in Azure is too costly, and we wanted to come up with a geo-replicated solution as our customers are all over the place. Does anyone […] SQL Server 2019 - Development [Server is fast, then slow, then fast with no pattern]( - I am having a problem with my sql server running queries and using it in Visual Basic. The primary table I pull data from has 24 columns with 76,000 rows. Sometimes it takes less than 6 seconds to run the query. Other times, it takes over two minutes and once in a while, it stops […] Reporting Services [Add more space below report totals]( - Hello, First off I am sorry if I'm posting this in the wrong area. I hope I'm not I've search endlessly to try and find this answer. Even on here. Probably using the wrong words. How can I add more space below the bottom of my reports. When I run the report, I need […] Integration Services [save mutiple ssrs reports from a ForEach loop into a single file]( - Hello, I have a client who has a letter run that is produced monthly using a combination of SSIS and SSRS. In short, a foreach loop passes the parameter intothe ssrs report and usinga C# script task generates a PDF into a windows folder. They are asking if I can alter the process so that […] Design Ideas and Questions [SQL newbie, question about primary key.]( - Hello, SQL newbie here. I've got a question about the proper use of primary keys, hoping someone can help out. Let's say I establish an HR database and decide that, since Social Security numbers are unique and non-repeating, I'm gong to use SS numbers as my primary key. Something like this: Name, Title, Social_Security_Number Joe […] The Future of Community [Is there room for independent SQL or Data Integration based User Groups?]( - So I live in a smaller community with no real User Group presence of any kind, and though when SQL Saturday events were still in person the nearest one near me is 2 hours drive. Now during pandemic I doubt we'll see any return anytime soon, so I was wondering if there's room to try […] Article Discussions by Author [BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€]( - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -