Andras : November 2007

Home SQL .NET Exchange Opinion Blogs Forums About

Software Architect - Red Gate Software

November 2007 - Posts

Some interesting, obscure (and absolutely useless) T-SQL syntax

Posted Wednesday, November 28, 2007 10:05 AM | 3 Comments

/*Writing ugly SQL Statements is an art. Today I've spenta few minutes trying to break our parser as well as giving a grill to SQL Server's parser.So here is some extra syntax that is not behaving as I'd expect it to behave. */select 1.a-- Yes, this is Read More

by András | 3 Comments | Comment on this post

SQL Server 2008: Microsoft has given, and Microsoft has taken away (powersum)

Posted Thursday, November 22, 2007 12:14 PM | 8 Comments

SQL Server 2008 November CTP came out this week. This CTP finally contains many major features that are worth playing with. However, there are things that are no longer in SQL Server, things that I will be missing (and many things that I’ll be Read More

by András | 8 Comments | Comment on this post

Opinion Home

Opinion Pieces (94 articles)

Geek of the Week (36 articles)

Tony Davis - Editor (6 articles)

Phil Factor (40 articles)

Damon Armstrong (8 articles)

Douglas Reilly (40 articles)

Adrian Furnham (1 articles)

Claire Brooking (1 articles)

Richard Morris (32 articles)

Tim Gorman (1 articles)

Jesse Liberty (5 articles)

Sarah Blow (1 articles)

Anna Larjomaa (1 articles)

Gaidar Magdanurov (2 articles)

Regular Columnists (1 articles)

Ben Hall (2 articles)

Blogs Home

November 2007

Using Powershell to Generate Table-Creation Scripts

For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for... Read more...

Configuring Exchange Server 2007 to Support Information Rights Management

In Exchange Server 2007, Information Rights management is easy to set up once you have set up the... Read more...

SQL Response: The dim sum interview

Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They... Read more...

Why This SQL Server DBA is Learning Powershell

Ron describes how he decided to study Powershell as a single scripting system to automate all the... Read more...

Using Covering Indexes to Improve Query Performance

Designers of database systems will often assume that the use of a clustered index is always the best... Read more...

Site map | Become an author | Contact us