https://www.developerfusion.com/t/sql/ Latest SQL developer content from Developer Fusion http://www.rssboard.org/rss-specification en-GB Wed, 30 May 2012 10:44:59 GMT Squeel provides a comprehensive DSL for writing SQL queries in Ruby. It is built upon Arel giving you access to many of its powerful features. http://www.developerfusion.com/media/143610/354-squeel/ http://www.developerfusion.com/media/143610/354-squeel/ Wed, 30 May 2012 10:44:59 GMT James Crowley In this extract from Beginning Microsoft SQL Server 2012 Programming, the authors demonstrate how to create a 'simple' OLAP cube using the AdventureWorks database as the data source http://www.developerfusion.com/article/143031/building-your-first-data-cube/ http://www.developerfusion.com/article/143031/building-your-first-data-cube/ Fri, 11 May 2012 12:35:03 GMT Dan Maharry We have several spots open for top notch .NET / C# / MVC developers to join our team as we continue to change the face of online recruiting. The base technology set is Microsoft-centric (.NET / C# / SQL Server / MVC) http://www.developerfusion.com/job/134600/net-web-developer/ http://www.developerfusion.com/job/134600/net-web-developer/ Wed, 14 Dec 2011 14:13:01 GMT Chris Piazza **** This is a full-time position based on the Ko Samui Island, Thailand. We will cover relocation costs, including flights, visa, work permit, etc. We speak English in the office.**** JOB OPENING – SENIOR WEB ENGINEER (PHP) http://www.developerfusion.com/job/134303/senior-php-web-engineer/ http://www.developerfusion.com/job/134303/senior-php-web-engineer/ Thu, 08 Dec 2011 11:51:04 GMT Gina Sharpe Looking for a business partner to join a promising start up on a equity/deferred payment/part equity part cash basis. http://www.developerfusion.com/job/134156/web-developer/ http://www.developerfusion.com/job/134156/web-developer/ Thu, 08 Dec 2011 11:51:03 GMT aditya mukherjee Windows PowerShell transformed the way administrators and developers interact with Windows, allowing them to script administrative tasks and control Windows from the command line. It's now a daily timesaver for anyone working with Windows Server, Exchange Server, SQL Server, and other mission-critical tools. http://www.developerfusion.com/book/134299/windows-powershell-in-action-second-edition/ http://www.developerfusion.com/book/134299/windows-powershell-in-action-second-edition/ Thu, 08 Dec 2011 04:38:41 GMT Bruce Payette Feature-complete and production-ready database ready for user testing http://www.developerfusion.com/news/133327/sql-server-2012-release-candidate-arrives/ http://www.developerfusion.com/news/133327/sql-server-2012-release-candidate-arrives/ Mon, 28 Nov 2011 17:13:14 GMT Chris Alexander Split your apps between on-site and the cloud http://www.developerfusion.com/news/130794/sql-azure-data-sync-opens-up/ http://www.developerfusion.com/news/130794/sql-azure-data-sync-opens-up/ Mon, 17 Oct 2011 08:45:58 GMT Chris Alexander Big Data in the Cloud http://www.developerfusion.com/news/130253/apache-hadoop-coming-to-azure/ http://www.developerfusion.com/news/130253/apache-hadoop-coming-to-azure/ Thu, 13 Oct 2011 13:03:04 GMT Chris Alexander Bradford Stephens is Co-Chair of OSCON Data and CEO of Drawn to Scale, creators of Spire, the "Real-Time Big Data" cloud Platform. Bradford discusses why we need ways of handling very large distributed data sets, why SQL doesn't quite work anymore, and the possibilities that lie at the intersecti. http://www.developerfusion.com/media/124759/david-mertz-oscon-2011-interviews-bradford-stephens-cochair-of-oscon-data/ http://www.developerfusion.com/media/124759/david-mertz-oscon-2011-interviews-bradford-stephens-cochair-of-oscon-data/ Tue, 23 Aug 2011 23:12:18 GMT James Crowley Roger Hart looks back at Red Gate's inclusion of SQL Azure into its database applications, the issues they encountered and the solutions they created http://www.developerfusion.com/article/124751/to-the-cloud-moving-red-gate-tools-to-sql-azure/ http://www.developerfusion.com/article/124751/to-the-cloud-moving-red-gate-tools-to-sql-azure/ Tue, 23 Aug 2011 20:17:02 GMT Roger Hart Master the XML Programming Features in Oracle Database 11gDevelop, debug, and administer data-backed XML applications using the expert instruction and best practices in this Oracle Press guide. Oracle Database 11g: Building Oracle XML DB Applications discusses the latest development tools, technologies, and components. Find out how to set up Oracle XML Database (Oracle XML DB), build XML applications in Oracle JDeveloper 11g, work with XSLT stylesheets, and incorporate full-text search. http://www.developerfusion.com/book/123046/oracle-database-11g-building-oracle-xml-db-applications-osborne-oracle-press-series/ http://www.developerfusion.com/book/123046/oracle-database-11g-building-oracle-xml-db-applications-osborne-oracle-press-series/ Wed, 27 Jul 2011 19:55:37 GMT Jinyu Wang In the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get 'close to the metal' when it comes to persisting data. However, when you need to squeeze the last ounce of performance out of your app - it can make sense to go under the covers. http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ Tue, 19 Jul 2011 11:14:34 GMT Mike Goatly Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. http://www.developerfusion.com/book/122470/expert-oracle-goldengate/ http://www.developerfusion.com/book/122470/expert-oracle-goldengate/ Mon, 18 Jul 2011 16:44:29 GMT Ben Prusinski, Steve Phillips, Richard Chung Improvements to the latest SQL Server release and juicy new previews http://www.developerfusion.com/news/122217/sql-server-denali-ctp3-and-2008-r2-sp1-land/ http://www.developerfusion.com/news/122217/sql-server-denali-ctp3-and-2008-r2-sp1-land/ Thu, 14 Jul 2011 09:08:15 GMT Chris Alexander Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. http://www.developerfusion.com/book/122015/expert-oracle-application-express/ http://www.developerfusion.com/book/122015/expert-oracle-application-express/ Sun, 10 Jul 2011 18:05:51 GMT Dietmar Aust, Martin Giffy DSouza, Doug Gault, Dimitri Gielis, Roel Hartman, Michael Hichwa, Sharon Kennedy, Denes Kubicek, Raj Mattamal, Dan McGhan, Francis Mignault, Anton Nielsen, John Scott The most common giveaway a user experiences when an enterprise application has been moved to the cloud is the sudden appearance of a username/password dialogue box. http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure/ http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure/ Mon, 04 Jul 2011 12:38:16 GMT Steve Plank The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. http://www.developerfusion.com/book/121505/sql-programming-joes-2-pros-programming-development-for-microsoft-sql-server-2008-sql-exam-prep-series-70433-volume/ http://www.developerfusion.com/book/121505/sql-programming-joes-2-pros-programming-development-for-microsoft-sql-server-2008-sql-exam-prep-series-70433-volume/ Sat, 02 Jul 2011 16:03:01 GMT Rick A. Morelan We introduce one of the simplest services in Azure to get to grips with - the message queue service http://www.developerfusion.com/article/120197/using-the-queuing-service-in-windows-azure/ http://www.developerfusion.com/article/120197/using-the-queuing-service-in-windows-azure/ Tue, 07 Jun 2011 14:03:33 GMT Brian Prince Curt Cotner is an IBM Fellow as well as VP and CTO for Database Servers at IBM. He's joins the podcast to talk about DB2 SQL Skin, which is all about reducing the cost and risk of moving applications from Sybase to DB2. He talks about the challenges of migrating, and how DB2 SQL Skin makes it sim. http://www.developerfusion.com/media/119868/curt-cotner-on-easier-migration-with-db2-sql-skin/ http://www.developerfusion.com/media/119868/curt-cotner-on-easier-migration-with-db2-sql-skin/ Sun, 29 May 2011 14:51:12 GMT James Crowley