(0v34c10ck) When an application asks MySQL for the Primary Key of a table, there are several ways to go about doing this. A fast way would be to use these statements:
Other News
Visual Studio Solution Architecture for a WPF Application
(Mark Michaelis) Complex applications require careful architecting to reduce the amount of code movement between Visual Studio projects and the renaming of corresponding namespaces and folders.
Search in SharePoint 2010: Microsoft options
(Miles) SharePoint 2010 seems to be gaining traction both among its existing customer base and with companies looking for new web content management (WCM) systems.
JAXB and Joda-Time: Dates and Times
(Blaise Doughan) Joda-Time provides an alternative to the Date and Calendar classes currently provided in Java SE. Since they are provided in a separate library JAXB does not provide a default mapping for these classes.
When and How to Snowflake Dimension Sources : SSAS Design Part 1
(Jason Thomas) One of the best practices while designing a SSAS solution is to decouple your source database (which is in ideal cases, the data warehouse or the data mart but could also be an OLTP database) with the help of a semantic layer or view layer.
SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON
(Pinal Dave) I was recently watching a videos online of TechEd 2011 USA (link) and I learned that SET FMTONLY ON is going to be replaced with enhanced DMVs in future versions of SQL Server.
Sybase to DB2 Conversion Guide
(Whei-Jen Chen, Vlad Bregvadze, Kenneth Chen, Marina Greenstein, Vikram S Khatri and William Kulju) IBM DB2 for Linux, UNIX, and Windows has long been known for its technology leadership. The IBM DB2 SQL Skin feature for applications that are compatible with Sybase ASE (IBM DB2 SSacSA), offered in D
Putting the data to work: how to create a chart in PowerPivot
(Robert Sheldon) Microsoft PowerPivot is a self-service business intelligence tool that lets you import SQL Server data into Excel. After you’ve imported that data, you might wonder what to do with it — how to create a chart in PowerPivot, for example. Fortunately, it’s relatively easy to use Power
C# and VB.NET – Differing namespace conventions
(Jon Galloway) Recently, while reviewing the VB.NET translation of the MVC Music Store tutorial, I noticed that none of the controllers / models / classes in general have namespaces. I was going to blow up on the person who did the translation like a bad FxCop, but I fired up a new MVC 3 / VB.NET ap
Building a SQL Server Lab
(Buck Woody) lab·o·ra·to·ry (From the Medieval Latin labrtrium, from Latin labrre, to labor) 1. A room or building equipped for scientific experimentation or research, an academic period devoted to work or study in such a place. 2. A place for practice, observation, or testing