Subscribe to this list via RSS Blog posts tagged in SQL Server
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...

Posted by on in Blogs
Ad-hoc SQL/POCO Queries in Entity Framework 4.0 Since version 4.0, the Entity Framework has had the ability to query un-mapped data and project it onto POCOs using ad-hoc SQL. Here, for example, is how we check the current SQL Server version: internal class SqlVersionInfo { public string Edition { get; set; } public string ProductLevel { get; set; } public string ProductVersion { get; set; } } private static SqlVersionInfo GetSqlServerVersion(ObjectContext conte...

Posted by on in Blogs
Sometimes, SELECT Really Is Broken We got a bug report from a customer the other day; a certain query in one of our web services was giving the following error: A column has been specified more than once in the order by list. Columns in the order by list must be unique. Seems clear enough, except that There was no duplication in the ORDER BY. Our DBA discovered that the "problem" reference was [Project2].[C5] ASC, which is an alias, not a real DB column name. It certainly appeared only once, but removing it made the error ...
Back from my World and Texas RAD Studio XE2 tours - Webinars Tuesday (tomorrow) I am finally back in my Scotts Valley office today after three weeks on the road visiting with great developers on three continents and on the Internet.  Many thanks to all of you that spent your valuable time with me and all of the other RAD Studio XE2 World Tour evangelists.  Just want to remind you that there are only 4 more days until the end of September.  If there was a special offer at a tour stop, now is the time to use it before it goes away.  There are several ways to buy - all of the ...

Posted by on in Blogs
Want more...Platforms Platform is one the most overloaded terms in computer technology. When someone talks about supporting a platform they might be referring to an operating system platform, hardware platform, mobile platform, database platform, graphics hardware and software platform, service based platform, application based platform, a framework, or an architecture.  Operating system platforms in use today include Windows (desktop, server, and Mobile), Linux, OS X, iOS, Android, Blackberry OS, Unix (and it's vari...
Developer Christmas Countdown - December 22 - T minus 3 days December 22 - 3 days until Christmas.  I can almost hear the reindeer on my roof. I am out of the office, now, until after the first of the year.  But, that doesn't mean that I am off the computer, off email or off my blog.  No matter where I am in the world, I can almost always stay connected to the development world. We're past the Winter Solstice in the northern hemisphere. Christmas is just around the corner. On Demand Webinar Replays If you have time off too, you might consider usi...
Developer Christmas Countdown - December 11 - T minus 14 days December 11 - Special promotions expire in 20 days!  Database Tools for Major DBMS Platforms. It's getting exciting around here.  There are only weeks until Christmas Day.  Next week, I will don my Santa suit and appear in our San Francisco and Scotts Valley offices.  Also, there are only 20 more days until all of Embarcadero's year end special promotions are over.  We have special promotion pricing for you to upgrade your developer tools.  When you upgrade or buy new licenses, you also get y...
This is the LAST DAY - special offers for Delphi, C++Builder, RAD Studio developers! Okay! I have been blogging the top 10 reasons to take advantage of our Delphi, C++Builder and RAD Studio offers. I have been counting down the days left in these promotions. This is it! This is there last day to take advantage of the Delphi, C++Builder and RAD Studio special offers. Today is June 28, 2010 - the last day for these offers. Following the format of the "Late Show with David Letterman Top Ten list", here are the "number 1" reasons to use Delphi, C++Builder, Delphi Prism and RAD Studi...
2 days left - special offers for Delphi, C++Builder, RAD Studio developers! There are only 2 days left to take advantage of the Delphi, C++Builder and RAD Studio special offers. The last day to take advantage of the offers is June 28, 2010. Following the format of the "Late Show with David Letterman Top Ten list", here are the "number 2" reasons to use Delphi, C++Builder, Delphi Prism and RAD Studio. 2. Delphi - Speed your way from prototype to production – get your ideas started fast with rapid prototyping using the time-tested, extensible, rich and full-featured V...
3 days left - special offers for Delphi, C++Builder, RAD Studio developers! There are only 3 days left to take advantage of the Delphi, C++Builder and RAD Studio special offers. The last day to take advantage of the offers is June 28, 2010. Following the format of the "Late Show with David Letterman Top Ten list", here are the "number 3" reasons to use Delphi, C++Builder, Delphi Prism and RAD Studio. 3. Delphi - Free your customers from keyboards with dazzling touch based UIs – Rapidly build touch based GUI, tablet, touchpad, and kiosk applications, and easily touch...

Check out more tips and tricks in this development video: