Other News

Editorials

Real World Common Table Expressions

Real World Common Table Expressions Maurice writes our newsletter today with some gold nuggets wrapped around different uses for Common Table Expresssions CTE are a great way to express business logic into SQL, by breaking querying elements into more meaningful part. I usually give them long names that express the meaning of each step into SQL. CTE makes rewriting of […]

Uncategorized

Common Table Expressions

Common Table Expressions Common Table Expressions are a feature of the SQL language that has grown on me over time. They are mandatory for some forms of query recursion, at least in SQL Server. However, I don’t have a lot of need for recursive queries. I find I use them most often for simplifying complicated queries. If you ever do […]

Community

The VB.NET Form as a Class

(Dan Mabbutt) The Windows Form is a special object in VB.NET. For desktop applications, it’s the module that’s called to start the application. I wrote an article in 2011 about some of the … well … “uniqueness” of Windows Forms in the article, Multiple Form Instantiation in VB.NET.