posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

August 2007 Blog Posts

Viewing Database Updates through ODBC using Profiler

I just finished writing a small data update utility to copy a single row of data from a custom written application into a piece of packaged software.  Usually when I do this I turn on Profiler, watch the packaged software insert a row and then copy what they did.  This helps me find all the odd little status fields and related tables that aren't obvious from looking at the table.  And yes, if the developer provided documentation it would help.  They didn't. A simple login, adding one row and logging out generated over 10,000 SQL:BatchCompleted...

posted @ Friday, August 24, 2007 10:35 AM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Blog at SQLTeam = Earn some cash

If you visit the blogs of Jeff Smith and Mladen Prajdić you'll notice they are now running the same ads as the main site.  They were both running generic Google ads prior to this.  We were able to tweak a SubText skin in order to pull ads from my ad server.  The biggest benefit is that their revenue more than tripled and their ads are better targeted at their readers.  If you're a blogger here on the site please contact me if you're interested.  You do need  a certain minimum level of traffic and you need to be posting regularly.  In order...

posted @ Wednesday, August 08, 2007 7:04 AM | Feedback (0) | Filed Under [ Site Related ]

Powered by:
Powered By Subtext Powered By ASP.NET