Step-By-Step: Creating a SQL Server Always On Availability Group
One of the most requested features in SQL, from as far back as SQL 2012, has been Always On Availability Groups. This takes disaster recovery and high availability to a new level by enabling multiple copies of the database to be highly available, enabling the possibility of Read-Only workloads and enabling the ability of offloading management tasks such as backups. Unlike database mirroring, Always On Availability Groups allow for failover of a group of databases in a single SQL Server instance. This step-by-step details the creation of a SQL Server 2016 / 2017 Always On Availability Group to ensure high availability of mission-critical databases.SAP on Azure General Update August 2022
Woolworths Australia goes live on Azure, new recommendations for SAP on Oracle direct from Oracle themselves. Disk Bursting and VM Bursting and new SSD v2 in preview. SQL Server 2022, ODBC 18 and Windows 2022 News for Windows customers and news for Linux customers Important guidance for sizing boot disks on Linux.
Application pool keeps on stopping
One of my Application pool keeps on stopping which is impacting my User Profile Service Application and Workflow management service on SharePoint Server 2013. I have followed the below steps: Click on Application pools. Click on the particular Application pool for your site. Right-click Advanced settings. Set Enable 32-Bit Applications to False. Also I have found that below steps might help also: Restart the application pool IIS reset Stop Start User Profile Service However is there anything else that I can do which will not impact the Business?
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.
SQL 2019 Fails to Start - Error 17051
I have a fairly significant set of issues that I cannot figure out how to resolve that has brought down a bunch of systems. A windows update occurred and the SQL 2019 RC1 server rebooted itself (do not believe that this error is related just coincidental). This error indicates that the SQL Server evaluation period has expired. Upon reviewing the startup logs this concurs with my belief: I am confused about why I am running into this issue as I am running a developer version of SQL and not the evaluation version but none the less it currently appears to be a problem. To attempt to resolve this issue I have done the following: Attempted to do an edition upgrade and set everything back to developer and the process ran and completed successfully but the service will still not start. Attempted to upgrade editions to a licensed version of SQL (which I do also own) and I cannot complete the upgrade because the SQL server is not running. I attempted to follow instructions to turn back the computer time and set common files registry entry to "3" in an attempt to trick it into being active so that I could upgrade. My system automatically reverts the time back to the standard time almost immediately. Attempted to turn off network connection to disable time sync Defaulted the time settings for windows Unjoined the server from the domain thinking GPO might be interfering This system MUST be restored. Any ideas you have on how to get it back up and running again would be seriously appreciated!
'OpenApiConnection' is not valid
Hi everyone, I am new to power automate, l am trying to migrate data from a SQL table to a SharePoint list using power automate, one of the fields keeps throwing an openApiconnection error. it is a lookup field in SharePoint however in Microsoft flow it's expecting a lookup ID of the field. how do l go round solving it, please..... The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Project/Id' is required to be of type 'Integer/int64'. The runtime value '"743: Carefirst replacement / Eclipse - Phase 1: Adults"' to be converted doesn't have the expected format 'Integer/int64'.
