SSWUGtv With Stephen Wynkoop On the show today we have Kevin Kline as he shares his thoughts on why Big Data is important Watch the Show Is it Time for ORMs? Object Relational Mapping tools have been around for years, and are still a controversial issue. Coming from a DBA background I find them to be both a friend and […]

Database Version Compatibility Today we have a couple comments that I found quite interesting. Robert talks about the ORDER BY clause in Views being supported, deprecated, and returned once again. Sanders shares thoughts about using features beyond those ANSI defines for SQL Engines. Robert writes: ORDER BY IN VIEWS! First it was there, then it was gone, then it was […]

Backwards Compatibility Backwards Compatibility is the mirror image of the problem introduced yesterday. The problem we have with Forward Compatibility is the ability to use new features, and emulate those features using creative techniques in older versions that do not support the new features. This goal is often not possible for one reason or another. An example of Forward or […]

Forwards Compatibility In response to yesterday’s editorial I received a number of comments regarding backwards compatibility. I have been working with Microsoft SQL Server since version 4.21. Unlike many products I have used, SQL Server has been very generous in supporting deprecated features. Generally, the status of a feature is made known long before the product no longer supports it; […]

Database Upgrades With the recent release of SQL Server 2012 you now have more opportunities with your installations. Now the questions of upgrades, support for earlier versions, multiple version support, reverse compatibility and much more emerge once again. For those of you who have never experienced a release of a new version of SQL Server there is a lot to […]

SSWUGtv With Stephen Wynkoop In this episode Paul Zikopoulus with IBM – talking about big data, what it means, why it is important and much more. Watch the Show $$SWYNK$$ SQL Azure Federation Sharding I received a few questions about SQL Azure Federation today. My understanding is strictly through reading documentation materials from Microsoft…so be aware that I may be […]

SQL Azure Federations One of the coolest features in SQL Azure is Database Federations. Federations allow you to grow the power and size of your database in SQL Azure to an much larger scale than the largest single database allowed of 150Gig. For an overview of SQL Azure federations you can watch this into video from Microsoft demonstrating what Federations […]

What Can You Do With SQL Azure? One of the biggest risks of SMB database operations is the hosting of data. SQL Azure has been designed to fill that gap. But, it comes with a cost. The cost isn’t monetary alone. You lose a lot of capability in order to gain the shared benefit of a non-dedicated machine just for […]