The most secure thing to do would be set up this system to connect to the database using a Windows authenticated login (active directory account) instead of a SQL authenticated...

If all you want the users to have access to is the Object Explorer and Query editor capabilities of Management Studio, Microsoft recommends the tool "Azure Data Studio".  Despite the...

I don't think that parameters will be able to help you here, since you are dynamically building the schema and table, column list, and values list.  If it were just...

I'm not sure what benefit you believe adding the NOLOCK hint will have for the queries.  It is well documented that this can cause problems with the results.  Just Google...

Even if the OS is 64 bit, you mentioned that you are trying to use SQL Server Management Studio to connect using the alias.  This is a 32 bit program,...

I've used Aliases before, so I know it's possible.  Did you setup the same Alias under both "SQL Native Client Configuration" and "SQL Native Client Configuration (32bit)"  ?

Also this method...

Here's the link to the screen photo thread if you're in need of a good laugh:

https://www.sqlservercentral.com/forums/topic/connection-to-integration-service-failed

Something to check is that the sessions running the query have the same connection properties, such as ARITHABORT which Microsoft says should always be set to ON, as it is...

SQL Server 2012 introduced the new CONCAT function which will automatically handle the NULL values for you, and makes the resulting line of code look a little cleaner:

            
April 15, 2019 at 8:39 pm
            
#3387860

            
            
                                                
        

Do you know which task or which connection manager item in your SSIS package is erroring? EncryptSensitiveWithPassword probably is the correct way to implement this, I have used it...

I have frequently used metadata within SQL Server to script out many things over the years, I keep scripts around to easily build basic CRUD stored procs, to recreate tables,...

BROKER_RECEIVE_WAITFOR is typically not a problem and means that something is using Service Broker but there are no messages for it to process.

To research why TEMPDB is filling up, here...

Yes I agree with what you say entirely Steve, but with SQL Server there is so much to learn and practice that it is never ending. You also have...

I'd say it depends on the operation being performed on the table. A SELECT statement should be fairly close in performance, because both index options contain all the necessary...