Category Archives: Sql Server

A simple script for checking Full Text Index population

The following script will check if the full text index has changed in the last 15 minutes and send and email to warn you if it is not populating. Where ftc_default is your full text catalog in your user database. … Continue reading

Posted in Sql Server | Leave a comment

Configuring Sql Server JDBC as a JNDI ServiceMix Datasource

The following steps will outline how I have configured JNDI in  ServiceMix to successfully create a datasource for use within your OSGI packages. Install Servicemix by unzipping the release from http://servicemix.apache.org/ Verify that your install was successful buy running Servicemix.bat … Continue reading

Posted in Sql Server | Leave a comment

Sql Server UnionAggregate to merge geofences

Over the past two years I have been learning more and more about the power of SQL Server’s  spatial functions. During this time a co-worker, and myself have developed server side geofence processes to track vehicles using GPS data. Some … Continue reading

Posted in Sql Server | Leave a comment

SQL Server: A simple PowerShell script for my crashing log reader agent used in replication.

Over the past few weeks one of my production servers involved in replication has had the log reader agent just stop for no apparent reason. Currently upgrading from 2005 sp2 is not an option on this particular server. So to … Continue reading

Posted in Sql Server | Leave a comment

SQL Saturday #156: September 15th

Reminder to all. Please register for SQL Saturday #156 in East Greenwich, RI. THIS SATURDAY!!!!!! The schedule is here: http://www.sqlsaturday.com/156/schedule.aspx What a great opportunity to network and learn from the best. Hope to see you there!!! As always DBA’s don’t … Continue reading

Posted in Sql Server | Leave a comment

SQL Server: Learning StreamInsight using Arduino with a custom Input Adapter.

Microsoft released StreamInsight with SQL Server 2008R2, and I’ve been putting the learning curve off for quite a long time. So this blog post is my attempt to learn some of its basic capabilities. What better way to learn this … Continue reading

Posted in Sql Server | 3 Comments

TSQL: What DOW did the first Fourth of July occur on?

This post is to offer you some insight on my first experience with calculating the DOW (day of the week)  a certain date occurs on. My experience in this subject dates back to 1980 when I was studying Engineering in … Continue reading

Posted in Sql Server | Leave a comment