THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
T-SQL Tuesday #24 : Dude, where's the rest of my procedure?
This month's T-SQL Tuesday is being hosted by Brad Schulz (blog) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against INFORMATION_SCHEMA views - I provided several examples where I feel the INFORMATION_SCHEMA views fall short of the catalog views, and expressed my ...
November 8, 2011
T-SQL Tuesday: Easy Extended Properties
Ahhh, attention to detail. I misread Adam's T-SQL Tuesday rules and posted early. So here I go again :) This time the puzzle is how to add and update metadata via extended properties in the database with minimal headaches. SQL Server supports a great feature for storing database object metadata in the database in the form ...
Michael Coles: Sergeant SQL
January 12, 2010
Brought to you by