(Kenneth Downs) In the past two weeks we have looked at the table of courses that teachers are teaching and students are enrolled in for a year. The five rules are: 1. A teacher may not teach a class he/she is not qualified to teach. 2. No two classes can be given in the same classroom in th
Other News
Handling Weeks that Overlap Years in a Date Dimension
(Ray Barley) Our business users want to report on some fact data aggregated by week. They define a week as beginning on Sunday and ending on Saturday without regard to the year. An example query would be how many employees were hired in each of the previous four weeks? While SQL Server has the D
SQL Server Virtualization Feedback
Conference Starts Tuesday – Register Now The SSWUG SQL Server Virtual Conference is coming to your computer starting on Tuesday – make sure you register ASAP if you’ll be attending. Have you seen the schedule? Information on all of the base items you need to know for SQL Server is included. From TSQL 101, 2 and 3 to understanding replication […]
Introduction to XML and Web Services
The Extensible Markup Language (XML) is a simple, platform-independent standard for describing data within a structured format. XML is not a language but instead a metalanguage that allows you to create markup languages. In layman’s terms, it allows data to be tagged using descriptive names so both
Database applications made easy with WebSphere Application Server Community Edition, DB2 Express-C and Eclipse
(Anitha Krishnasamy and Sridhar Kuna) IBM WebSphere Application Server Community Edition provides excellent support for JDBC-enabled databases through a J2CA framework, making it easy for your application to access a backend database. This tutorial describes how you can easily develop a simple datab
How Do I: Multiple File Uploads in ASP.NET
(Joe Stagner) In this video I will demonstrate uploading a dynamically determined number of files to your ASP.NET application.
Unity Dependency Injection Container and ASP.NET MVC Framework
(David Hayden) I couldn’t resist trying one thing with Unity this morning before doing real work 🙂 I wanted to try Unity with the ASP.NET MVC Framework for dependency injection into Controllers using a custom IControllerFactory.
Validate XSL Against XML
(Haissam Abdul Malak) I was working on a project where the user is required to provide his or her own XSL file to generate his or her own HTML page based on an XML file we provide. In this situation, the need to verify that the XSL file will display appropriate results and not an empty page is requi
ASP.NET MVC Framework Road-Map Update
(Scott Guthrie) This past December we released the first preview of a new ASP.NET MVC Framework as part of the ASP.NET 3.5 Extensions CTP Release. I also wrote a number of blog posts that provide more detail on what the ASP.NET MVC framework is and how you can optionally use it:
DB2 Sliding Scale Space Allocation
(Troy Coleman) As a production support DBA I used to get weekly reports on dataset size and extents. The main purpose of this was to figure out which datasets are near the maximum number of extents and schedule an alter primary/secondary quantity and reorganize the table space or index space to redu