Great article and imagination, about all I would suggest is toward the end of the trigger ...

FROM

WHERE Content IS NOT NULL

...

You'll need MS DTC running if you are using 'immediate updating' updateable subscriptions. The other option is 'queued updating.' Here the changes are stored at the client and pushed when...

One thing I saw on MSDN and worth noting:

"Because the leaf level of a clustered index and the data pages are the same by definition, creating a clustered index and...

THis is not the cleanest way but for those who dont have the lookup functionality in SSRS...if you can import the data to the current database using a temp table...

Your database login may have a default language different than English, or the production server's default language may not not match the one to your login. Maybe the agent for...

Surrogate keys are a great way to keep track of multiple instances of the same entity (product, person, ...). You can add a validFrom and validTo date fields to also...

Is it possible there is replication whereby both updates need to occurr at the same time (publisher / subscriber) ? If so there could be an issue on the other...

To create a database user account for an existing login,

sp_grantdbaccess @loginname = 'loginname'

Have you tried to configure the permissions by connecting to the reports service through mangement studio? There you can select each report folder and/or report item and adjust them individually.

There are books on Analysis Services 2008, etc... However a good search result that lands you on the pages of an educational institution is a good way to start. You...

I know this is an old post. But with the month extraction, I first check in the formula if the month is greater than 9, else I stuff a "0"...

I am not sure why you would not want to create the CASE statement equivalent in the where clause by using AND, OR, and () operators.

I am not sure how many rows you expect in the tables, but I think a regular int rather than a large unique identifyer will query the data faster when...

From the diagram, the ETL brings in your data from your own operation system(s) and from the outside world. This would be a good place to make sure the data...

I don't think the index is as bad as it sounds. Without a good index a process has to lock the whole table (on a table scan) instead of taking...