ODBC to Become the New Microsoft SQL Server Connectivity Standard Microsoft has announced that it will be phasing out support for the proprietary OLE DB database driver in SQL Server. This is a bit of old news…but something you are going to need to take into account sooner or later. The next release of SQL Server code named Denali will […]

SSWUG TV With Stephen Wynkoop Today on SSWUG TV find out some of the latest news from the Sharepoint 2011 and the Oracle OpenWorld 2011 Conferences. Watch the Show SQL Server Migration Today we have some questions and comments regarding SQL Server Upgrades. Stephen: What Version of SQL Server are you talking about? Stacy: During our last migration to SQL […]

Are you ready to migrate? The next release of SQL Server is drawing closer to release. My mind naturally turns towards upgrades. The SQL Server migration tools of the last couple releases have made the transition much easier to make. The database files themselves were much easier to handle than modifications to Reporting Services or Integration Services. For those still […]

The Terms Overlap As we’ve been considering Database Appliances a number of terms, techniques, problems and solutions continue to overlap. We see terms like Cloud, Appliance, Parallel Processing, Distributed data, Structured data, Big Data and distributed processing continue to appear with different implementations behind each. None of these terms are mutually exclusive as I see it. Different offerings take a […]

Database Appliances Yesterday as I started the discussion around Appliances. I found it difficult to characterize the concept of Appliance and the different vendors providing these resources. Generally you could say appliances form the foundation for a private cloud offering while reducing the cost of designing and maintaining the configuration due to some form of standardization. I don’t have a […]

SSWUG TV With Stephen Wynkoop Don’t miss this Interview with Mark Tabladillo, SQL Server MVP and acclaimed data mining instructor. Watch the Show Database Appliances One of the trends from vendors that seems to be growing is the database appliance. Different vendors are providing pre-defined systems individually or with strategic alliances. Oracle has taken the approach of having a single […]

SSWUG TV With Stephen Wynkoop What, Mango on the Windows Phone? Check it out on SSWUG TV. Map Reduce Explained David shares more insight into the history of the Map Reduce pattern. His practical explanation should provide some ideas for how you can utilize this pattern in your own systems. David Writes: The description of Map and Reduce is not […]

MapReduce – A Key to NoSQL Performance If you have been following the trend of my editorials these last few weeks, it will all start to come together today. While NoSQL and MapReduce are not necessarily linked, they are often combined to increase performance. MapReduce is a pattern allowing large chunks of data to be broken up into smaller chunks […]

NoSQL Data Stores, Readers Want More First a little housekeeping. I think it’s interesting that many of the newer data storage engines are labeled as “NoSQL”. Before these engines came along there have been a number of highly successful NoSQL databases that are difficult to beat for performance. For example, IDMS or CMS running on the IBM Mainframe platform has […]

Where Did NoSQL Come From? I enjoyed listening to a podcast today of an interview with Jonathan Ellis , who is the project chair for the open systems NoSQL data engine, Cassandra. During the interview, Jonathan related different events causing companies to move away from traditional relational data stores. This is not to say that NoSQL data stores didn’t exist […]