Which recommended included columns to really include in indexes?
Greetings. I just ran sql logScout and sql nexus against a heavily used reporting server during a peak time of day for 10 minutes just to see what it comes back with. About 20 indexes were recommended for the same table. Over the years Ive come to use…
Is my Resource Governor set up correctly?
Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…
TLS 1.0 and TLS 1.1 deprecation ,Will it Stop Azure VM internal servers communication
Hi, We have two servers running on Azure. Both servers are running on Windows Server 2008 R2. One server is configured as an IIS server, and the other is a legacy SQL Server. Both servers communicate with each other using TLS 1.0 and 1.1. My question is:…
Is it good to use single database connection for all database operations in one API request?
In general, I know the best practice while handling database connections in C#/ADO.NET is to open Db connection just before querying the Db & close the connection immediately after query execution, so that connection gets back to pool. My question…
Max value of each column in a table
Hi there, I have 500+ Azure SQL tables with total of 25000+ columns. Most of the tables have varchar (max), or nvarchar(max) but to contain a value which could only be 3 , 5 or 20 characters long. --for characters select max(**len(**columnname)) from…
SQL Server shared LocalDB instance is not automatically starting
I have an application that uses LocalDB. The named instance "PrivDb" is owned by whatever account installed the application. Part of the setup process is to grant "NT AUTHORITY\Authenticated Users" the sysadmin role so that any…
EF Core 8 Shadow Properties incur a 255 limit on columns
We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields To get that in EF, we engaged Shadow Properties, and that is working well Unfortunately we found Shadow Properties incur a limit of 255…
SQL Server on Azure VM Backup minimizing data duplication
A while back, a Microsoft support engineer recommended using SQL on VM backups. The suggestion was to create an SQL DB in an Azure VM job and an Azure VM job, excluding the disks that host the SQL files, to avoid data duplication. If the VM is deleted…
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
Allocated vs. Used Memory in SQL Server Elastic Pool
Hello! I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated…
sql server install not properly
TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
Issue with excessive error messages in SQL Server Log during the reading of Server Audit session (.sqlaudit) files
Hello, I am encountering an issue with a high volume of error messages in the SQL Server Log while reading from an active Server Audit session. This problem occurs in SQL Server 2019 and later versions. I have set up database auditing using Server Audit…
how can i rerun the sql script using DbUp with new modifications?
Hello I am new to using DbUp and when I run a script it runs successfully but when I add some modifications I get this message Beginning database upgrade Checking whether journal table exists.. Fetching list of already executed scripts. No new…
rdlc files donot compile or validate in VS 2022
I am trying to upgrade and compile a project in VS 2022 with some rdlc files, it does not show any errors when we try to build or rebuild. It was working on VS2013 before. It showed any compile errors in the files and does not complete the build until…
Licensing for SQL Enterprise
Dear team, I need to inquire about the licensing of SQL Enterprise; As per Microsoft documentation, if we choose the "per core" licensing model, the required licenses would be based on the number of cores assigned to each server having SQL…
Could not connect Azure SQL connect through private link
We encountered an error in the application (dotnet 8.0 console running in AKS container) when trying to connect to a Azure SQL database hosted on a standalone Azure SQL server. Error message A network-related or instance-specific error occurred while…
Retrieve an SQL standard license for in place upgrade
We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…
Cannot connect to SQL Database. Please contact SQL server team for further support.
Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a