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.
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? Petersql 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.Azure Redis Cache FAQ
The FAQs in this section cover some of the basics of Azure Redis Cache. What is Azure Redis Cache? How can I get started with Azure Redis Cache? What Redis Cache offering and size should I use? What Redis cache clients can I use? Is there a local emulator for Azure Redis Cache? How do I monitor the health and performance of my cache? Read more here.Stored Procedure with ASP.NET Web Forms Grid View for sorting table records
In one of our recent project, we have used stored procedure to sort items in an ASP.NET Web Forms Grid View. Here is how we have achieved this: https://www.linkedin.com/pulse/using-sql-stored-procedure-sort-items-database-table-kiril-iliev
