Geeks With Blogs


View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites

Anthony Trudeau SQL Server Topics that discuss SQL Server administration or development.
Timestamp to String
The SQL Server TIMESTAMP data type is represented as a byte array in the .NET Framework (byte[] in C#). You may have the need for any number of reasons to provide a representation of the timestamp that can be displayed to the user or for debugging purposes. This may seem complicated at first glance, but the .NET Framework already includes methods to complete the operation in a few lines of code. The only trick that you need to know is if the helper object treats the bits as big endian or little ending ......

Posted On Saturday, January 5, 2013 7:41 PM

Cannot start with 'Log'
I found another oddity that seems to be undocumented today. This one in SQL Server 2005. Apparently, you cannot start objects (at least stored procedures) with the word "Log". I have a table called ShipNoticeLog and a stored procedure called LogShipNotice. The table is the noun and the stored procedure is the action -- this is how I prefer to do the naming. My code quickly failed with the message, "Invalid object name 'LogShipNotice'..." I ended up solving my issue by renaming the stored procedure ......

Posted On Wednesday, September 24, 2008 2:21 PM

User Defined Aggregates (UDA) in SQL Server 2005

I finally got back to reading some of my “Introducing Microsoft SQL Server 2005 For Developers” book and I stumbled upon the topic of user defined aggregates (UDA). I think this is an interesting subject, although probably only useful in very distinct scenarios.

Posted On Wednesday, January 18, 2006 3:50 PM

Copyright © Anthony Trudeau | Powered by: