Viewing 15 posts - 1 through 15 (of 36 total)
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...
November 14, 2016 at 6:44 am
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...
November 14, 2016 at 6:38 am
Hi
A couple of resources I have found useful lately:
A good MOOC site with content from Microsoft and Universities
Data Management Framework, covers the lifecycle of data management, the DAMA-DMBOK...
November 11, 2016 at 4:09 am
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...
November 11, 2016 at 3:34 am
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...
December 12, 2013 at 4:44 am
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)
January 24, 2013 at 9:51 am
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...
December 11, 2012 at 2:52 am
I've used the SYDI documentation scripts for SQL Server and also SQLJobvis to monitor any overlaps that could be causing any issues.
October 1, 2010 at 5:26 am
You can install the Developer Edition on XP as long as its for development purposes.
March 15, 2010 at 6:30 am
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...
February 10, 2010 at 3:32 pm
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...
February 10, 2010 at 3:21 pm
You could use the openrowset command, instructions from the MSDN site:
February 10, 2010 at 3:03 pm
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...
February 10, 2010 at 2:51 pm
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.
February 7, 2010 at 2:02 pm
Viewing 15 posts - 1 through 15 (of 36 total)