(Liran Zelkha) In the previous post of this series (which can be found here) I discussed how to identify tables that can serve as good candidates for sharding.
Other News
Working with URL Routing in ASP.NET Web Forms
(Bipin Joshi) While developing web sites, at times you require that the URLs being used are not mapped to any physical file. For example, you might be building a blog engine that stores all blog posts in a SQL Server database but while displaying these posts you want URLs to be SEO friendly.
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
(Pinal Dave) In SQL Server Denali, seven new datetime functions have been introduced, namely,
Another example of GATHER_TABLE_STATS and a Histogram
(Hemant K Chitale) In response to a forum thread “Why not selecting index path .”, I ran up this example :
MySQL 101 – Transactions
(Adam Donnison) We’ve now come a long way since our first steps at creating our online bookshop database. Now we need to start to think about how to sell the books and store details about the sales. This is the time we need to start understanding database transactions.
APAR Friday: Are you using DB2 10? Do you happen to use REBIND? Then read on…
(Willie Favero) I guess asking if you use the DB2 REBIND command is almost humorous. How many people don’t and most probably quite a bit. Well, there is an issue with the REBIND PLAN using a PKLIST in DB2 10, and it’s a severe enough issue that this APAR has been marked as a HIPER.
What is XSL Copy
(Darla Ferrara) Definition: The xsl:copy element repeats the node in the XSLT output stream. In other words, if you have an element in your source document, you can repeat it in the output stream. XSL offers two copy tags; xsl:copy and xsl:copy-of. The difference between the two comes in the attribu
Generic Data Access Layer using ADO.NET Entity Framework
(Mahadesh Mahalingappa) In this article, you will see how to create a generic data access layer (DAL) in a WCF proeject. I will use the ADO.NET Entity Framework to create a Data Model for the database. The Challenge is to pass the Entities to and from using a WCF Service.
Programmatically Drop and Recreate Foreign Keys with SSIS
(Ray Barley) I’m using SSIS to perform periodic data loads. In some cases the data load is a complete refresh of the data; i.e. we truncate the existing tables then perform the load. The one issue we have is that there are many foreign keys and this stops us from being able to truncate the tables.
Map Reduce Explained
SSWUG TV With Stephen Wynkoop What, Mango on the Windows Phone? Check it out on SSWUG TV. Map Reduce Explained David shares more insight into the history of the Map Reduce pattern. His practical explanation should provide some ideas for how you can utilize this pattern in your own systems. David Writes: The description of Map and Reduce is not […]