Advanced SQL concepts include joins, grouping, aggregate functions, and Common Table Expressions (CTEs). ER diagrams can be generated using tools like MySQL Workbench and SQL Server Management Studio.

While the database management tool for Visual Studio is going to be a wonderful addition, down the road it would be nice to see other plug-ins come out of the MySQL camp.

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...

Just like the first option, Beekeeper Studio is a free, open-source, cross-platform, SQL editor and database manager. It supports various databases such as MySQL, SQLite, SQL Server, and PostgreSQL.

This new version features native access to MySQL, access to J2SE Java-based objects, JDBC connectivity, bug fixes, and more. In addition, Omnis Studio 4.0 offers Studio applets that allow you to ...

As an addendum to last week's post about a recent SQL Server camp held for PHP developers, Microsoft's Brian Swan has published some new nuts-and-bolts details for converting MySQL queries. Swan, who ...