Content
Fast Cash Customer Care For Helpline Number*/9046093185*/904-609-3185*/just Call me.
Peacock Leann Leann Leann Leann FL mall Leann
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…
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…
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…
Disable Log In in SSRS
I want to log in to the SSRS web portal, but it asks for a user ID and password as shown on the screen. What should I enter?
SQL server 2022 database size?
SQL server 2022 database size?
SQL Server Express 2022 failure installation (Through Virtual machine)
Does anyone know how to fix this? I want to install SQL express 2022, For context: I installed a Virtual machine inmy laptop. VM windows 11 Pro. for me to run a school related project. My windows 10 isn't working for this project - especially the SQL…
How to limit the memory usage of the sqlserver of the windows built-in WID database for WSUS
Experts:I have deployed a WSUS using the windows built-in database WID. But after running, I found that a process “sqlserver” completely filled the memory, resulting in insufficient server memory,WSUS down!Can I how to limit the memory of…
What is the diffence between Window server and Azure SQL?
Hello. I wonder to know the difference between Window server and Azure sql. Does Microsoft web site has any links for these question?