SQL

New Year with PerformancePoint Server

One of my new year's resolutions was to start blogging on a more regular basis, and here I am on January 16th with my first post of the year. It's amazing to look back over the past year and see how much technology has changed, at least in my little world. I have been an xml geek for the better part of this century (sounds more impressive that way than saying around 8 years). I still love xml, but begun exploring several other paths over the past 12 months (ESBs, Ajax, Silverlight, Orcas, etc.) before...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, January 16, 2008 11:44 PM | Feedback (0)

Objects Search in SQLServer 2005 - part 2

Last week I wrote about how to search for tables and columns in SQLServer2005, since they removed the Objects Search. After I posted it, I realized that it didn't link the columns to the tables, which doesn't make it very helpful. Thanks to my DBA buddy James Rogers for pointing me in the right direction, here's a more helpful query. You can leave either COLName or TBLName blank by commenting out the set command. DECLARE @COLName NVARCHAR(50), @TBLName NVARCHAR(50) SET @COLName = 'bu_id%'SET @TBLName...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Tuesday, September 19, 2006 8:31 PM | Feedback (0)

Objects Search in SQLServer 2005 - work around

The other day someone saw me hit F4 and bring up the Object search in a SQLServer 2000 Query Analyzer. They only had SQLServer 2005 installed and wanted to know how to use it there. After some research, I realized that it no longer exists. I'm not sure why they took this away. I found it quite useful, although I 'fat fingered' the f4 key more times than I hit it on purpose. Although the UI made it easy, this information is still available in SQLServer 2005 through these two tables: sysobjects and...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, September 14, 2006 7:14 PM | Feedback (1)

Twitter