-
The Baker’s Dozen: 13 Transact SQL Programming Tips
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2011 - November/December
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
By:
John Petersen
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2011 - May/June
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 and the ADO.NET Entity Framework
By:
Morgridge, Dane
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - September/October
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.
-
Developing Database Agnostic Applications with Entity Framework
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
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.
-
Handling Business-Related Date Tasks in T-SQL
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
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.
-
Using the Amazon Web Service SDK for .NET
By:
Rod Paddock
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
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).
-
SNAPSHOT Isolation in SQL Server 2005, Part II
By:
Talmage, Ron
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2005 - January/February
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.
-
SQL Server 2005 T-SQL Enhancements
By:
Jim Duffy
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2005 - January/February
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.
- Home
Articles filed in category 'SQL Server 2005'