Content
How do I setup a query while looking for a record with an apostrophe in it?
How do I setup a query while looking for a record with an apostrophe in it?
VBA: How to setup connection with Access to retrieve data into Excel?
Referring to following online database file, I would like to know on how to retrieve those data into Excel, and would like to know on how to setup the connection as well. Some sample coding is given as shown below Does anyone have any suggestions? …
Getting error for standard logic app sql trigger: The 'ListCallbackUrl' API is not supported by triggers of type 'ServiceProvider'
I have a standard logic app that needs to use a sql trigger for when a row is inserted. I am using vnet integration to connect to a peered vnet that's in different tenant. When I first create the sql connection, it is able to connect to the database and…
Buidling SQLqueries in dynamic content ADF
Im trying to use generic values for my SQL query. I have created parameters for a DB, schema and a table that should be passed into the FROM clause, and i ahve tried two approaches as can be seen in the SQL queries. But as is im getting thsi error: …
SQL Server Reporting Services 2019 - Home Folder Error - Could not load folder Contents. Something went wrong
Hi. As stated in the title, when I try to open report manager http://compreports/reports I got an error, Could not Load Folder Contents. Something Went Wrong I can add new folder but it is not visible If I search whatever folder I have…
blocking scenario
Hi All, I am seeing a session is blocking another session which is started much later. I am saying this based on start_time and duration columns using sp_whoisactive. is it possible or its a timing issue? Can anyone explain how that's possible? DELETE…
lock escalation
Hi All, I am trying to understand the lock escalation behavior in Microsoft SQL Server 2017 (RTM-CU31). As per my knowledge, lock escalation is done to minimize the lock memory when it is exceeding 5000 locks. Here, in this example, I have create a…
Importing DataFactory ARM Template failing for SQLServer ConnectionString
I am trying to clone a DataFactory to a different ResourceGroup. To do so I exported the ARM template from the source Resource Group and I would like to import it into the new one. I read here that you also need to recreate any self-hosted IR: If you…
Can adomd .net core connect to an SSAS endpoint from Linux?
Hi, I've a C# .Net Core 3.1 application, using the latest adomd .net core client, that successfully connects to an SSAS server and retrieves data when run on a Windows (Win10) platform. I've compiled it as portable, specific with libraries, and specific…
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired
Hi, I have installed SQL Server 2019 on Linux platform and had done all the necessary steps and I was able to login to SQL Server via sqlcmd some time ago but suddenly I have started seeing below error when connecting to SQL Server via sqlcmd. i have…
SSIS feasibility with key pair authentication for an OLEDB connection
Hi , I want to know if we can connect to another MS SQL DB using key pair authentication using an OLEDB connection with the help of SSIS. If not possible, how to achieve the same in ODBC connection? Any help would be greatly appreciated Regards
Any roadmap to increase storage for the SQL MI Business critical Database?
I've noticed that the current storage size for the business-critical premium series database is capped at a maximum of 5.5 TB. I'm curious if there are any plans to expand this storage capacity in the near future. Additionally, I'm wondering if there's a…
VAR Char to Dollar Format
I have a column [totalAmount] and want to convert so that the amount is in US Dollar format. Example: 9729.20 and I want it to read $9729.20 in display.
OnError Exception,
Hi, Where to identify the reason, due to the details below? at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at…
Visual Studio 2022 ARM - SQL Server Object Explorer (Microsoft.Data.SqlClient.TdsParser threw an exception)
I am attempting to connect to ANY SQL server database via VS 2022 ARM's SQL Server Object Explorer - it simply states Microsoft.Data.SqlClient.TdsParser there an exception. I also get the same exception when using the EF Core Powertools. My consulted…
SQL Audit on Azure SQL Managed Instance - Retention Days?
Fellow DBA's I have been using SQL Audit for years on-premise. Moving to cloud. Since the SQL Audit will use blob with a URL Path, and we no longer user number of files as well as rollover count, I do not understand how to interpret Retention Days. 1 -…
Unable to connect the sql server using windows authentication from asp.net application
Hi Team, Please find the details below. Current Infrastructure Setup: AzurewebappVM AzureDBVM Created new Windows domain account (ABC\Test) in the on-premises Active directory. Merged on-premises activity directory and Azure Active Directory…
Get Data before starting date
as last solution , as last solution , https://learn.microsoft.com/en-us/answers/questions/1359033/expected-output-required Condition ,if O_Value and O_Date is not null against item in itemmasterfile table, then qty from Probale table against relevant…
Go To Definition (F12) in SQL Server Management Studio does nothing
Dear all, I am using SQL Server Management Studio 19 (fresh install) locally on my Windows 10 machine with my admin SQL user. Now I am trying to click on a table definition in my SQL query and press F12 (Go to definition default keymap) and it does…
Transactional replication not replicating with 'The process is running and is waiting for a response from the server' error after adding new article
Hi I have a Transactional Replication setup which is working fine since long time. It is a Pull subscription. I got a new requirement to replicate a large article which is 10GB. allow_anonymous & immediate_sync are set to false by default. I added…