SQL Server Articles SQL Server Articles

Article Type: Article
A DDL Auditing Solution
By implementing a DDL Auditing solution you can capture data definition language events (CREATE TABLE, ALTER PROCEDURE etc), allowing you to answer important questions like who changed what and when. It can give you a complete history of changes that have been made to objects in your database, detailing when each change was made and who the change was made by. Auditing of DDL events can be done automatically, providing you with a lightweight, zero effort solution that documents what changes have occurred in your server/database...

SQL Server database backup script. Can be used to backup all databases on a SQL server instance or include/exclude specific databases. Backups can be automatically deleted after a specified period of time.

DDL Code History Tool tracks DDL Events (schema modifications) that occur in a SQL Server database. The tool can be used to answer questions like "who changed what and when", providing you with a history of schema changes for any given object in the database.

Article Type: Article
DBA Daily Checks Email Report
DBAs typically create a number of alerts to inform them of potential problems with their database servers. In addition to these alerts, it's also important to proactively monitor your database servers by running a series of daily checks. The exact checks performed will vary from organization to organization, but some common ones include: • Check backups • Check SQL Server agent jobs • Check disk space • Check free space in database files • Check SQL Server error log • Check Windows event logs ....

Article Type: Article
SQL Server CLR IO Utility
A CLR assembly that provides access to various IO utilities found in the .NET framework.

Article Type: Article
SSMS 2008 Tip - Trace Query In SQL Server Profiler
Describes the "Trace Query In SQL Server Profiler" feature in SQL Server Management Studio 2008.

Article Type: Article
A Google-like Full Text Search
Code written in C# that provides a simple Google like search syntax that is translated behind the scenes to SQL Server Full Text search syntax. This code was adapted for use on WiseSoft.co.uk to provide powerful searching capabilities for this website. A good place to start for anyone looking to make use of full text indexing on their website.

Article Type: Article
T-SQL Backup/Restore Progress
Check the progress of a backup or restore operation. Includes percent complete, running time, remaining time and estimated completion time.

Article Type: Article
Database Compare using FREEWARE Tools!
This article explains how to compare two database schema's, highlighting any objects that are different and reporting changes in those objects. This is quite a common requirement, as people often want to compare development databases with their production database. Also, you might just want to compare two versions of a stored procedure, highlighting any differences between the two. Unfortunately, SQL Server does not include any tools for comparing database schema's. There are some commercial

A T-SQL function to convert text into ProperCase.

Previous Page   Next Page Page Size:

RSSWiseSoft.co.uk Articles RSS Feed