We have denormalised tables in our reporting database which provides data for creating ad-hoc reports in Report Builder 3.0. What is the best way to model the data access in Report Builder? The ...
Where I work we have a SQL Server database (Microsoft SQL Server 2008 R2) that serves as the back-end with two different user interfaces, a .NET web interface and a FoxPro interface. Every month we ...
We have a SQL Server 2008 database and have restricted all tables and views away from a specific user ID. Over the years we have granted back tables and views one at a time based on user need. We ...