Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: business-intelligence

What are Measures and Dimensions in Cubes

By adminPosted on December 27, 2022

Question : I’m very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I’m programming for years with SQL […]

SAP BO Freehand SQL date formatting (Oracle db)

By adminPosted on November 10, 2022

Question : My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = ’15-OCT-18′ However when […]

SQL Server + Microsoft Business Intelligence — free version or online learning environment?

By adminPosted on October 9, 2022

Question : I have some experience writing queries and stored procedures in SQL server. I would like to learn how […]

Review Technical ETL process for knowledge management

By adminPosted on March 8, 2022

Question : I’m looking for source code and all related component/material to review technical ETL process between source database and […]

What are good resources on data modelling for business intelligence? [closed]

By adminPosted on February 5, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

Always On Availability Groups as a Secondary Read Only Database [closed]

By adminPosted on January 24, 2022

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Use Oracle 10g BI enterprise edition with Oracle 11g database

By adminPosted on December 30, 2021

Question : Can i use Oracle 10g BI enterprise edition with Oracle 11g database. please tell. Thanks. Answer : You […]

Strategies/Resources for implementing data lineage in an ETL process?

By adminPosted on December 21, 2021

Question : I’m struggling to articulate my need here. I’ve been tasked with developing a significant ETL process dealing with […]

error in SSIS – [SQL query execution task] Error: The binding name of the results must be zero for the complete result set and the XML results [closed]

By adminPosted on November 27, 2021

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

What can be used with SQL Server 2014 native tools, for Business Inteligence?

By adminPosted on September 15, 2021

Question : We’re trying to achieve better reports using native tools from SQL Server 2014. I’m a DBA, and I […]

  • 1
  • 2
  • 3

Recent Posts

  • Should “Long Running with Low CPU” be expected for an SPROC that performs millions of INSERTS?
  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding