SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

The built in "script data" tooling in SQL Management Studio 2008 R2 is broken for me because of spurious "cyclical foreign keys" errors. Plus the "generate scripts" itself has gone from clunky but ...

Spatial Cartridge provides sample SQL script files to show how to use dynamic SQL in a PL/SQL block to create layer tables for spatially indexed data or to administer and manipulate all the partitions ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database used to be installed as part of the SQL Server installation process. Fast forward to ...

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

Microsoft releases SQL Server Management Studio 22.9.0 with GitHub Copilot, Database DevOps and SQL formatting enhancements. GitHub Copilot Ask Mode now generates reviewable T-SQL scripts, while Agent ...

Some of you may remember at the end of last year I said I would be keeping my eye on a company called SQL Farms. Today I have my first update on their progress. They've got an editor that has tons of ...

While database testing is, in many ways, similar to other traditional application testing procedures, teams must confirm that they perform database tests frequently and thoroughly throughout the ...