http://www.hibbins.com Software Development: C#, SQL Server, .NET, Analysis Services, Reporting Services, Intergration Services, OLAP, PHP, HTML, XML, CSS, Java, Javascript and anything else technical, complex and hibbins.com Thu, 14 Jan 2010 16:24:00 +0000 http://backend.userland.com/rss092 en If you use Windows Live Messenger a lot, you'll have noticed that the icon now resides on the taskbar, where you can easily change status and quickly send an IM to someone. If you prefer to keep Windows Live Messenger in the system tray, where it's been for previous releases, ... http://www.hibbins.com/2010/01/14/tip-hiding-the-windows-live-messenger-icon/ CREATE FUNCTION [dbo].[DateOnly] (@Date DATETIME) RETURNS DATETIME BEGIN RETURN DATEADD(d, DATEDIFF(d, 0, @Date), 0) END http://www.hibbins.com/2009/11/24/t-sql-date-only-function/ CREATE FUNCTION [dbo].[LastDayOfTheMonth] (@Date DATETIME ) RETURNS DATETIME BEGIN RETURN dateadd(ms, -3, DATEADD(mm, DATEDIFF(m, 0, @Date) + 1, 0)) END http://www.hibbins.com/2009/11/23/tsql-last-day-of-the-month/ When I installed Zend Server CE on OSX 10.6 Snow Leopard the admin interface failed, the following fixed the issue : 1. Download this: Watchdog update 2. Backup watchdog with the command sudo mv /usr/local/zend/bin/watchdog /usr/local/zend/bin/watchdogOLD 3. Extract the new watchdog to /usr/local/zend/bin/ (I used the go to folder in finder, if you can ... http://www.hibbins.com/2009/10/18/zend-server-ce-on-osx-10-6-snow-leopard/ 1: Delete It ! If a chunk of code comment or class is not used, don't comment it out, just delete it. 2: Write clear code. "make sure you document code that's hard to understand". Question: why is the code hard to understand? 3: Comment Comments can indeed be useful but mostly as ... http://www.hibbins.com/2009/08/26/4-coding-tips/ If you want to check if a Javascript function exists before you attempt to call it and get an error try: if(typeof window.Function == 'function') { // function exists Function(); } http://www.hibbins.com/2009/03/22/check-if-a-javascript-function-exists/ Apple has announced the iPhone 3.0 software update which includes an updated Software Development Kit (SDK) with over 1,000 completely new APIs. Here are a few highlighted features: Search your iPhone Cut, copy, and paste Send photos, contacts, audio files, and location via MMS* Read and compose email and text messages in landscape And yes, I ... http://www.hibbins.com/2009/03/17/iphone-30/ If you need to access SVN remotely, by default it runs on port TCP port 3690, so you need to make sure it is open in your firewall etc. http://www.hibbins.com/2009/02/12/svn-port-tcp-port-is-3690/ If you like to know what's changing on your SQL Server then the following code creates an audit table and the associated trigger for logging the changes The Audit Object Table CREATE TABLE [dbo].[AuditObjects]( [EventID] [int] IDENTITY(1,1) NOT NULL ,[EventData] [xml] NULL PRIMARY KEY CLUSTERED ( [EventID] ASC ) WITH (IGNORE_DUP_KEY = OFF) ... http://www.hibbins.com/2008/12/17/sql-server-schematablefunction-and-stored-procedure-auditing/ Ever had the need to search stored procedures to find redundant tables or text that needs replacing or re-factoring ? Here's a script to help (Sorry for the cursor, I'm sad with myself for using it :-( ) -- Search string DECLARE @SearchString nvarchar(50) SET @SearchString = 'Search String' -- Required Declares DECLARE @getdbname sysname DECLARE @sqlstm ... http://www.hibbins.com/2008/12/05/search-stored-procedures/