Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist below to quickly find, and fix ...

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 ...

SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.

Two caveats: First, even if you’re working with SQL Server 2016, your database’s compatibility level must be set to 130 or higher to use these features. You can view your database’s compatibility ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. I've seen one site have an occasional issue where queries to a particular table (the ...