Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name and endpoint (such as a DNS name or IP address). For this article, we're only ...

In Part 2 of this article, I present the source code for a Visual Basic program to generate a SQL script to efficiently delete all data from a database according to the current configuration and ...

Will you be discussing recommended security measures when using .NET Aspire with SQL Server and Azure SQL Database in enterprise environments? Microsoft is one of the most security-conscious companies ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.