INCLUDE SQL Server ... along with the Database Mail event log. Periodically you might want to reduce the size of the tables and archive messages and events that are no longer needed. The following ...

The default functionality for the SQL Agent is to only Send an Email upon the firing of an Agent Alert This code will allow you to capture all those Alerts from all your SQL Servers into a Central ...

Managers of data warehouses of big and small companies realise this sooner or later, that having vast tables of numbers and ...

It is possible to use the SQL Server Agent to execute PowerShell scripts ... Joshua Jones is co-author of A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 ...

We have Database Mirroring set up (SQL 2005), but what is the proper way to mirror SQL Agent Jobs? We have quite a few custom jobs. Is it just manually scripting out the jobs from the Principle ...

In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

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