Rob Tiffany

Tag Archive: Microsoft

Consumerization of IT Collides with MEAP: Windows > On-Premises

The Consumerization of IT is an unstoppable force where employees are bringing every kind of mobile device imaginable into the office expecting to be productive. Over the course of the next 20 articles, I’ll describe how IT professionals can use…
Read more

VB3

Happy 20th Birthday Visual Basic :: VB Under the Sea

In what turned out to be the most important decision I’ve ever made in my computing career, I bought that copy of VB and proceeded to teach myself how to use it.

Submarine

Windows Phone 7 Line of Business App Dev :: Uploading Data back to Azure

Looking back over the last 6 months of this series of articles, you’ve created wireless-efficient WCF REST + JSON Web Services in Azure to download data from SQL Azure tables to Windows Phone. You’ve maintained in-memory collections of objects in…
Read more

Windows Phone 8 Tiles

What the new App Hub in Windows Phone Mango means for the Enterprise

If you attended MIX 11 or watched it on Channel 9, you might have seen Todd Brix’s session titled “Making Money with your Applications on Windows Phone.” In this session, Todd talked about all the great things Windows Phone users…
Read more

Microsoft MEAP

Confronting the Consumerization of IT with Microsoft MEAP

CIOs are asking for help in confronting the tidal wave of mobile devices entering the enterprise and IT departments have raised the white flag as attempts to block consumer-focused smartphones and tablets have failed. The Consumerization of IT has been…
Read more

SQL Server

SQL Server Compact 4.0 Lands on the Web

With the new version 4.0, the little-database-that-could has grown up into a powerful server database ready to take on the web.

Primary Key

Reducing SQL Server Sync I/O Contention :: Tip 3

Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is uniquely identified by its Primary Key.

Database Storage

Reducing SQL Server I/O Contention during Sync :: Tip 2

All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.

SAN Storage

Reducing SQL Server I/O Contention during Sync :: Tip 1

The act of tracking changes made by each SQL Server Compact or Silverlight sync subscriber can cause a lot of locking and blocking on the server.