Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Data   (RSS)

Webcast: Live From Redmond - VB9, Building N-Tier Applications

My second webcast which was a part of the webcast series done by Visual Basic Team called "Live From Redmond" webcasts on Visual Studio "Orcas" was on building N-Tier application using Visual Studio "Orcas". I gave this webcast a couple of weeks ago and Read More...
Posted Monday, May 21, 2007 4:52 PM by youngjoo | 0 Comments

Webcast: Live From Redmond - LINQ to SQL & O/R Designer Deep Dive

Visual Basic team is hosting a series of "Live From Redmond" webcasts on Visual Studio "Orcas" and I gave one on LINQ to SQL and the O/R Designer a couple of days ago. Thanks to all who tuned in. I covered following topics in my webcast: Mapping database Read More...
Posted Friday, May 04, 2007 12:12 PM by youngjoo | 1 Comments

TableAdapter’s RETURN_VALUE mystery

If you've been trying to figure out why you cannot access the return value when using stored procedures in TableAdapter, here's the answer and the solution for you. Assume I added a new query to my TableAdapter via Dataset Designer and named it ReturnSomething Read More...
Posted Tuesday, July 25, 2006 4:07 PM by youngjoo | 1 Comments
Filed under: ,

Retrieve meta data of your query using SET FMTONLY

Learned this neat trick today. This obviously is not well-known. I've been dealing with SQL for many years and haven't heard of this till today. MSDN article on SET FMTONLY One very useful application of this trick is to get the schema of result set returned Read More...
Posted Monday, April 17, 2006 6:03 PM by youngjoo | 0 Comments
Filed under:

Book: Refactoring Databases

Refactoring Databases: Evolutionary Database Design Scott W. Ambler, Pramodkumar J. Sadalage Addison Wesley Signature Series If you know who Scott Ambler is, then you definitely want to read this latest book he wrote. If you don't know who Scott Ambler Read More...
Posted Monday, April 17, 2006 5:22 PM by youngjoo | 0 Comments

SQL Server 2005 Everywhere Edition announced

Today, Microsoft announced its plan to make SQL Server 2005 Everywhere Edition available later this year. This one is targeted for what we call Occationally Connected Systems (OCS) such as mobile devices. Links: SQL Server 2005 Update from Paul Flessner Read More...
Posted Thursday, April 06, 2006 11:14 AM by youngjoo | 0 Comments
Filed under: ,

Randomize your SELECT

Neat trick on SELECTing random rows using NewID() function. Select random rows from a table in SQL ( TechRepublic ) Read More...
Posted Saturday, April 01, 2006 3:01 AM by youngjoo | 0 Comments
Filed under:
 
Page view tracker