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

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

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

It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

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

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...

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