With the New Year coming, I thought I'd look back at the last year in my life. Warning this is going to be technical and personal, that way I can turn 50% of the people off with every sentence...just a different set of people with every paragraph ; )

In my ASP.NET Core 2.0 Pluralsight course, I specifically teach how to build DbContext classes and the POCO classes that go with them. But I've been getting many questions about how to work with existing databases, so I thought I'd explain it in a blog post.

Url: http://msdn.microsoft.com/en-us/library/ff84745...

Url: http://giveaquiz.com

Url: http://wilderminds.blob.core.windows.net/downloads/sqlservermonito...

Url: http://channel9.msdn.com/showpost.aspx?postid=3...

Url: http://www.microsoft.com/downloads/details.aspx...

Url: http://wilderminds.blob.core.windows.net/downloads/pagingdemo.zip

I had an interesting discussion with some members of a class I am teaching right now about how paging is done.  It looks like there are four Functions that allow for paging and using Common Table Expressions.  They all can optionally include a separate ORDER BY clause to specify how they are sorted (so your result set can be sorted differently than it is ranked).

If you upgrade to RC1 be aware that SQL Server 2005 requires SP2 before it will work with Vista RC1.  Yeah, I know there is no SP2...but that's the case.  It just doesn't work. I am trying to hack around the problem so I'll let you know if I find a solution...

I have been attempting to try out some new software from Microsoft (including Glidepath and Visual Studio Database Edition).  Both of these require SQL Server Express installed.  Problem is that I install a Developer Edition of SQL Server 2005 (as well as 2000) because it is more feature friendly than SQL Server Express.  Why does Microsoft insist I have a third Database server?  Why can't it prompt me to tell it what database to use, or at least attempt to find SQL Server 2005 as the default instance on the current machine?  Just stoopid in my opinion.  It's keeping me from trying out and possibly exhaulting these new interesting projects.

Url: http://wildermuth.com/viewrant.aspx?id=2053

Url: http://msdn2.microsoft.com/en-US/library/system...

Url: http://www.atlantacsharp.org/NextMeeting.aspx

Url: http://www.red-gate.com/products/SQL_Packager/i...

Url: http://blogs.msdn.com/florinlazar/archive/2005/...

Url: http://www.microsoft.com/sql/2005/productinfo/l...

Url: https://msdn.one.microsoft.com/Subscriber/1033/...

Url: http://wilderminds.blob.core.windows.net/downloads/LocalSqlServerM...

Url: http://www.devsource.com/article2/0,1759,182186...

Url: http://www.devsource.com/article2/0,1759,179167...

I've been digging deep into SQL Server 2005's CLR integration over the last few days.  I am surprised by several specific omissions.  My guess is that they have been dropped because of time constraints:

Forget everything I told you.  It's all changed in the April CTP.  I hope to re-give this talk soon in the Atlanta area with the new bits.

Url: http://www.sqlmonster.com/Uwe/Forum.aspx/sql-se...

Url: http://codebetter.com/blogs/sahil.malik/archive...

Url: http://news.com.com/Microsoft+reaches+beyond+pr...

Url: http://news.com.com/Microsoft+reaches+beyond+pr...

Url: http://news.com.com/2100-1012_3-5172166.html?ta...

Url: http://www.microsoft.com/sql/reporting/howtobuy...