Publishing a Public Power BI Report from Google Sheets (2023-01-27)

SQLServerCentral Newsletter for January 27, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Publishing a Public Power BI Report from Google Sheets]( - [Dealing with Cross-Server Database Dependencies in Flyway Projects]( - [Configure Contained Availability Groups for High Availability in SQL Server 2022]( - [From the SQL Server Central Blogs - Impact of Eliminating Implicit Conversions in JDBC Driver]( - [From the SQL Server Central Blogs - Getting Started Connecting to a Database with Flyway]( - [Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data]( Question of the Day - [Automatic Formatting of Code]( The Voice of the DBA  Daily Coping Tip Try something new to get out of your comfort zone 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. Speakers Are Normal People The [#SQLFamily]( is amazing, at least I think it is. Like many families, it's welcoming, supportive, and comforting. It's also maddening, frustrating, and exacerbating at times. Like most families, or at least the ones I know, it's not perfect, but it's what we have and at the end of the day, most of us get along with each other. It's also an open group of people. In general, we welcome people with open arms and smiles. Those of us that are more visible or prominent are willing to listen to, help, and support anyone. I was overjoyed during the recent PASS Data Community Summit, where I had the chance to see so many people that I haven't seen in person in 2-3 years. I met many other interesting people for the first time and enjoyed the experience. Not everyone feels the same way. I loved seeing Kimberly Tripp and Paul Randal for the first time in years and was honored to share the stage with them for the [Community Keynote](. I enjoyed the time we spent together, but afterwards [Paul wrote about some people not feeling included or welcome](. I understand that feeling. In many ways, much of adult life can mimic teenage years in high school with cliques and pettiness. I won't pretend that doesn't happen in the #SQLFamily, but I find it quite minimized, especially compared with many other communities of which I've been a part in the past. I haven't seen the higher profile speakers and leaders in the SQL Community dismiss someone for asking a question or expressing an opinion. I have, however, seen that in other communities. It can be intimidating to walk up to someone that you don't know who you might feel is famous or well known. It can be intimidating to just walk up to a group of people who are talking when they appear to know each other. I have that feeling at times even today, so I appreciate feeling like an outsider. In [the Summit keynote]( I talked about the thrill in meeting Kalen Delaney in 1999 and shaking her hand. I was nervous and intimidated to ask her a question after her presentation. At the time I hadn't delivered a talk in front of anyone outside of school environments and was a fairly introverted geek. It was hard to stop up and make that effort, but I'm glad I did. As Paul writes, anyone is welcome in the #SQLFamily. Anyone can join. You don't have to come shake a hand or say hi, but I'm happy when you do. Will we be best friends right away? Probably not. Will we go out to dinner that night? maybe. I've certainly met attendees at events and then had dinner with them. I know plenty of other speakers who have as well. Many of the people who speak, organize, and write/blog/tweet/etc. in our industry are friends. We do value time with each other, and that can feel like a club, but it's not. We enjoy seeing each other and want to catch up, like any group of friends. However, we are also welcoming of newcomers, so feel free to introduce yourself. Ultimately those of us who engage in these highly visible, extroverted acts are often just like the rest of you. We're a mix of people that are mostly introverted, with a few extroverts thrown in. Some speakers are very smart and talented, some are more like me: we know enough to get the things done that we're asked to do. Some of us love to go out and sing karaoke until all hours of the night and others prefer a small dinner or a little tabletop gaming in a quiet environment. My encouragement to get people to meet others, network, set up events or meetups, and more isn't to try and convince any of you to join the cool kids club. It's not to get you to change who you are. It's to help you find your tribe. To find your kind of people. I'd love to greet all of you with a hug at events, call you by name, and go out to dinner with you. I can't because there isn't enough time in the day. And quite frankly, I really, really value my alone time. What I want more than anything is for you to be successful, find a great job or career you relish, and for you to enjoy spending time with those you enjoy. Whoever and wherever that is. That takes some effort, but it's worth the energy involved. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Publishing a Public Power BI Report from Google Sheets]( Steve Jones - SSC Editor from SQLServerCentral Learn how you can share your Power BI report with others in the public. Steve shows how his data in Google Sheets is added to Power BI and then made public in a report. [External Article]( [Dealing with Cross-Server Database Dependencies in Flyway Projects]( Additional Articles from Redgate How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects. [External Article]( [Configure Contained Availability Groups for High Availability in SQL Server 2022]( Additional Articles from MSSQLTips.com In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows. [Blog Post]( From the SQL Server Central Blogs - [Impact of Eliminating Implicit Conversions in JDBC Driver]( Tracy Boggiano from Database Superhero’s Blog Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop The post Impact of Eliminating... [Blog Post]( From the SQL Server Central Blogs - [Getting Started Connecting to a Database with Flyway]( Steve Jones - SSC Editor from The Voice of the DBA In a previous post, I got Flyway installed as a CLI utility (command line interface). This post will look at the first connection to a database. If you need... [Pro Encryption in SQL Server 2022]( [Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data]( Additional Articles from SQLServerCentral This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Automatic Formatting of Code I have a repository in Git where I am keeping my SQL Server code. I want to ensure that all code changes are formatted. I have a formatting tool that I can run from the command line on my files. How do I ensure that all changes made to code files are formatted in the repository. 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) Azure Synapse Link for SQL What is the Azure Synapse Link for SQL? Answer: A link that replicates incremental SQL Server data changes to Azure Synapse dedicated pools Explanation: Azure Synapse Link for SQL is a way for real time analytics in Azure Synapse by replicating incremental data changes in SQL Server (or Azure SQL database) to Azure Synapse Dedicated SQL pools. Ref: What is Azure Synapse Link for SQL - [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 [Need to be written comment like "Lost"]( - Dear All, I am new in SSRS, I created one report like the attached file. (Design, Output) I want to add a comment on the last those customers who didn't purchase any item continue two months. if any challenges in understanding pls let me know.  SQL Server 2016 - Administration [Change the exsisting WSFC to a new WSFC in AG Configuration.]( - Hi; We have a production SQL Server setup with AG configuration. The WSFC is not configured properly there. So we had to face lot of issues past days. Now system engineers decided to create a new WSFC and recofigure the AG. If anyone can please share the SQL Server side configuration steps for this. Please […] SQL Server 2016 - Development and T-SQL [TEMPDB Version Store Growth when READ_COMMITTED_SNAPSHOT IS OFF]( - Why would the version store be growing for a database where READ_COMMITTED_SNAPSHOT is OFF? SELECT U.*,D.name,is_read_committed_snapshot_on FROM tempdb.sys.dm_tran_version_store_space_usage U JOIN sys.databases D on U.database_id = D.database_id WHERE reserved_space_kb > 0 order by reserved_space_kb desc Thanks [Help with Joins]( - Hi there, I'm new to T-SQL and am struggling with the join concept in practice. I'd like to join the results of multiple tables to one generic column called "Codes".  I have 7 different tables that use the same name, just have different codes depending on the table. Each row record has a unique identifier […] SQL Server 2019 - Administration [SQL 2019 Standard - DB role, how to find create date and who created it.]( - A role has appeared on a few databases. Is it possible to find when it got created and who created it? In SSMS it does not show those properties. Viewing "Facets" get's me the date but need to know by who created it. Also looking at Schema history returns nothing.  Thanks  [Sql server Execution Plan table format]( - Hi I have searched on net but didn`t found much its possible to have output of sql server execution plan in table format ???? I mean non-graphical dbms like oracle/mysql must giving data in table format only .So its same possible in sql server too. Large/complex query execution plan are difficult to read so if […] [Where i can see logs for AlwaysON]( - Hi In case of SQL Server Failover Cluster we get sql server cluster log by executing command get-cluster log . Can we get saem in case of alwasy-on log or there is some other command Basically i want to check where i can see where can i see logs for Always-ON . is it in […] Amazon AWS and other cloud vendors [AWS : SqlServer to Postgree continous replication]( - Hi, I have RDS mssql serer database on aws. for few tables I want to replicate them continuously (once a day) on postgres. I can write tsql code with linked server to populate data on postgres, but I read on AWS articles that it only allows sqlserver to sqlserver (min standard edition) linked server connections. […] Azure Data Factory [who is using ADF and why?]( - I asked a question some time ago which orchestrator you guys would recommend. Airflow, prefect and Argo were the most common answers but there was also something else that stood out, no one liked Azure Data Factory. I once looked at it and I did not like it either, so it was not really a […] Reporting Services [SSRS Subscription email authorization options]( - We recently had a BI person leave the company and report subscriptions stopped being sent. They had setup a bunch of them and was the owner and since we never configured email at the server level all subscriptions used the owner credentials. We are now going to setup email at the server level using SSRS […] General [No experience with programming; how difficult is SQL for new prospect?]( - I'm looking at a career change. I have bachelors degree in healthcare management and pre counseling. My mental health is going down the drain and do not think I can sustain myself long term in the field of addiction. I was planning on going to grad school for counseling, but entry level data analyst positions […] Analysis Services [Run MDX Query against different Databases on the same server]( - Ahoy, i have few ssas server instances and many tabular models on each of the server. Now i want to gather structural metadata of these models. There are some DMVs which seem to get what i need: $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS $System.DISCOVER_STORAGE_TABLE_COLUMNS $System.DISCOVER_STORAGE_TABLES But the problem seems to be that these DVMs can not get data across multiple […] PostgreSQL [Create the AS clause for Postgres crosstab dynamically.]( - This is a continuation of Dynamically creating columns for crosstab in PostgreSQL. To be clear, I cannot produce the AS clause if I have a dataset with a variable amount of keys. For example, a table with tests (testdate, pupil, outcome) that begins with the pupils (Tom, Dick, Harry) This would be the crosstab: select […] SQL Server 2022 - Development [How to select the data from xml]( - Dear All, My table have a xml column so how to select the data from xml column my data is: Best beauty advent calendars for Christmas 2022, including skincare & makeup from Liberty, M&S, Body Shop, MAC and Charlotte Tilbury. What top products are inside and when do they […] [Building Application to connect with SQL Server Tables and Edit records]( - Hello, I would like to build a Microsoft-based Application to use SQL Server Tables, and with this application there needs to be the ability to edit, delete, update etc records (in SQL Server). Other than Visual Basic, what other Microsoft Tools/languages are suitable ? Thanks !   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -