SQL Server 2005 and .NET Data Access Links
blinq
A “super-long” time ago Polita Paulus, author of the ASP.NET GridView, DetailsView, and FormView, wrote a prototype called blinq. It’s about time this development entered my records… It would be interesting to get her view toward XSLT since she is so heavily invested in ASP.NET server controls. It’s kind of strange to mention Jasper so close to blinq but… um… perhaps dynamic languages might take off in the ASP.NET world?
SET IDENTITY_INSERT
For many years, I enjoyed checking a box for SQL Server 2000 DTS packages. But now that changes in SQL Server 2005 have ‘inspired’ me to see the t-SQL under the hood, it’s time to study the documentation for SET IDENTITY_INSERT.
iBATIS
While blinq threatens to make data access “too easy” and “too fast” to develop, iBATIS has long since made its threats and sits along side NHibernate as the more customizable solution for those of us actually interested in writing t-SQL. I’m still stuck on chapter 2 in my Java-proper study of Hibernate.
XLinq
Doctors Erik Meijer and Brian Beckman of Microsoft Research introduce “XLinq: XML Programming Refactored (The Return Of The Monoids).” This one should be printed out and read. This looks like a replacement for XPath.
Astoria Online Service
“The goal of Microsoft Codename Astoria is to enable applications to expose data as a data service that can be consumed by web clients within a corporate network and across the internet. The data service is reachable over HTTP, and URIs are used to identify the various pieces of information available through the service. Interactions with the data service happens in terms of HTTP verbs such as GET, POST, PUT and DELETE, and the data exchanged in those interactions is represented in simple formats such as XML and JSON.” This is essentially a technical apology for prioritizing SOAP over REST for years (and more years to come).
Backing Up and Restoring Web Sites Created with Windows SharePoint Services
A very competent operations guy sent me this link, “Backing Up and Restoring Web Sites Created with Windows SharePoint Services.” I doubt that my role as a developer will require me to learn anything written in this article. But you never know…
“SQL Server 2005 Paging Results”
The CodeProject.com article “SQL Server 2005 Paging Results” by Frank Kerrigan revives a classic problem: paging through a fixed number of rows in a database table. SQL Server 2005 brings ROW_NUMBER and OVER to this old party with new promise…
“Transferring Data Using SqlBulkCopy”
My interest in the CodeProject.com article “Transferring Data Using SqlBulkCopy” reveals yet again that replacing DTS packages with C# code is a priority over any other (bloated) alternatives.
“TDD using SqlCE and NHibernate”
The CodeProject.com article “TDD using SqlCE and NHibernate” by Sean Chambers is just an excuse for me to see NHibernate in action… This article should segue into “NHibernate Best Practices with ASP.NET, 1.2nd Ed.” easily…
“Storing Passwords—done right!”
After reading Christoph Wille’s “Storing Passwords—done right!” and Nathan Blomquist’s “File Encryption/Decryption with Hash Verification in C#,” my next move was go back to Wille’s code, download it and make a few modifications. This whole issue of salting and hashing passwords was avoided for years. But the time has come and, fortunately, Christoph Wille’s solution has been around for over three years…