(HeWillem) A lot has been written about how to set up (table per class) inheritance with LINQ to SQL. I use it a lot and I always use an enum as inheritance discriminator.
Other News
QueryScript: SQL scripting language
(Shlomi Noach) Introducing QueryScript: a programming language aimed for SQL scripting, seamlessly combining scripting power such as flow control & variables with standard SQL statements or RDBMS-specific commands.
SQL Developer Quick Tip: Pretty It Up a Bit
(Jeff Smith) No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make it look
Querying multiple rows from dual
(Granville Bonyata) Sometimes it’s useful to have a query that always returns a certain number of rows, such as a report that returns one row for every day of the month. Using DUAL and CONNECT BY allows you to return as many rows as needed.
Index Scan with Filter Predicate Based on a Subquery
(Christian Antognini) Most execution plans can be interpreted by following few basic rules (in TOP, Chapter 6, I provide such a list of rules). Nevertheless, there are some special cases. One of them is when an index scan, in addition to the access predicate, has a filter predicate applying a subque
JAXB’s @XmlType and propOrder
(Blaise Doughan) In this post I will demonstrate how to use the propOrder property on the @XmlType annotation to control the ordering of XML elements. I will also discuss the impact of @XmlAccessorType on how propOrder is configured.
SQL SERVER – INNER JOIN Returning More Records than Exists in Table
(Pinal Dave) I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was.
SQL Server Integration Services 2012 (RC0) Project Conversion Bugs
(Jeff Wharton) Stumbled across a couple of bugs the other day while upgrading a SSIS 2008 package to SSIS 2012 RC0. The bugs relate to using a FTP Task with a Server Port greater than 32767.
Using Fluent NHibernate for XML-Free Class Mapping
(Joydip Kanjilal) NHibernate, the lightweight object relational mapping (ORM) tool for .NET, has a statically compiled counterpart called Fluent NHibernate. In essence, Fluent NHibernate is a XML-less, compile safe, automated NHibernate mapper that provides support for LINQ on top of NHibernate as w
When to use a calendar view vs. a calendar on your SharePoint site
Recently, I got some good news. An old calendar that we’d been using to schedule document publication was being decommissioned. I rejoiced because the old calendar was on another site with different usage parameters, including a separate permissions list from the SharePoint site that I was managing.