Hi

We user Red Gate tools (Compare and Data Compare) and Powershell scheduled to run everyday using Windows Task Scheduler.

Just a quick overview of the process:

- We use Powershell to download...

Hi

We would need to know more about the report requirements to offer any advice.

A starting point would be how often and when is the report accessed and by how many?

How...

Hi

A couple of resources I have found useful lately:

A good MOOC site with content from Microsoft and Universities

https://www.edx.org

Data Management Framework, covers the lifecycle of data management, the DAMA-DMBOK...

Hi

We use several tools for our CI development which may help you out:

TFS or Git for our source control

Red Gate Schema Compare to create our sql diff files

Red Gate Data...

Hi thanks for the reply.

I think it looks like an EAV as I've effectively take an attribute and changed it to a row:

Before:

Expenditure

BudgetID

FoodAmount

FoodFrequency

FoodComment

FuelAmount

FuelFrequency

FuelComment

etc...

After:

Expenditure

Expenditure

BudgetID

ExpenditureItemID

Amount

Frequency

Comment

ExpenditureItem

ExpenditureItemID

ExpenditureItemName

-------------

Has anyone come across a similar issue for...

Got around this by using a row level filter below:

=iif( (IsNothing(Lookup(CInt(Fields!id.Value),CInt(Fields!id.Value),Fields!Name.Value, "DataSetName")) = True), True, False)

Have some more info. I used Fiddler 2 to profile the data being sent to the web service. It seems SSRS is sending the parameters in the SOAP...

I've used the SYDI documentation scripts for SQL Server and also SQLJobvis to monitor any overlaps that could be causing any issues.

You can install the Developer Edition on XP as long as its for development purposes.

I'm currently reading "Pro SQL Server 2008 Relational Database Design and Implementation" it doesn't just teach you the theory but also has some good techniques in there that really...

Are you talking about updating the time on your servers i.e. NTP Servers?

If so do a search on Google and you should find some local to you, I tend to...

You could use the openrowset command, instructions from the MSDN site:

http://msdn.microsoft.com/en-us/library/ms190312.aspx

You increase performance by utilising the extra physical disks which reduces disks seeks and head movements.

Ideally you should keep the log on a seperate physical disks with Mirroring and look...

Write the query in a Stored Procedure and pass the relevant parameters to it from the report.

Our reports are written either through SPs or Views to the data.

M for Morrissey and Manchester, UK