:: CODE Magazine ::

	*Category: SQL Server 2005*
	8 Articles found and displayed in this view. The Baker’s Dozen: 13 Transact SQL Programming Tips Magazine/Issue: CoDe Magazine, 2011 Nov/Dec Release Date: Friday, October 21, 2011 Quick ID: 1112061 Even with all the new features in the Microsoft SQL Server Business Intelligence (BI), sometimes the only way to accomplish a task is with good old fashioned T-SQL code. (Fortunately, “code” is the acronym for this great magazine!) In this latest installment of The Baker’s Dozen, I’ll present 13 T-SQL programming tips that could help you accomplish different database tasks. Using Configurations to Manage SQL Server Extended Properties Magazine/Issue: CoDe Magazine, 2011 May/Jun Release Date: Thursday, March 31, 2011 Quick ID: 1105061 Before you start hard coding parts of your project to work with metadata in SQL Server, make sure that the functionality you want isn’t already part of the product. ASP.NET MVC & the ADO.NET Entity Framework Magazine/Issue: CoDe Magazine, 2010 Sep/Oct Release Date: Friday, August 20, 2010 Quick ID: 1009071 Both ASP.NET MVC and the ADO.NET Entity Framework are both very popular topics right now in the developer community.Having spoken at various user group meeting and code camps it is very obvious to me what topics a lot of developers are interested in. I see that sessions about ASP.NET MVC or the Entity Framework are always packed with developers eager for more information. The focus of this article is the Entity Framework, but in the context of an ASP.NET MVC application. As such, I am assuming at least basic understanding of ASP.NET MVC but little-to-none with Entity Framework. Using the Amazon Web Service SDK for .NET Magazine/Issue: CoDe Magazine, 2010 Mar/Apr Release Date: Friday, February 12, 2010 Quick ID: 1003071 The richest set of cloud computing services comes from a little e-commerce company known as Amazon.com. Developers can access the Amazon Web Services (AWS) platform using numerous tools including the .NET platform.Amazon.com is a major player in the cloud computing space and has numerous services available to developers. In late 2009, Amazon released the AWS SDK for .NET. This article will demonstrate using the AWS SDK to create a custom backup service using the Amazon Simple Storage Service (S3). Handling Business-Related Date Tasks in T-SQL Magazine/Issue: CoDe Magazine, 2010 Mar/Apr Release Date: Friday, February 12, 2010 Quick ID: 1003081 How many times have you found yourself in need of knowing what the next or previous business date is?What about the dates when a particular quarter begins and ends? Have you had to handle the thorny issue of daylight savings time (DST); when does DST begin and end for this or another year in the US, UK or some other region? And finally, once you have determined you have a need to calculate these various date values, where do you host that logic? This article answers those questions. Developing Database Agnostic Applications with Entity Framework Magazine/Issue: CoDe Magazine, 2010 Mar/Apr Release Date: Friday, February 12, 2010 Quick ID: 1003101 Microsoft released Entity Framework, an ORM (Object Relational Mapping) tool, in 2008.Entity Framework gives developers the ability to be abstracted from the underlying relational database management system and allows them to talk to a database using familiar LINQ-based syntax. SQL Server 2005 T-SQL Enhancements Magazine/Issue: CoDe Magazine, 2005 - Jan/Feb Release Date: Friday, December 24, 2004 Quick ID: 0501041 SQL Server 2005 or "Yukon" is going to be a major SQL Server update containing updates to nearly every facet of the program, including T-SQL.In this article I am going to explore some of the new T-SQL features, commands, and capabilities in SQL Server 2005. Because covering everything new in T-SQL would require an entire chapter in a book, I am going to cover some of the more useful and mainstream enhancements. SNAPSHOT Isolation in SQL Server 2005, Part II Magazine/Issue: CoDe Magazine, 2005 - Jan/Feb Release Date: Monday, December 20, 2004 Quick ID: 0501061 In addition to the transaction-based SNAPSHOT isolation level, SQL Server 2005 Beta 2 also introduces a statement-level variation of the READ COMMITTED isolation level called READ_COMMITTED_SNAPSHOT.Part I of this article (see "Snapshot Isolation in SQL Server 2005," July/August, Volume 5, Issue 4) described the transaction-based SNAPSHOT isolation level. At the time Part I was written, just prior to the release of Beta 2, only the SNAPSHOT isolation level was fully documented. With the release of SQL Server 2005 Beta 2, a fuller explanation of a second type of SNAPSHOT isolation behavior has come to light.