To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

IDERA SQL Admin Toolset gives users essential desktop tools for everyday SQL Server needs, runs every day diagnostics across multiple SQL servers, completes administrative tasks in minutes, not hours, ...

The VDT designers were hosted in the Visual InterDev shell and introduced a new database project type that served as a container for Transact SQL (T-SQL) scripts generated by the tools. Before VDT, ...

Any of the Java-based database management GUIs tend to work fine (well, kludgy, but acceptable for simple tasks) since they are using the SQL Server JDBC driver.

Each database is different, so connecting to Postgres is a little different from connecting to MySQL, which is different from connecting to SQLite. Watch out for the following pitfalls when doing JDBC ...

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. SQL Server 2025, now in public ...