https://www.developerfusion.com/t/sql-server/tutorials/sort/popularity/ SQL Server Tutorials & Articles from Developer Fusion http://www.rssboard.org/rss-specification en-GB Mon, 22 Nov 2010 12:26:00 GMT Creating connections and all your data objects are really easy Design-Time, but what if you need it for runtime? Here's how. http://www.developerfusion.com/article/2459/creating-a-database-connection/ http://www.developerfusion.com/article/2459/creating-a-database-connection/ Mon, 28 Oct 2002 12:17:00 GMT Tony Ho 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 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 Completely new to Visual Basic? Overwhelmed with the confusing instructions? Read this tutorial and get a head start - learn what VB is, what you can do with it, how much it costs, and how to get star http://www.developerfusion.com/article/30/visual-basic-tutorial/ http://www.developerfusion.com/article/30/visual-basic-tutorial/ Sat, 14 Jul 2001 23:00:00 GMT James Crowley 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 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 An article for all those like Robert Scoble who would like to be able to drag and drop an item to a folder in their Outlook and post it instantly to their Blog. We also briefly cover web services and talking to Outlook. http://www.developerfusion.com/article/4667/how-to-access-outlook-and-post-to-a-blog-using-c/ http://www.developerfusion.com/article/4667/how-to-access-outlook-and-post-to-a-blog-using-c/ Fri, 11 Feb 2005 13:52:00 GMT Simon Soanes Learn how to allow a user to upload an image to your server and store the binary data in a Microsoft SQL database. http://www.developerfusion.com/article/3905/uploading-images-to-a-database/ http://www.developerfusion.com/article/3905/uploading-images-to-a-database/ Fri, 01 Aug 2003 06:40:00 GMT Dave Wanta This article illustrates a mixture of common .NET methods for formatting and presenting in a readable fashion any XML document you may encounter. The latest hype with XML Web Services and even the .NET Framework itself relies on XML as its backbone, therefore this is no light matter. http://www.developerfusion.com/article/4078/reading-storing-and-transforming-xml-data-in-net/ http://www.developerfusion.com/article/4078/reading-storing-and-transforming-xml-data-in-net/ Tue, 07 Oct 2003 11:14:00 GMT Dimitrios Markatos 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 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 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 ASP.NET simplifies many things but data binding simple controls like textboxes and checkboxes leaves a lot to be desired. Databinding is one-way only and you end up doing lots of repetitive work to publish your data. In this article I'll show you how simple databinding in .Net works and then show how to create custom controls that implement two-way binding to make short work of creating databound forms. http://www.developerfusion.com/article/4659/implementing-twoway-data-binding-for-aspnet/ http://www.developerfusion.com/article/4659/implementing-twoway-data-binding-for-aspnet/ Tue, 18 Jan 2005 08:43:00 GMT Rick Strahl While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field. http://www.developerfusion.com/article/3704/identifying-your-new-records/ http://www.developerfusion.com/article/3704/identifying-your-new-records/ Thu, 29 May 2003 07:30:00 GMT Bruce Johnson Learn everything you need to know about using the ADO Data Control http://www.developerfusion.com/article/10/ado-data-control/ http://www.developerfusion.com/article/10/ado-data-control/ Sat, 14 Jul 2001 14:47:00 GMT Susan Harkins 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 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 The first in a three part series, this article introduces the basic concepts of floating-point arithmetic: number formats, accuracy and precision, and round-off error. It includes an in-depth discussion of the .NET floating-point types. http://www.developerfusion.com/article/4691/floatingpoint-in-net-part-i-concepts-and-format/ http://www.developerfusion.com/article/4691/floatingpoint-in-net-part-i-concepts-and-format/ Sat, 16 Apr 2005 18:04:00 GMT Jeffrey Sax 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