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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×