Enabling the Ruler within BIDS or SSDT

Enabling the Ruler within BIDS or SSDT

The ruler feature within SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio (BIDS) (post SQL 2005) being disable by default is one of my pet peeves! Whenever I use BIDS or SSDT I have to enable the ruler and I find this very...
BIDS Error – Passing Variables to Stored Procedures, Part II

BIDS Error – Passing Variables to Stored Procedures, Part II

Additionally, as promised in yesterday’s blog post, here are a couple more SQL Server Business Intelligence Development Studio (BIDS) error messages that I come across from time-to-time with quick ways to fix them. As a Microsoft Endpoint Configuration Manager (MEMCM...
BIDS Error – Passing Variables to Stored Procedures, Part I

BIDS Error – Passing Variables to Stored Procedures, Part I

Every so often I run across BIDS Error involving passing variables to stored procedures when I’m using Business Intelligence Development Studio (BIDS). We use stored procedures for all of our SQL Server Reporting Services (SSRS) reports, so I’m more likely than most...