Upgrade SQL Server 2016 to 2019
Is there any known issues in upgrading from SQL Server 2016 to 2019? Can it be done by a SQL novice or do you need to have more knowledge to perform the upgrade? We currently are using Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) Thank you for any suggestions or help you can provide.
How to increase SQL query performance of a view?
Hi everyone, I am new to Microsoft community, so please let me know if this post is not in the right forum and if so which one would be the right one. issue: - Update & query (using Power BI) of my Sales Weekly View takes forever (>30min) and I would like to understand how I could improve this Current setup: - Sales Daily View: View containing aggregation and joins of two main sales tables and a date table - Sales Weekly View: View joining the "Sales Daily View", a sales table and two dimension tables and containing extensive logics (mainly aggregations) Please let me know if you have any idea how to streamline this and improve the performance of the view.
How to get last updated date of the table
Hello Experts, I am looking for the date, when is the last update (delete, truncate and reinsert) was made on the table I came across SYS.DM_DB_INDEX_USAGE_STATS table with LAST_USER_UPDATE column, but sometime it returns NULL, Shall I believe on it gives me what I am looking for Regards, Amit
MSOLEDBSQL Connection String for SQL Server
I am working to create a connection from Excel Desktop Office 365 subscription in a macro. I have the following code in the VBA PType = "MSOLEDBSQL" Hostname = "tcp:myserver.database.windows.net"" InitCatalog = "TEST" UserName = "xx@myserver" Passwd = "bigpassword01" Trusted = "yes" sConnectionString = "Provider = " & PType & "; " _ & "Server = " & Hostname & "; " _ & "Initial Catalog = " & InitCatalog & "; " _ & "User ID = " & UserName & "; " _ & "Password = " & Passwd & "; " _ & "Trusted_Connection = " & Trusted & "; " '& Encrypt = " & Enc " When I hit the connection.open part of my code I get an Invalid connection string attribute error This is what it looks like from the Watch variable "Provider = MSOLEDBSQL; Server = tcp:myserver.database.windows.net; Initial Catalog = TEST; User ID = xx@myserver; Password = bigpassword01; Trusted_Connection = yes; " There aren't many examples of people using the MSOLEDB connection string What bit's missing or is an invalid attribute VBA is terrible about helping out? PeterIntroducing Microsoft Fabric: Data analytics - partner resources
Live now: Microsoft Build Online: May 23–24, 2023; Starting 8AM Pacific Today we announced Microsoft Fabric— a unified SaaS experience that provides all the capabilities needed for analytics across Data Factory, Power BI, and the next generation of Synapse. Fabric provides data integration, data engineering, data warehousing, data science, real-time analytics, applied observability, and business intelligence under a single architecture. Get Started Microsoft Fabric is now in Public Preview and FREE trials are available to everyone - no credit card required. Today, all existing Power BI Premium customers can opt-in via the Power BI Admin portal and starting June 1, 2023 ready for purchase through Azure. Read more about Microsoft Fabric in this Build announcement and join the live event at Tues. 9AM Pacific for Satya’s Keynote Tues. 4PM Pacific for Arun and Amir’s Keynote See what partners have to say about Microsoft Fabric in the Partner blog - New business opportunities with Microsoft Fabric – the data platform for the era of AI - Microsoft Cloud Partner Program Sign up for the Microsoft Fabric free trial Attend the Tech Talks: BI Partner Community Call on Wed. May 31st 8AM Pacific - New Fabric Community and Blog with Ryan Majidimehr, Senior Program Manager, Azure Data Wed. June 7th 8AM Pacific - AMA with Amir Netz, Technical Fellow, Azure Data Wed. June 14th 8AM Pacific - New Fabric Docs and MS Learning Path with Ricardo Carrasco, Senior Program Manager, Azure Data Visit the Microsoft Fabric website View Microsoft Fabric licensing options Get started with the Microsoft Fabric eBook Follow these end-to-end tutorials to explore new scenarios Start your learning journey with new Microsoft Fabric Learn Modules Join the Microsoft Fabric Community to post questions and learn from others Prove your expertise and get exclusive benefits with the Analytics on Microsoft Azure SpecializationIntroducing Fabric Partner Community
As a valued member of the Microsoft AI Cloud Partner Program (MAICPP), we appreciate your commitment to building and showcasing your expertise on Microsoft products by creating and deploying solutions over the years. Today, we are sharing an exciting announcement and introducing the new global Fabric Partner Community, a space where you can learn and engage with the Fabric Partner Team, PMs from the product engineering team, and your peers to accelerate growth and build your expertise on Microsoft Fabric and Power BI. We will continue to find ways to enable you, our partners, to showcase your expertise in creating and deploying Fabric solutions to meet your customers’ needs. This means that we will prioritize our product focus on Microsoft Fabric, to include Azure Data Factory, Azure Synapse Analytics, Power BI, and more. One way we are doing this is by welcoming all MAICPP partners into the Fabric Partner Community – all you need to do is be a program member and fill out the participation form below. Next steps: Complete the Fabric Partner Community Participation Form at aka.ms/JoinFabricPartnerCommunity to get access to the new Teams channel Join the first Fabric Engineering Connection, the weekly partner community call on Wednesday August 30 th at 8AM Pacific (meeting invite in Teams) As we are aligning to the one Microsoft partner program (MAICPP) and launching this new Fabric Partner Community, we will be retiring the Business Intelligence Partner Program alongside the below features and helping redirect: Find a Partner | Microsoft Power BI: to the AppSource Partner Directory for Power BI All Microsoft partners are able to self-designate their expertise on Power BI through their AppSource Business Profiles. Learn how to create a Business Profile and designate yourself as a Power BI partner by visiting Get sales leads - create a business profile - Partner Center | Microsoft Learn Partner showcase | Microsoft Power BI: to the AppSource Partner capabilities for Business Intelligence Specialization With the launch of the BI Specialization, we are showcasing partners that have proven performance, knowledge, and expertise on Power BI. Additional specializations we'd like to highlight are: Analytics: Analytics on Microsoft Azure specialization Data Warehouse: Data Warehouse Migration to Microsoft Azure specialization Partners that have attained their Solutions Partner designation and earned a Specialization are eligible for incremental product and support benefits. Visit the Business Intelligence Specialization (microsoft.com) website to review the requirements and check your status in your Partner Center account. Nothing changes today as we are only sharing news of what’s to come, the program benefits (Find a Partner and Partner Showcase) will remain until September 31, 2023. If you have any questions, contact us at FabricPartnersTeam@microsoft.com.Getting started with Roadmap and Azure Boards
Here are two posts on using Roadmap with Azure DevOps Boards: Using Azure Board Work Items in Roadmap: https://pwmather.wordpress.com/2019/03/15/project-roadmap-azuredevops-azureboards-ppm-projectmanagement-msproject-projectonline-office365-powerplatform-cds/ Reporting on Roadmap data with Azure DevOps data in Power BI: https://pwmather.wordpress.com/2019/03/16/project-roadmap-powerbi-report-pack-with-azureboards-data-ppm-projectmanagement-msproject-office365-powerplatform-dynamics365-cds-odata-azuredevops/
Open reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's like https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage at https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport might be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URL https://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?
