Database Tutorials & Articles
-
Building Your First Data Cube
by Dan MaharryIn 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
-
To The Cloud: Moving Red Gate Tools to SQL Azure
by Roger HartRoger Hart looks back at Red Gate's inclusion of SQL Azure into its database applications, the issues they encountered and the solutions they created
-
Using SqlBulkCopy for high performance inserts
by Mike GoatlyIn 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.
-
Integrating Active Directory Into Azure
by Steve PlankThe 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.
-
Using the Queuing Service in Windows Azure
by Brian PrinceWe introduce one of the simplest services in Azure to get to grips with - the message queue service
-
Introduction to Windows Azure - What you should know
by Neil MackenzieNeil 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.
-
LINQ to log files
by Jon SkeetRunning LINQ queries over databases gets all the limelight, but Jon Skeet reminds us of it's possibilities over object graphs too.
-
SLOBbing about with .NET
by Dave WheelerPersisting objects is all about SLOB (serialized large objects), or so says Dave Wheeler who explains how it's now all so much easier.
-
Rails MVC and routing
by Kevin JonesKevin 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.
-
Rails: an introduction
by Kevin JonesEver wondered what “Rails” is all about? Kevin Jones explains what it is and why it's important.
-
Concurrency handling techniques in ADO.NET
by Joydip KanjilalJoydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them.
-
LINQ-ing to XML
by Mike JamesXML, 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.
-
ActiveRecord for Ruby and Rails
by Kevin JonesKevin Jones explains how ActiveRecord works in Rails, and in a standalone Ruby application.
-
Domain Driven Design: A Step by Step Guide - Part 1
by Casey CharltonThere 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.
-
The Next Generation Of Web Development
by James CrowleyWhere is Web Development moving to in the future?
-
The Need for Partnership as a Small Business
by James CrowleyCombine forces and be stronger as a small business
-
Smaller is better - shrink your world with Java compression APIs
by Sing LiSing Li shows how to add compression to your Java code when accessing files, networks or databases.
-
Rails: an introduction
by Kevin JonesYou'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!
-
Iterator blocks in C# 2: auto-generated state machines
by Jon SkeetEver 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.
-
InterSystems DeepSee
by Kay EwbankKay Ewbank looks at a real-time BI solution that is designed to be embedded into transactional applications.
