Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in ...

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

Microsoft today released SQL Server 2022, the latest version of its database software, which originally launched more than 33 years ago. Microsoft describes this release as the “most Azure-enabled ...

TOAD has been a popular Oracle development tool for years. Now owned by Quest, TOAD continues to have its own independent Web site, and is expanding its product line. One of the latest things they've ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

A recent project at my current employer called for creating a new web frontend to an existing MSSQL database. My boss, having created a sophisticated MySQL and PHP-driven black diamond web site in PHP ...