Peter shows how a Visual Studio database project can make you more productive when making changes to your database. But a database project also gives you a variety of tools to let you keep track of ...

Having recently set up an old desktop as a dev machine in order to avoid trashing my main computer with evaluation software (don't get me started), I decided it was time to try out Visual Studio 11 ...

One of the Azure SQL-related announcements that did not get a lot of publicity at May's Microsoft Build conference was the Azure SQL Database local database experience. With all the hype around SQL ...

Fix SQL Server connection problems 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 ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database. This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express ...

Every business needs a well-designed database management tool. Finding a well-organized, functional system that allows your team to perform data-related tasks with ease is crucial to the success of ...

Last month, Microsoft released a few updates for SQL Server Management Studio (SSMS) 21, while also revealing its plans for the next major release, SSMS 22. This follows the release of a SQL Server ...