The OakLeaf Database Lens provides links to online items and original content about Microsoft SQL Server 2005 and Access databases, WinForm and WebForm database front-ends and data-intensive XML Web services created with Visual Studio 2005 and Visual Basic, and related topics that might be of interest to database developers.
Many of the links are to my articles in the OakLeaf Systems blog, Fawcette Technical Publications' Visual Studio Magazine (VSM) and their .NETInsight newsletter. Most VSM and .NETInsight articles include dowloadable sample Visual Basic code for the article's topic. Other links point to MSDN blogs created by Microsoft program managers and developers on database-related topics.
You'll also find links to topics related to databases offered as Software as a Service (SaaS), such as Google Base, Windows.Live.Expo (a.ka., "Windows.Live.Classifieds" and "Fremont"), and the like. A few blog items cover OpenOffice 2.0, OpenOffice Base (the new database application), OpenDocument specification 1.0 (ODS 1.0), and Microsoft Open Office XML Formats for Word, Excel, and PowerPoint.
At the bottom of this page, you'll find links to Amazon.com pages for many of the English editions of the 30+ Microsoft database and operating system books I've written during the past 12 years.
Technorati Profile Technorati tags: Databases Database SQL Server SQL Server 2005 SQL Express SQL Server Express SQL Server 2005 Express Visual Studio Visual Studio 2005 ADO.NET 2.0 Access Microsoft Access
Recent Visual Studio Magazine Articles
- Add Reports and Charts to Web Pages
- The ASP.NET 2.0 version of Visual Studio 2005's ReportViewer control and its Report Designer let Web page developers quickly embed, format, and export interactive reports and charts without running a SQL Server Report Server.
[Visual Studio Magazine, March 2006] - Build Client-Side Reports Easily
- VS 2005's new ReportViewer control and its built-in Report Designer enable smart-client and Web page designers to lay out, format, embed, export, and print interactive reports without running a SQL Server Report Server.
[Visual Studio Magazine, November 2005] - What's New With VS and Data
- Roger Jennings discusses the new data features that made it into Visual Studio and SQL Server 2005-and a couple features that were dropped late in the process.
[.NETInsight, November 18, 2005] - Streamline Mapping With Orcas and LINQ
- Use a pair of LINQ Technology Preview add-ins that integrate with .NET 2.0 and VS 2005 to take a look into the future of VS and data.
[Visual Studio Magazine, December 2005] - Manage Data With VS 2005
- Visual Studio 2005's new visual data tools and data-bound controls, together with ADO.NET 2.0 data sources, simplify creating scalable, data-intensive Smart Client and Web applications.
[Visual Studio Magazine, December 2005] - Create Interoperable Native Web Services
- Yukon lets you take advantage of the new kernel-mode Http.sys listener and eliminates the need for IIS to process ASMX files or SQLXML 3.0 templates that implement Web services.
[Visual Studio Magazine, October 2005] - Take Advantage of New T-SQL Features
- New T-SQL keywords implement TRY...CATCH error handling, pivot aggregate values to create crosstab tables, rank and partition rowsets, generate temporary in-memory tables with common table expressions, and more.
[Visual Studio Magazine, September 2005] - Encrypt and Decrypt Data in Yukon
- SQL Server 2005's engine-based, data-encryption functions protect confidential information from unauthorized access and disclosure, and offer native key management as a bonus.
[Visual Studio Magazine, August 2005] - Migrate to SQL Server 2005 Express Edition
- Take advantage of new SQL Server 2005 features, GUI administration, and XCopy or ClickOnce deployment with SQL Express and Express Manager.
[Visual Studio Magazine, July 2005] - Exploit Yukon's XML Data Type
- Take advantage of SQL Server 2005's new native XML data type to add XML columns to a table, populate and index the columns, and understand basic XQuery syntax.
[Visual Studio Magazine, June 2005] - Get Ready for SQL Server 2005
- Belated Beta 2 shows what's in store for data architects, project managers, and DBAs.
[Visual Studio Magazine, Enterprise Edition, 2004]
Recent OakLeaf Blog Atom Links
Latest 30 Atom 0.3 Links from the OakLeaf Blog
These newest 30 links are also used to populate Google Base News and Articles items added by the OakLeaf_Systems user alias.
Fetching RSS feed... please stand byMicrosoft SQL Server 2005 Blogs and Articles
- SQL Server 2005 Express Edition Blog
- Basic information about SQL Server 2005 Express Edition (SSX) and SQL Server Magagement Studio Express Edition (SSMSX or SSMS-E).
- Bill Ramos (SQL Tools) WebLog
- Bill Ramos is a Lead Program Manager with the SQL Server 2005 Tools team. He's currently responsible for the SQL Server Management Studio UI, Profiler and Database Tuning Advisor, and was responsible for Express Manager.
- SQL Server 2005: CLR Integration
- Samples, tips and tricks, insights from the CLR Integration team at SQL Server.
- Microsoft SQL Server Development Customer Advisory Team
- This is the Microsoft SQL Server Development Customer Advisory Team blog. Members of the SQLCAT are: Mark Souza (manager), Bren Newman, Howard Yin, Kevin Cox, Prakash Sundaresan, Prem Mehra, Stuart Ozer, Lubor Kollar, Gert Drapers and Tom Davidson. We will be making entries of best practices and lessons learned from the most demanding SQL Server implementations in the world.
- Microsoft XML Team's WebLog
- The XML native data type, XQuery, LINQ, XLinq, DLinq, and other XML-related topics pertinent to SQL Server 2005.
- Michael Rys
- Michael Rys is Microsoft's main man on the native XML data type, XQuery, and other XML-related topics pertinent to SQL Server 2005. His blog contains links to his MSDN articles and white papers.
Books by Roger Jennings
Most of my database and related books in English.
Special Edition Using Microsoft Office Access 2003 (Special Edition Using)
Amazon Price: $34.64 (as of 10/10/2008)
Expert One-on-OneTM Visual Basic® 2005 Database Programming (Expert One-On-One)
Amazon Price: $26.39 (as of 10/10/2008)
Introducing Microsoft Office InfoPath(TM) 2003 (Bpg-Other)
Amazon Price: $25.54 (as of 10/10/2008)
Special Edition Using Microsoft Access 2002 (Special Edition Using)
Amazon Price: $49.99 (as of 10/10/2008)
Special Edition Using Microsoft Access 2000 (Special Edition Using)
Amazon Price: (as of 10/10/2008)
Roger Jennings' Database Developer's Guide with Visual Basic 6 (Developer's Guide)
Amazon Price: $59.99 (as of 10/10/2008)
Admin911: Wwindows 2000 Group Policy
Amazon Price: (as of 10/10/2008)
Visual Basic.NET XML Web Services Developer's Guide
Amazon Price: $41.05 (as of 10/10/2008)
Special Edition Using Access 97
Amazon Price: (as of 10/10/2008)
Special Edition Using Access 97 (2nd Edition) (Using ... (Que))
Amazon Price: (as of 10/10/2008)
The Official Visual Basic Programmer's Journal Guide to Visual Basic 4
Amazon Price: (as of 10/10/2008)
Special Edition Using Windows NT Server 4
Amazon Price: (as of 10/10/2008)
Special Edition Using Microsoft Windows 2000 Server (Special Edition Using)
Amazon Price: $49.99 (as of 10/10/2008)
Using Access 95 for Windows 95
Amazon Price: (as of 10/10/2008)
Using Access 1.1 for Windows (Using ... (Que))
Amazon Price: (as of 10/10/2008)
Database Developer's Guide With Visual Basic 3/Book and Disk
Amazon Price: (as of 10/10/2008)
Links to My Other Squidoo Lenses
- Microsoft Access 200x Lens
- This lens is devoted to Microsoft Access versions 2000 through 2007, and covers Access 2007 and related Office 2007 servers (beta versions) with content that isn't subject to the current Office 2007 NDA.
- The Black Scholar Lens
- The Black Scholar: Journal of Black Studies and Research is an internationally acclaimed journal founded by Prof. Robert Chrisman and co-edited with Prof. Robert L. Allen.
The Black Scholar began publication in 1969 and has been hailed by the New York Times as "a journal in which the writings of many of today's finest black thinkers may be viewed." - No More U.S. Custom Surfboards?
- Clark Foam, the world's largest supplier of rigid polyurethane foam cores (blanks) for custom-shaped surfboards unceremoniously shut its doors on December 5, 2005.
The closure led to a state of semi-panic among Southern California's custom surfboard makers, who had no immediate source of blanks to continue custom board constuction.
