You can also use with encryption when creating the temp stored procedure.

Interestingly in SQL 2012 when the encrypted stored procedure is created the SQL code is viewable in profiler, unlike...

You can use this tool SSRS Subscription Manager. It backs up subscriptions to Excel. Backing up subscriptions to Excel also allows you to edit and change subscriptions- for example change...

There seem to be a lot of ‘yes’ men developers. In the past I have explained things and asked do you understand? any questions etc. yes they reply. Then...

Agreed everyone has start somewhere, but if a junior developer is mentored guided there is still no excuse. Additionally this should be picked up in a code review before it...

It is really simple- employ decent developers

If you pay peanuts you get ….

A good organisation will understand the worth of their data.

see what happens when you add a materialized view... this will be much quicker..

create VIEW vx_agg WITH SCHEMABINDING

as

SELECT --( COUNT_big(*) * SUM(col1*col2) - ( SUM(col1) * SUM(col2)))/( COUNT_big(*)*...

There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change...

There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change...

There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change...

Rather than do this programmatically there is an application (SSRS Data Source Manager) that can fix missing data sources for RDL reports and models. It can be used to change...