SQL Server Articles SQL Server Articles


Article Type: Article
DBA Daily Checks Email Report
Author: David Wiseman (Administrator), | Date: 2009-07-13 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
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
Author: David Wiseman (Administrator), | Date: 2009-07-12 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
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
Author: David Wiseman (Administrator), | Date: 2009-03-27 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
Describes the "Trace Query In SQL Server Profiler" feature in SQL Server Management Studio 2008.


Article Type: Article
A Google-like Full Text Search
Author: Michael Coles, | Date: 2009-03-02 | Source: www.sqlservercentral.com
Rating:
(1 votes)
My Rating:
{log in to vote!}
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
Author: David Wiseman (Administrator), | Date: 2008-09-12 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
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!
Author: David Wiseman (Administrator), | Date: 2008-06-25 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
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


Article Type: T-SQL
Proper Case T-SQL User Defined Function
Author: David Wiseman (Administrator), | Date: 2007-09-30 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
A T-SQL function to convert text into ProperCase.


Article Type: T-SQL
Kill Users Stored Procedure (T-SQL)
Author: David Wiseman (Administrator), | Date: 2006-12-23 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
T-SQL procedure to forcibly disconnect users from a database.


Article Type: T-SQL
T-SQL Age Calculation Function
Author: David Wiseman (Administrator), | Date: 2006-12-23 | Source: www.wisesoft.co.uk
Rating:
{Not Rated}
My Rating:
{log in to vote!}
T-SQL Function to calculate a persons age.


Previous Page   Next Page Page Size:

RSSWiseSoft.co.uk Articles RSS Feed