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

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

There are some nifty, better-than-SSMS tools that cost nothing to use. One of them is already in your toolbox and you might not know it. I'm down on SQL Server Management Studio right now. I basically ...

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

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Microsoft has revealed some details about what's next for SQL Server Management Studio (SSMS). Customers should expect multiple SSMS releases soon. SQL Server Management Studio (SSMS) is the tool ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

AI thrives on data but feeding it the right data is harder than it seems. As enterprises scale their AI initiatives, they face the challenge of managing diverse data pipelines, ensuring proximity to ...

It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL extension for Visual Studio Code. Microsoft recently ended support for Azure Data ...