https://www.developerfusion.com/t/sql-server/tutorials/ SQL Server 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 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 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 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 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 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 A very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem. http://www.developerfusion.com/article/7305/dynamic-search-conditions-in-tsql/ http://www.developerfusion.com/article/7305/dynamic-search-conditions-in-tsql/ Sat, 01 Dec 2007 13:46:00 GMT Erland Sommarskog Hard coding passwords into your application or your web site is a bad thing. Barry looks at how we can use trusted connections to provide the authentication we need, without the need for these potential security hazards. http://www.developerfusion.com/article/7142/sql-trusted-connections-with-aspnet/ http://www.developerfusion.com/article/7142/sql-trusted-connections-with-aspnet/ Tue, 09 Oct 2007 21:05:00 GMT Barry Dorrans Learn how you can use an alternative session storage method, using SQL Server - very useful if you're running sites across multiple servers, or need session state to persist across application restarts. http://www.developerfusion.com/article/7140/using-sql-server-for-aspnet-session-state/ http://www.developerfusion.com/article/7140/using-sql-server-for-aspnet-session-state/ Tue, 09 Oct 2007 20:57:00 GMT Barry Dorrans In part one of this two part article, you will learn about five of the top ten “worst offenders” of misconfigurations of application security that can cause overall problems for ASP.NET Web-based applications. Learn more about how to secure the Web.config files of an ASP.NET application. http://www.developerfusion.com/article/6678/top-10-application-security-vulnerabilities-in-webconfig-files-part-one/ http://www.developerfusion.com/article/6678/top-10-application-security-vulnerabilities-in-webconfig-files-part-one/ Mon, 14 May 2007 21:05:00 GMT Bryan Sullivan The forthcoming 2007 Microsoft Office System offers many new opportunities for software developers. Matt Nicholson looks at the new user interface and the Open XML file format, finds out what's happened to VSTO, and explores the possibilities opened up by SharePoint Server 2007 and Groove 2007. http://www.developerfusion.com/article/6260/developing-for-office-2007/ http://www.developerfusion.com/article/6260/developing-for-office-2007/ Sun, 15 Oct 2006 12:23:00 GMT Matt Nicholson This tutorial shows how you can capture a document in SharePoint's document library, retrieve information from its properties and store in in SQL Server. It will teach you how to use Event Handler Toolkit. http://www.developerfusion.com/article/5613/sharepoint-document-library-and-sql-server/ http://www.developerfusion.com/article/5613/sharepoint-document-library-and-sql-server/ Wed, 19 Apr 2006 22:36:00 GMT S.S. Ahmed This article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices. http://www.developerfusion.com/article/5385/highperformance-net-application-development-architecture/ http://www.developerfusion.com/article/5385/highperformance-net-application-development-architecture/ Wed, 15 Feb 2006 15:25:00 GMT Dimitrios Markatos Your Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. This article discusses some of the issues. http://www.developerfusion.com/article/5381/locking-the-door-behind-you-hacker-protection-for-your-web-applications/ http://www.developerfusion.com/article/5381/locking-the-door-behind-you-hacker-protection-for-your-web-applications/ Tue, 14 Feb 2006 20:59:00 GMT Caleb Sima ASP.NET 2.0 brings enhanced performance and many new features that make the web developer's life easier. Alex Homer takes you through what's new. http://www.developerfusion.com/article/5348/new-features-for-web-developers-in-aspnet-20/ http://www.developerfusion.com/article/5348/new-features-for-web-developers-in-aspnet-20/ Fri, 03 Feb 2006 12:25:00 GMT Alex Homer