https://www.developerfusion.com/t/sql/tutorials/ SQL Tutorials & Articles from Developer Fusion http://www.rssboard.org/rss-specification en-GB Fri, 11 May 2012 12:21:00 GMT 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:21:00 GMT Dan Maharry 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:04:00 GMT Roger Hart 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 10:43:00 GMT Mike Goatly 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:29:00 GMT Steve Plank 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/ Thu, 02 Jun 2011 08:56:00 GMT Brian Prince Neil Mackenzie looks at where Windows Azure fits among the various cloud computing offerings in the wild today, and also at the four key areas of Azure that new developers will need to be aware of when they start their first project. http://www.developerfusion.com/article/119329/overview-of-windows-azure/ http://www.developerfusion.com/article/119329/overview-of-windows-azure/ Tue, 17 May 2011 14:51:00 GMT Neil Mackenzie Running LINQ queries over databases gets all the limelight, but Jon Skeet reminds us of it's possibilities over object graphs too. http://www.developerfusion.com/article/84468/linq-to-log-files/ http://www.developerfusion.com/article/84468/linq-to-log-files/ Fri, 14 Jan 2011 13:37:00 GMT Jon Skeet Persisting objects is all about SLOB (serialized large objects), or so says Dave Wheeler who explains how it's now all so much easier. http://www.developerfusion.com/article/84431/slobbing-about-with-net/ http://www.developerfusion.com/article/84431/slobbing-about-with-net/ Mon, 22 Nov 2010 12:26:00 GMT Dave Wheeler Kevin Jones thinks that the key idea in Rails is routing. See how this fits in with the MVC pattern and find out more about Rails by reading on. http://www.developerfusion.com/article/84417/rails-mvc-and-routing/ http://www.developerfusion.com/article/84417/rails-mvc-and-routing/ Tue, 02 Nov 2010 11:33:00 GMT Kevin Jones Joydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them. http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ Thu, 23 Sep 2010 10:54:00 GMT Joydip Kanjilal XML, which is all about tree structures, and LINQ, which is all about querying collections, might not seem to fit together, but Mike James explains that they work together just fine. http://www.developerfusion.com/article/84298/linqing-to-xml/ http://www.developerfusion.com/article/84298/linqing-to-xml/ Fri, 23 Jul 2010 09:22:00 GMT Mike James Kevin Jones explains how ActiveRecord works in Rails, and in a standalone Ruby application. http://www.developerfusion.com/article/84435/activerecord-for-ruby-and-rails/ http://www.developerfusion.com/article/84435/activerecord-for-ruby-and-rails/ Fri, 16 Jul 2010 10:07:00 GMT Kevin Jones There is a lot of interest in DDD recently, both in the book, and in the methodology, and in the buzzword. Casey aims to clear up the confusion and start to demystify it. http://www.developerfusion.com/article/9794/domain-driven-design-a-step-by-step-guide-part-1/ http://www.developerfusion.com/article/9794/domain-driven-design-a-step-by-step-guide-part-1/ Fri, 13 Feb 2009 11:02:00 GMT Casey Charlton Where is Web Development moving to in the future? http://www.developerfusion.com/article/78919/the-next-generation-of-web-development/ http://www.developerfusion.com/article/78919/the-next-generation-of-web-development/ Thu, 01 Jan 2009 00:00:00 GMT James Crowley Combine forces and be stronger as a small business http://www.developerfusion.com/article/78920/the-need-for-partnership-as-a-small-business/ http://www.developerfusion.com/article/78920/the-need-for-partnership-as-a-small-business/ Thu, 01 Jan 2009 00:00:00 GMT James Crowley You've heard the hype - but not given it a shot yet? Kevin Jones explains the background of MVC, DRY and TDD and how to get started with your first Ruby on Rails web app! http://www.developerfusion.com/article/9409/rails-an-introduction/ http://www.developerfusion.com/article/9409/rails-an-introduction/ Mon, 08 Dec 2008 11:05:00 GMT Kevin Jones Ever wondered how the magic "yield" statement works? Jon Skeet digs into the inner workings of C# 2.0 and how this innocuous statement gets you a whole load of "free" generated code for your iterators. http://www.developerfusion.com/article/9397/iterator-blocks-in-c-2-autogenerated-state-machines/ http://www.developerfusion.com/article/9397/iterator-blocks-in-c-2-autogenerated-state-machines/ Wed, 03 Dec 2008 11:50:00 GMT Jon Skeet Jason takes you back to those high school geometry lessons and demonstrates how to take advantage of the new geospatial and geometric data types in SQL Server 2008. http://www.developerfusion.com/article/8325/spatial-data-in-sql-server-2008/ http://www.developerfusion.com/article/8325/spatial-data-in-sql-server-2008/ Wed, 22 Oct 2008 16:11:00 GMT Jason Follas Pretend you know what you're talking about in suitably geeky company. More seriously, it will give you a very rough overview to give some context if you choose to investigate a particular feature further. http://www.developerfusion.com/article/8288/bluffers-guide-to-c-3/ http://www.developerfusion.com/article/8288/bluffers-guide-to-c-3/ Mon, 13 Oct 2008 14:00:00 GMT Jon Skeet Mike James explains that LINQ isn’t just for SQL programmers but is usable by every .NET developer. Learn how take the power of LINQ queries to your every-day coding through the lowly IEnumerable interface. http://www.developerfusion.com/article/8250/linq-to-objects-for-the-net-developer/ http://www.developerfusion.com/article/8250/linq-to-objects-for-the-net-developer/ Wed, 08 Oct 2008 15:17:00 GMT Mike James