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

A clear delegation of work exists between the HTML and PL/SQL in your company's Web pages: PL/SQL code fetches and manipulates data from SQL databases, and HTML code formats the results of PL/SQL ...

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

New and experienced administrators of Microsoft Dynamics GP have similar sets of needs, just at different levels. New administrators need to know what tools and SQL scripts are available to help them ...

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

Microsoft today announced the next version of its flagship RDBMS is officially named SQL Server 2017 and made a new Community Technology Preview (CTP) available for download. Previously referred to as ...

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