<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"><channel><title>WiseSoft.co.uk articles for IT Professionals</title><link>http://www.wisesoft.co.uk</link><description>Articles for IT Professionals from WiseSoft.co.uk.  Active Directory, Scripting, SQL Server etc.</description><ttl>120</ttl><item><title><![CDATA[ DBA Daily Checks Email Report]]> </title><link>http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx</guid><description><![CDATA[ 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
.... ]]> </description><pubDate>Mon, 13 Jul 2009 19:16:50 GMT</pubDate></item><item><title><![CDATA[ SQL Server CLR IO Utility]]> </title><link>http://www.wisesoft.co.uk/articles/sql_server_clr_io_utility.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/articles/sql_server_clr_io_utility.aspx</guid><description><![CDATA[ A CLR assembly that provides access to various IO utilities found in the .NET framework. ]]> </description><pubDate>Sun, 12 Jul 2009 13:09:38 GMT</pubDate></item><item><title><![CDATA[ SSMS 2008 Tip - Trace Query In SQL Server Profiler]]> </title><link>http://www.wisesoft.co.uk/articles/ssms_2008_tip_trace_query_in_sql_server_profiler.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/articles/ssms_2008_tip_trace_query_in_sql_server_profiler.aspx</guid><description><![CDATA[ Describes the "Trace Query In SQL Server Profiler" feature in SQL Server Management Studio 2008. ]]> </description><pubDate>Fri, 27 Mar 2009 21:47:20 GMT</pubDate></item><item><title><![CDATA[ A Google-like Full Text Search]]> </title><link>http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/</link><guid isPermaLink="true">http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/</guid><description><![CDATA[ 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. ]]> </description><pubDate>Mon, 02 Mar 2009 23:23:54 GMT</pubDate></item><item><title><![CDATA[ T-SQL Backup/Restore Progress]]> </title><link>http://www.wisesoft.co.uk/articles/tsql_backup_restore_progress.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/articles/tsql_backup_restore_progress.aspx</guid><description><![CDATA[ Check the progress of a backup or restore operation.  Includes percent complete, running time, remaining time and estimated completion time. ]]> </description><pubDate>Fri, 12 Sep 2008 18:56:50 GMT</pubDate></item><item><title><![CDATA[ Database Compare using FREEWARE Tools!]]> </title><link>http://www.wisesoft.co.uk/articles/database_compare_using_freeware_tools.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/articles/database_compare_using_freeware_tools.aspx</guid><description><![CDATA[ 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  ]]> </description><pubDate>Wed, 25 Jun 2008 14:55:15 GMT</pubDate></item><item><title><![CDATA[ Proper Case T-SQL User Defined Function ]]> </title><link>http://www.wisesoft.co.uk/scripts/tsql_proper_case_udf.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/tsql_proper_case_udf.aspx</guid><description><![CDATA[ A T-SQL function to convert text into ProperCase.  ]]> </description><pubDate>Sun, 30 Sep 2007 16:43:54 GMT</pubDate></item><item><title><![CDATA[ Kill Users Stored Procedure (T-SQL)]]> </title><link>http://www.wisesoft.co.uk/scripts/tsql_kill_users.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/tsql_kill_users.aspx</guid><description><![CDATA[ T-SQL procedure to forcibly disconnect users from a database.  ]]> </description><pubDate>Sat, 23 Dec 2006 17:05:19 GMT</pubDate></item><item><title><![CDATA[ T-SQL Age Calculation Function ]]> </title><link>http://www.wisesoft.co.uk/scripts/tsql_age_calculation_udf.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/tsql_age_calculation_udf.aspx</guid><description><![CDATA[ T-SQL Function to calculate a persons age.  ]]> </description><pubDate>Sat, 23 Dec 2006 17:05:19 GMT</pubDate></item></channel></rss>