I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...

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

Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL. Its key ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...

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

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...