Blog Detail

Jeff's SQL Server Weblog

http://weblogs.sqlteam.com/Jeffs

Thoughts, Ideas, Techniques and more on Microsoft SQL Server, with a sense of humor.

• Added on: Apr 1st, 2007
• Country: United States
• Language: English

• Author: Jeff
• Listed in: Programming Software
• Tags: programming sql Microsoft .net sql server database

Recent Posts

• An interesting take on "Stored Procedures" (link)

  Posted on Monday November 16th, 2009 at 12:42

  Another great post SQL-related post over at TheDailyWTF regarding a, umm, "creative" use of "Stored Procedures": http://thedailywtf.com/Articles/For-the-Ease-of-Maintenance.aspx ...

• Programming is like dreaming?

  Posted on Monday November 2nd, 2009 at 13:52

  This is from March, so it's a little old, but I just stumbled upon it and found it a bit interesting. I never thought of programming this way before, but it does make sense: Programming is like a dream ...

• Is it just me ...

  Posted on Tuesday October 27th, 2009 at 11:50

  ... or is about time I got back to some blogging? ...

• Processing an OLAP cube with a T-SQL Stored Procedure

  Posted on Monday October 27th, 2008 at 14:26

  Here's a simple SQL Server stored procedure that you can call to process an OLAP cube using T-SQL.  The parameters should be self-explanatory.  To me, this is a little easier and more flexible than processing using DTS packages. create procedure ...

• I'm back ... with some news!

  Posted on Thursday October 16th, 2008 at 15:04

  I apologize for not posting any new content in quite some time, but now I am back and will soon start posting on a (hopefully!) regular basis once again. The reason for my hiatus was a pretty good one, though: I recently became a father with the bir...

• Foreign Key Constraints: SET NULL and SET DEFAULT

  Posted on Wednesday August 13th, 2008 at 08:56

  Most people know about cascading updates and deletes, but did you know there are two other foreign key constraint options you can use to maintain referential integrity? Read all about them in my latest article over at SQLTeam.com. These features, i...

Comments & Reviews

This blog is currently rated a 5.00 out of a possible 5 based on 1 comment.

Kevin Saitta

Excellent blogs, well written.

Posted: June 2nd, 2008 | More Reviews From kjsphoto | Report This Comment

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.