Dino Esposito

Dino
Esposito

Dino Esposito is CTO of e-tennis.net, specialists in web and mobile solutions for professional sports. He is also author of Programming Microsoft ASP.NET MVC3 (Microsoft Press) and is a trainer and consultant specializing in web, social, and mobile integrated architecture and effective code design principles and practices. Dino blogs at .NET Architectonics. Follow Dino on Twitter: @despos

Articles
Managed Providers
Managed providers, a new type of data provider, are the only direct ADO.NET way to access data sources.
ADO.NET: A Bridge to the Future
You've heard about ADO's data-access object model for server platforms based on Windows 2000 and Windows NT. Now learn about ADO.NET for .NET-enabled platforms.
The XML Philosopher's Stone
With XML direct browsing, XML is automatically processed on the client, leaving the server free to fulfill other incoming requests.
Writing SAX Applications 1
Dino Esposito discusses writing a Visual Basic (VB) application that works with Simple API for XML (SAX).
How SAX Works
Take a brief look at how a Simple API for XML (SAX) parser works on XML documents.
XMLDOM vs. SAX Parsers
Learn the basic differences between two types of XML parsers.
Introducing Simple API for XML
Begin to explore Simple API for XML (SAX), an XML parser that follows a different logic from XMLCOM parsers.
The XML Query Language
Here's an overview of the specifications for XML Query Language, which is simpler than XSLT, has a richer syntax than XPath, and could be more powerful than either.
Programming XPath
Dino Esposito examines the XPath syntax as Microsoft has implemented it in Microsoft XML Parser (MSXML) 3.0 and the .NET platform.
Putting XPath into Perspective
Explore the basics of XPath, a query language for addressing, sorting, and filtering the elements and the text of an XML document.
Securing XML Documents
Learn the ins and outs of accessing XML data within and across IE security zones.
Working with XML Recordsets 2
Learn more about the XML schema used with ADO and some tricky aspects of the XML and ADO integration.
Integrating XML and ADO
Starting with version 2.1, ADO provides the ability to automatically persist recordsets in XML. Dino Esposito explores the benefits of this feature in B2B applications.
URL, URI, and URN 2
There are two types of URIs: URLs and URNs. Here's a brief summary and hints about when to use which.
Data Islands on IE 4.0
Explore two approaches to using XML data islands--one for IE 4.x and one for all other browsers that support HTML 3.2.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Availability Groups screenshot
Nov 11, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
Stretch SQL Server into Azure
Nov 5, 2014
blog

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×