Editorials

Are You Supporting Mobile SQL Server Applications?

New SQL Server Show Posted
Special: SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server – and how they work. This is a special airing of his session from the June Virtual Conference.

[ Watch the Show Now ]

Featured Article(s)
Oracle 2-Day DBA in x Days Post 10; Oracle Automatic Shared Memory Management
Chapter 5 of the 2-Day DBA Guide introduces us to Automatic Shared Memory Management. Let’s take it a step further by jumping ahead a few chapters, pulling some additional information from the administrators guide, and impart a bit of our own intelligence.

Are You Supporting Mobile Applications?
If so, you’ll want to see this article about developing for mobile applications. What I thought was really cool in this article was the talk about building "sometimes connected" applications, and what it means for the databases and data elements you’re creating.

Some of this is pretty straightforward – handling clashes between values, that type of thing. Some you may have already worked through with replication-type systems, as many of the challenges are similar. But the things that were really intriguing were the concepts they outlined as "relying on key connected moments" – the idea behind essentially gluing together a series of events that support the application being connected and able to complete a given set of work. Sort of what you’ve worked with when you’re building transaction-based applications- the rules and objectives of ACID-based transactions apply. But, in this case, it’s a thing of wrapping these types of concepts around a functional bit of work to do.

Great stuff – and worth reading if you’re now, or will be, working in a sometimes-connected application environment.

Featured White Paper(s)
Deploying Microsoft SQL Server in an iSCSI SAN
This Technical Report describes how to deploy SQL Server in an iSCSI SAN with PS Series storage arrays. It provides configura… (read more)

SharePoint: How It’s Leveraged and How It Works
This white paper will first examine how users, managers, and network administrators view and utilize SharePoint and it will l… (read more)