I work as a tester. I found some of the defects I investigate can be traced down to differences in configuration between local and customer's environments. As the tested system has major part of configuration encoded in DB, I'm looking for a tool that would ease comparision of table data (not sch...

This is first time i am working with huge database ( 100 million rows in table Events). Use case here is to quickly select and insert x and y for selected Organisation and datetime. My database knowledge is very basic, so could you please provide me some tips/articles/best practices for situati...

I am looking for any tips/steps used by the DBA's for install and configuration of TDP backup for SQL databases. Hope this meets the criteria for the forum. Thanks

Assuming the query execution is slow, I have collected the xml plan. What should I look for in the actual execution plan. What are the top 10 things I need to watch out for? I know this is a broad and generic question but I am looking for anyone who is experienced in query tuning to answer this ...

This is not exactly a DBA question but definitely a DB question and I think StackExchange DBA is my best bet for this question. Here I go : are there any frameworks ( free / open source preferred ) that attempt to solve data integration problems in an automated way via machine learning / fuzzy ...

We are currently working on project to get KPI metrics from out account partners,We want to design a table and It will have 3 Major Business units 4 Business Verticals (Service Desk, Knowledge Management,..) 20 divisions (Messaging, Application Management,..) Ideally we will be receiving KPI ...