What front end for Sq; Server
I am converting a MS Access tables and queries to Sql Server back end. The app is a personal finance app. When completed the back end will be cloud based. Then, I will convert the MS Access front end to cross platform(windows, Mac, Google and Linux with compatibility with Android and IOS. I don't know what language to use for this front end. I am a self taught developer and I know that I am not the best or fastest and would have to learn the language. What language would you recommend and why?
SQL Server Express
On my Windows 10 PCs I have been using for many years a third party application (Veeam Agent for Microsoft Windows) that used to depend on Microsoft SQL Server Express. SQL Server Express was installed during Veeam Agent installation. The latest release of Veeam Agent does not use anymore SQL Express, so I could uninstall it if not used by other applications. Given that I have lots of applications on my PCs, how can I check that none uses SQL Express before uninstalling it? Regards
SQL Server Agent is not starting after in place upgrade of SQL server from 2012 to 2019
SQL Server Agent is not starting after in place upgrade of SQL server from 2012 to 2019 I have done in place upgrade of SQL server from SQL 2012 Standard Edition (64-bit) SP4 to Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X 64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X 64> (Build 17763: ) (Hypervisor). But after upgradation, sql server agent is in stopped state. I have tried with Local system account also but still no luck. Error in windows event logs is SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is read-only). I have checked and confirm that msdb database is not in read only state. Can someone help me to resolve this issue.
Executing SQL trigger doesn't work if triggering events are generated by Azure Data Factory
Good day everyone, I have an issue getting data from Azure Data Factory into SQL. My original solution of using power automate was stymied by the combination of a mysteriously slow Stored Procedure when running it from Power Automate vs SSMS and the hard coded 2 minute timeout in flows. So my next idea was to run the SP from a trigger whenever records are inserted into a staging table from data factory using Copy Data action. *The trigger works fine when adding records in SSMS *The Data Factory pipeline successfully inserts rows into the staging table *After successful inserts from DF, the trigger in SQL on that staging table does not fire. Is this a bug? How can I work around this? And finally, is there a better way that doesn't involve deploying more services/licenses? Edit: To clarify what I' masking about. Key scenario I am attempting is in bold above. However, I have just decided to run the SP from Data Factory and pay the fees to run it. I don't have any more time to waste trying to troubleshoot.
Null Question
Hello Guys, i am totally new and just started SQL 1 weeks age i have come across a problem in SQL suppose i am working on huge amount of data which is unclean and i want to find NULL & i know the syntax of null but suppose i have almost 50 columns and i want to find out in which row there is NULL is there any we can find NULL or Blank field in this vast data because it will take a lot of time if i just put null syntax and writing one by one column
Application performance impact post upgrade
Hi Folks, Need technical experts suggestion on an DB performance issue that I am facing after every application upgrade. Here is the current DB setup details for reference: Setup: Database : SQL Server 2014 We have two node active-active cluster with 128 GB RAM and 20 Cores on one node. There are 2 databases (1 production (200GB) and 1 reporting) running on one instance. Replication is configured between production and reporting database. During front end application(.Net application) upgrade, as a defined step we stop the replication, so that no DB synching issue during the upgrade. Once the application redeployed with minor changes as enhancement, we again set back the replication in place and application work fine for couple of hours. Here the issue rises after 8-10 hours of application upgrade and it starts creating issue on performance side like some of the screen/functionality running slow with a 50% degradation on performance. During performance impact we have performed all the necessary health checks on the SQL Server and couldn’t find any blocking in SQL server. Server CPU and Memory utilization also looks normal. This issue get auto fixed in 24 – 30 hours post application upgrade and things back to normal. This issue we are facing post every application upgrade. Help: Can you guys suggest what could be the issue or any other checks that we should perform to find out the root cause.Have the relationship between the dynamic query plans and the stored procedure that generates it
Hi I have hundreds stored procedure that tipically execute a select with "sp_executesql" with parameters to optimized ed reuse the same dynamic query plan. The schema (semplified) is: CREATE PROCEDURE [dbo].[sp_XXX_Get] (...) AS BEGIN SET NoCount ON; EXECUTE [sp_XXX_GetBase] @Par_1, @Par_2, @Par_N, @Records OUT END CREATE PROCEDURE [dbo].[sp_XXX_GetBase] (...) AS BEGIN SET NoCount ON; [construction of select and parameters in @ExSqlStatement] EXEC sp_executesql @ExSqlStatement, N'@Records udtLong OUT', @Records OUT END and normally I'm wait something like - 1 static query plan for stored procedure (objtype = "Proc", cacheobjtype = "Compiled Plan") - 1 couple of dynamic query plan (objtype = "Prepared", cacheobjtype = "Compiled Plan ) But I note that, not for all, sometime not all select condictions are passed like parameters and I findout have several dynamic query plan every stored procedure. So, I need relate the dynamic query plans with the stored procedure that generate it to see how correct them. I searched on microsoft documantation and direcly on internet but I not found nothing. Someone can help me ? Thank you in advance The query that I use to detect "Proc" and "Prepared" plan is: use [database] go set transaction isolation level read uncommitted set implicit_transactions off SELECT SO_name = isnull(SO.name, SO2.name), SO_xtype = isnull(SO.xtype, SO2.xtype) , s='|||' , ECP_bucketid = ECP.bucketid, ECP_Cacheobjtype = ECP.Cacheobjtype, ECP_Objtype = ECP.Objtype, EST_TEXT = replace(replace(replace(EST.TEXT, char(9), ''), char(13), ''), char(10), '') , s='|||' , ECP_bucketid = ECP.bucketid, ECP_RefCounts = ECP.RefCounts, ECP_UseCounts = ECP.UseCounts, ECP_Size_In_Bytes = ECP.size_in_bytes , ECP_Memory_Object_Address = ECP.memory_object_address , s='|||' , ECP_plan_handle = ECP.plan_handle , ECP_pool_id = ECP.pool_id , ECP_parent_plan_handle = ECP.parent_plan_handle FROM sys.dm_exec_cached_plans ECP CROSS APPLY sys.dm_exec_sql_text(ECP.plan_handle) EST left outer join sysobjects SO on SO.id = abs(EST.objectid) /*WHAT'S THE RELATIONSHIP?*/ left outer join sysobjects SO2 on SO2.id = abs(EST.objectid) /*WHAT'S THE RELATIONSHIP?*/ where 1=1 and ( 1=0 or ECP.objtype = 'Proc' or ECP.objtype = 'Prepared' ) order by isnull(SO.name, SO2.name) , isnull(SO.xtype, SO2.xtype) , ECP.Objtype, ECP.Cacheobjtype , EST.TEXT, ECP.bucketid, ECP.UseCounts goCan not enter new record via Access front end after linking tables to SQL Express
I have a Time & Billing Access program. I just migrated the tables to a SQL Express database and using it as the back end: tables all linked to the front end Access program. With my Access front end, I can enter a new record into all of the tables except the TimeSheet table. I can only enter a new record into the TimeSheet table using Microsoft SQL Server Management Studio 18. Help!
