Friday, June 29, 2012
Visual Studio Magazine Article Retrospective
Following are images of Visual Studio Magazine issues from late 2003 to the present for which I've written cover stories. Each entry includes the article name and deck. Click the image to open the article from the Visual Studio Magazine Web site.
Updated 6/28/2008: As of early 2008, archives of articles earlier than October 2006 are no longer available from Redmond Media Group, so they are delivered as archived Web pages from the Wayback Machine.
All but one of the Wayback Machine archives are the single-page print version and have working links to Additional Resources, tables, and listings. All figures have captions and most have the original diagram or screen capture. Sample code is not accessible from Wayback Machine archives.
Microsoft has cooked up a feast of value-added big data cloud apps featuring Apache Hadoop, MapReduce, Hive and Pig, as well as free apps and utilities for numerical analysis, publishing data sets, data encryption, uploading files to SQL Azure and blobs.
[画像:VSM1106Cover90px2]New Migration Paths to the Microsoft Cloud (June 2011)
Will emerging developer tools and hybrid Platform as a Service features ramp up project and data deployments to Windows Azure?
You can review missing Figure 3 about Concero in an OakLeaf blog post here.
Get ready to scale out SQL Azure databases beyond today's 50GB limit with Transact-SQL and ADO.NET elastic sharding features coming in the 2011 SQL Azure Federation Community Technology Previews.
Learn how to store and retrieve binary large objects in the cloud with Azure's RESTful Storage API and sample C# StorageClient library.
Visual Studio 2008, ASP.NET, and the Azure Services Platform combine to simplify local development of data-intensive Web apps and automate their deployment in Microsoft data centers. The result: You get maximized availability and reliability with almost limitless on-demand scalability, while you pay only for resources consumed.
LINQ to SQL continues to be a top contender in the .NET object/relational mapping tool market despite Microsoft's promotion of the Entity Framework as one of the "Pillars of SQL Server 2008: Dynamic Development.”
Visual Studio 2008 Service Pack 1's new ASP.NET Dynamic Data templates automatically generate code for DataGrid, ListView, DetailsView, and FormView display and editing controls on dynamic pages derived from a master page and CSS stylesheet. Dynamic Data leverages AJAX to smooth page transitions and delivers scaffolding for codeless, key-based page routing with Entity Framework or LINQ to SQL object/relational mapping tools.
Microsoft readies its new "cloud database" by hosting beta versions of REST and SOAP protocols for performing CRUD operations on clustered, customized SQL Server 2008 instances. These instances are organized as massively scalable, super-reliable, highly available Web services.
ADO.NET Data Services (formerly code-named "Project Astoria") delivers data from relational tables and Windows Live services to Web mashups and Visual Studio 2008 projects, including ASP.NET AJAX and Silverlight 2.0 rich Internet applications, as Representational State Transfer (REST) resources over HTTP in response to URI-based requests or LINQ to REST queries.
Model Domain Objects with the Entity Framework (March 2008)
Microsoft's ADO.NET Team readies Entity Framework and Tools 1.0 for release as a VS 2008 add-in with enterprise-level features that LINQ to SQL doesn't offer -- domain object modeling, flexible inheritance techniques, multiple database vendors, and do-it-yourself n-tier deployment.
"Do-it yourself n-tier deployment" refers to Daniel Simmons' Entity Bag (Perseus) project, which is covered by a sidebar.
Find out how VS 2008's greatly expanded feature set and new .NET Fx 3.5 namespaces can boost your career as a professional developer and add to your programming enjoyment.
Additional VS 2008 articles in the January 2008 issue:
Persisting business objects to sQL Server 2005 or later with object/relational mapping by LINQ to SQL can extract a performance Penalty. Learn how to take maximum advantage of LINQ's strongly typed query capabilities without overtaxing the database server or losing front-end agility.
The Microsoft Synchronization Services 1.0 API for SQL Server 2005 Compact Edition and the new Sync Designer in the Orcas March 2007 CTP team up to generate a local data cache that synchronizes incrementally and bidirectionally with SQL Server [Express].
Put local data storage on a resource diet and improve performance with the newly upgraded (and free) SQL Server 2005 Compact Edition.
The ADO.NET vNext August 2006 Community Technical Preview reincarnates ObjectSpaces’ object/relational mapping technology and OPath query language as the Entity Framework, Entity Data Model, Entity SQL, and LINQ to Entities for the Visual Studio “Orcas” release.
SQL Server 2005’s versatile Service Broker infrastructure enables asynchronous messaging between databases and server instances, handles database server event notifications, responds to database change notifications, and sends Database Mail.
The January 2006 Language Integrated Query (LINQ) preview for the next ("Orcas") version of Visual Basic enables automating SQL Server object-relational mapping for DLinq and enhances XLinq syntax for literal XML and late binding.
Add Reports and Charts to Web Pages (March 2006)
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.
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.
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.
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.
Use Microsoft's TerraService and MapPoint Web Services to start your own VS.NET-based Windows form mapping projects.
Persist DataSets of lookup information as local XML files so disconnected laptop and Pocket PC users can search and update DataSets quickly.
InfoPath SP1 and the new .NET 2003 Toolkit let you implement business logic behind InfoPath forms with managed VB.NET or C# code instead of JScript or VBScript event handlers.
Take a running start at developing applications for the next Windows OS.
Numerical test data with real-world data objects can help you choose a data-access methodology that maximizes the database's overall performance.
Cover story thumbnails for issues earlier than November 2003 aren't available at this time.
Posted by Roger Jennings (--rj) at 10:04 AM 0 comments
Labels: ADO.NET Data Services, Astoria, Azure, Azure Data Services, Cloud Computing, Entity Framework, LINQ, LINQ to SQL, OData, Open Data Protocol, SQL Azure, SQL Server 2005, SQL Server 2005 Express, SQL Server 2008 R2, Visual Studio, Visual Studio Magazine, Windows Azure
Thursday, October 22, 2009
SQL Azure October 2009 CTP Signup Clarification
Update 10/23/2009: Workaround for can’t select database from SQL Server Management Studio’s Available Databases list (see end of post) and reduction of number of databases per subscription from five to four.
If you have a SQL Server Data Services (SSDS), SQL Data Services (SDS), or SQL Azure August or earlier CTP account, you’ll probably receive (or have received) mail similar to the following from the ssdstlk@microsoft.com alias:
Following the https://sal.azure.com link leads to you the new SQL Azure landing page:
In this case you have been pre-assigned a new SQL Azure subscription, so there is no text box or other control into which you can paste your invitation code GUID. If you haven’t participated in an earlier SSDS, SDS or SQL Azure CTP, you can paste the GUID into a text box to create a new subscription.
Note: Clicking the Billing link throws an HTTP 404 error.
Clicking your earlier project name, such as mine (SDS-only CTP Project) from the original 2008 SSDS CTP shown above, generates a request to accept new terms and conditions followed by a dialog to add a new SQL Azure administrator account and password for an automatically named server. (Note: Administrator, Admin and other well-known admin names aren’t allowed.)
Add Up to (削除) Five (削除ここまで) Four Databases to Your Server
The SQL Azure button then gains a Database sub-button, which you click to display Server Information and Databases/Firewall tabs. Click Create database to open a new-database dialog with a name text box and size list with 1GB and 10GB choices:
Adding a database and selecting its radio button enables the Connection String button, which opens a connection string panel with Copy to Clipboard buttons for ADO.NET and ODBC data sources:
August 2009 CTP subscriptions support up to four (削除) five (削除ここまで) 1-GB databases. Alejandro Hernandez wrote on 10/23/2009 in response to my How to Add a Subscription from a Second Invitation Code for the October CTP? thread of the same date:
During the CTP time frame until PDC you will not be able to create more than one Server. You can create up to 4 databases for now (later on the cap will increase).
If you really need more servers/subscriptions now, you will need to register with a different Live ID and get a new invitation code.
Perforate the Firewall to Connect to SQL Azure
You also need to perforate the firewall to allow server connections from Windows Azure projects by marking the strangely named Allow Microsoft Services check box to specify an IP range of 0.0.0.0 to 0.0.0.0.
Clicking Add Record opens a dialog to enable access by specific IP address ranges. The IP address of the computer you use access the portal appears in the dialog, as shown here:
Note: Don’t forget to open a hole for TCP/IP port 1433 in your client-side firewalls for premises-based applications that access SQL Azure.
You’re now ready to connect to the database with SQL Management Studio 2005+ [Express] or George Huey’s SQL Server Migration Wizard (MigWiz) that’s been upgraded to the new CTP in v1.4. The new MigWiz version supports SQL Server’s Bulk Copy Protocol (BCP).
Access Databases in Earlier SQL Azure CTPs
Access your earlier SQL Azure instance by logging in with your Live ID credentials at https://ctpportal.database.windows.net. Only the database(s) you created with a previous SQL Azure CTP appear in the Server Administration page:
Notice the new ctpportal URL prefix for earlier CTP (CTP1) servers.
Updated SQL Azure documentation for the October 2009 CTP (a.k.a. CTP2) is here.
New Users: You Must Use SQL Server Authentication and Create a New Query in SSMS to Log In
SQL Azure doesn’t accept Windows Authentication (Trusted_Connection=True). You must log in with the admistrator Login ID and passwork you created when establishing your subscription:
If you’re new to SQL Azure, you’ll find that attempts to log in with your administrator credentials fail with a fatal “Invalid object name ‘sys.configurations’ (Microsoft SQL Server, Error: 208)” error message:
To work around this error, Click the New Query button to open a new query window and repeat the login process. SQL Azure doesn’t work with the current version of SSMS’s Object Browser (2005 or 2008).
Update: You Must Select the Database (Other Than Master) as an Option When Connecting with SSMS
Attempts to connect to databases other than master with the Available Databases list fail silently in SSMS [Express] 2005 or with an “The database DatabaseName is not accessible” error in SSMS [Express] 2008. You must specify the database name when (re)creating the query’s connection:
Logins time out after about five minutes of inactivity. Right-click the query window and choose Connection, Connect to reconnect or Connection, Change Connection to change the active database.
The \WROX\Azure\Chapter13\InstNwndFromNorthwindOrig.sql script runs without error in the SQL Azure October 2009 CTP. Execution time is about 40 seconds with a moderate-speed DSL connection.
Posted by Roger Jennings (--rj) at 3:49 PM View Comments
Labels: Azure, SQL Azure, SQL Azure Database, SQL Azure Migration Wizard, SQL Server, SQL Server 2005, SQL Server 2005 Express, SQL Server 2008, SQL Server 2008 R2
Friday, July 17, 2009
Visual Studio Magazine Article Retrospective
Following are images of Visual Studio Magazine issues from late 2003 to the present for which I've written cover stories. Each entry includes the article name and deck. Click the image to open the article from the Visual Studio Magazine Web site.
Updated 6/28/2008: As of early 2008, archives of articles earlier than October 2006 are no longer available from Redmond Media Group, so they are delivered as archived Web pages from the Wayback Machine.
All but one of the Wayback Machine archives are the single-page print version and have working links to Additional Resources, tables, and listings. All figures have captions and most have the original diagram or screen capture. Sample code is not accessible from Wayback Machine archives.
Learn how to store and retrieve binary large objects in the cloud with Azure's RESTful Storage API and sample C# StorageClient library.
Visual Studio 2008, ASP.NET, and the Azure Services Platform combine to simplify local development of data-intensive Web apps and automate their deployment in Microsoft data centers. The result: You get maximized availability and reliability with almost limitless on-demand scalability, while you pay only for resources consumed.
LINQ to SQL continues to be a top contender in the .NET object/relational mapping tool market despite Microsoft's promotion of the Entity Framework as one of the "Pillars of SQL Server 2008: Dynamic Development.”
Visual Studio 2008 Service Pack 1's new ASP.NET Dynamic Data templates automatically generate code for DataGrid, ListView, DetailsView, and FormView display and editing controls on dynamic pages derived from a master page and CSS stylesheet. Dynamic Data leverages AJAX to smooth page transitions and delivers scaffolding for codeless, key-based page routing with Entity Framework or LINQ to SQL object/relational mapping tools.
Microsoft readies its new "cloud database" by hosting beta versions of REST and SOAP protocols for performing CRUD operations on clustered, customized SQL Server 2008 instances. These instances are organized as massively scalable, super-reliable, highly available Web services.
ADO.NET Data Services (formerly code-named "Project Astoria") delivers data from relational tables and Windows Live services to Web mashups and Visual Studio 2008 projects, including ASP.NET AJAX and Silverlight 2.0 rich Internet applications, as Representational State Transfer (REST) resources over HTTP in response to URI-based requests or LINQ to REST queries.
Model Domain Objects with the Entity Framework (March 2008)
Microsoft's ADO.NET Team readies Entity Framework and Tools 1.0 for release as a VS 2008 add-in with enterprise-level features that LINQ to SQL doesn't offer -- domain object modeling, flexible inheritance techniques, multiple database vendors, and do-it-yourself n-tier deployment.
"Do-it yourself n-tier deployment" refers to Daniel Simmons' Entity Bag (Perseus) project, which is covered by a sidebar.
Find out how VS 2008's greatly expanded feature set and new .NET Fx 3.5 namespaces can boost your career as a professional developer and add to your programming enjoyment.
Additional VS 2008 articles in the January 2008 issue:
Persisting business objects to sQL Server 2005 or later with object/relational mapping by LINQ to SQL can extract a performance Penalty. Learn how to take maximum advantage of LINQ's strongly typed query capabilities without overtaxing the database server or losing front-end agility.
The Microsoft Synchronization Services 1.0 API for SQL Server 2005 Compact Edition and the new Sync Designer in the Orcas March 2007 CTP team up to generate a local data cache that synchronizes incrementally and bidirectionally with SQL Server [Express].
Put local data storage on a resource diet and improve performance with the newly upgraded (and free) SQL Server 2005 Compact Edition.
The ADO.NET vNext August 2006 Community Technical Preview reincarnates ObjectSpaces’ object/relational mapping technology and OPath query language as the Entity Framework, Entity Data Model, Entity SQL, and LINQ to Entities for the Visual Studio “Orcas” release.
SQL Server 2005’s versatile Service Broker infrastructure enables asynchronous messaging between databases and server instances, handles database server event notifications, responds to database change notifications, and sends Database Mail.
The January 2006 Language Integrated Query (LINQ) preview for the next ("Orcas") version of Visual Basic enables automating SQL Server object-relational mapping for DLinq and enhances XLinq syntax for literal XML and late binding.
Add Reports and Charts to Web Pages (March 2006)
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.
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.
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.
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.
Use Microsoft's TerraService and MapPoint Web Services to start your own VS.NET-based Windows form mapping projects.
Persist DataSets of lookup information as local XML files so disconnected laptop and Pocket PC users can search and update DataSets quickly.
InfoPath SP1 and the new .NET 2003 Toolkit let you implement business logic behind InfoPath forms with managed VB.NET or C# code instead of JScript or VBScript event handlers.
Take a running start at developing applications for the next Windows OS.
Numerical test data with real-world data objects can help you choose a data-access methodology that maximizes the database's overall performance.
Cover story thumbnails for issues earlier than November 2003 aren't available at this time.
Technorati Tags: Databases,SQL Server 2005,SQL Server , SQLServer,SQL Server 2005 Express,SQL Express , SQLX , MSSQL , SQL Server Service Broker , Service Broker,Query Notifications , Database Mail , LINQ,LINQ to SQL,DLinq , LINQ to XML , XLinq , Visual Studio 2005 , Visual Studio,VS 2005,Web Services , ReportViewer Control , ReportViewer,XML Data Type , XQuery , XML , TerraService,TerraServer , MapPoint,Dataset , Longhorn,WinFS , Indigo , Avalon, Ego Trip
Posted by Roger Jennings (--rj) at 5:15 PM 0 comments
Labels: Database Mail, Databases, Fawcette, FTP, LINQ, Query Notifications, ReportViewer, Service Broker, SQL Server 2005, SQLX, VS 2005, Web Services, XML, XQuery