Reporting Services Scale-Out Deployment Best Practices

[Update 17 Aug 2017: the link below is broken; but you can find the original paper and many more in a consolidated PDF form at SQLCAT’s Guide to BI and Analytics] Check out the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series:…


How to drop all tables, all views, and all stored procedures from a SQL 2005 DB…

This is a follow-up to the blog entry from Jasper Jugan. This is a modification to the script to allow for schema specific deletes of the SP’s, Views and I added Functions.   create procedure usp_DropSPFunctionsViews as   — variable to object name declare @name varchar(1000) — variable to hold object type declare @xtype varchar(20)…


Bricks seldom feel good.

Not much to say. I have been angry that he has not returned my emails. Sorry Ken. Ken Henderson – We Will Always Remember You   Technorati Tags: Ken Henderson,SQL Server,SQL