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.Outlook is committed to FindTime and to making group scheduling easier
We recently created some confusion with a decision to remove the FindTime add-in from the Office Store. We heard loud and clear from you that you missed FindTime and wanted it back. As a result, we brought it back as quickly as we could. We pride ourselves on being customer-focused so, again, we apologize for the frustration that our decision to remove the FindTime add-in caused. We want customers to know that going forward, we are committed to FindTime and plan to continue investing in making group scheduling easier. We will keep the FindTime add-in up and running, and we will continue to improve it based in large part on customer feedback. In parallel, we will invest to build an even more robust group scheduling solution that is integrated across Outlook. What is FindTime? If you’re not sure what FindTime is then please read on. FindTime is an Outlook add-in (Learn more about Outlook add-ins here) and website that uses a polling model to simplify group scheduling. If you have ever tried to find a good time to connect with multiple people who can’t see each other’s availability, you’ll have a sense of the problem that FindTime was built to address. FindTime helps groups converge on the best time to meet. If you are organizing a group meeting that includes people whose availability preferences aren’t clear, FindTime is a great solution. First, it lets you access availability information from the attendees' calendars that you can see to find an initial set of meeting times that work for those attendees. Based on these meeting time proposals, FindTime then sets up a poll on the FindTime website that all attendees can access. Through the website each attendee can suggest new times, can vote on the times that work best for them, can indicate times that do not work, and can see each other’s preferences while voting. FindTime saves everyone time by helping a group efficiently converge on the best time to meet and facilitates getting the resulting meeting on everyone’s calendars. Invitees can vote on their preferred times and see each other’s preferences FindTime was built with busy people in mind – especially those who frequently meet across company boundaries, but FindTime is also a great solution for anyone looking to meet with people whose calendars they don't have access to or for anyone wanting to give multiple meeting time options to someone whose calendar they do have access to. Who can use it? FindTime currently can only be installed by users with an Office 365 account with a multi-tenant mailbox hosted in Exchange Online and can be accessed with Outlook 2013, Outlook 2016 for Windows, Outlook 2016 for Mac, and Outlook on the Web. If your mailbox or account doesn't satisfy these requirements, consider asking your tenant administrator or IT administrator about moving your mailbox to Office 365 with these requirements. How can I get the FindTime add-in? FindTime is available from the Microsoft Office Store right within Outlook. Please check-out this article to learn more about how to access and use the Office Store. You can also get the FindTime add-in directly from https://findtime.microsoft.com/. Thank you for using FindTime and for your valuable feedback Thank you for your interest in FindTime. We hope you continue to use it and get value from it. If you have any feedback or suggestions you want to share about FindTime or group scheduling, please do – we read all the feedback we get and rely on it to make FindTime and related apps better. The best way to give us feedback about FindTime is through our UserVoice feedback channel which you can find at: https://findtime.uservoice.com. Thanks again, The Outlook Team
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? Peter
Daylight Saving Time in MS Bookings?
We have about 40 bookings calendars throughout our organization and all of them open the booking 3 days in advance. This upcoming Saturday evening is Daylight savings time and so Sunday has already opened for individuals to book appointments. Our earliest available appointment is 8:00 AM, however our customers are seeing 7:00 AM options this upcoming Sunday because bookings is not respecting the time change when it displays 11/1 reservation options. I'm not sure where to fix this or if this is a known bug. My searches haven't found anything and I'm wary to advise my team to alter the bookable hours for fear it would become an issue again AFTER the clocks have changed. Anybody got some insights?sql server management studio 2017 An existing connection was forcibly closed by the remote host
hi, hope someone can help me as I have an issue with my sql server management studio 2017. Since a few days I get the message "An existing connection was forcibly closed by the remote host" and thus I cannot execute scripts anymore. The sql sms is installed on my laptop and is a 2017 version. The thing is, the db that is giving issues is a sql server 2012 version (installed on a sql server cluster) but until recently this was never a problem with the way of working. Any idea how to solve this??? Thanks in advance... M
Best way to pass parameters (list) to Stored Procedure from Microsoft Flow
Hi everyone, We have been using the string_split function to get values from a comma separated parameter passed by Microsoft Flow, as discussed in the below video, but are wondering if anyone has found a more efficient way of passing parameters from Flow to SQL? https://youtu.be/BAGBzI4zdww Thanks all.Introducing SQL Vulnerability Assessment for Azure SQL Database and on-premises SQL Server!
I am delighted to announce the public preview of our latest security development from the Microsoft SQL product team, the new SQL Vulnerability Assessment (VA). SQL Vulnerability Assessment is your one-stop-shop to discover, track, and remediate potential database vulnerabilities. The VA preview is now available for Azure SQL Database and for on-premises SQL Server, offering you a virtual database security expert at your fingertips. Read about it in the Azure blog.
