Sins of SQL: The Time Table

Steve Gray discusses one of the oldest OLAP techiques for representing the time dimension - and shows why it's a lot easier to stick to DATETIME values.

SQL syntax

Sending HTML Newsletters in a Batch Using SQL Server

Sending a large volume of emails can put a strain on a mail relay server. However many people using SQL Server will need to do just that for things like newsletters, mailing lists, etc. Satnam Singh brings us a way to spread out the load by sending newsletters in multiple batches instead of one large process.

case statement puzzle

What will this return?

Securing Reporting Services Reports

Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.

Careful with table name alias

Another way to get a table list from a string

I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.

INSTEAD OF trigger and OUTPUT clause

Do you know your getdate()?

This article takes a closer look at SQL Server getdate() and sysdatetime() functions.