Infrastructure at your Service
We still see some developers not declaring referential integrity constraints in datawarehouse databases because they think they don’t need it (integrity of data has been validated by the ETL). Here is a small demo I did to show why you need to declare them, and how to do it to avoid any overhead on the ETL.
Going to multitenant architecture is not a big change. The administration things (DBA, monitoring, backups) connect to the CDB and the application things connect to the PDB. Without the multitenant option, it is still recommended to go to the CDB architecture. The non-CDB is deprecated and the multitenant architecture brings interesting features. People often ask how to name the CDB and the PDB, especially when they have naming rules or policies in the company. My…
Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française) pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence…
A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools for SQL Server on a single web page: https://msdn.microsoft.com/en-us/library/mt238365.aspx As DBA, this page is absolutely to be marked in your browser. The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are…
I was looking at twitter analytics showing my top tweets in November and that puzzled me because tweets with the most ‘impressions’ and ‘engagments’ are related to events that had low audience in real. Any comment is welcome as it can help to understand why some events have low audience.
Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources. Agility of use Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of…
We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can’t imagine processing data seriously without it. And the technologies that come with NoSQL brings back the problem that we have solved with SQL databases. But can’t we ignore what is currently going on. Behind the Big Data buzzwords there are real requirements. And if we refuse to listen to them, we will not have…
Next Tuesday in Geneva I’m presenting Oracle In-Memory Column Store to Business Intelligence people at the Swiss BI Day After defining what is an analytic query, I show the different approaches to optimize that in Oracle, IMCS being the latest one. Here are some details about that slide.
Quick reminder of what is SharePoint 2013 and Office 365 SharePoint 2013 SharePoint 2013 is a collaborative platform that allows organizations to increase the efficiency of their business processes. link: https://technet.microsoft.com/en-us/library/cc303422.aspx Office 365 with SharePoint 2013 This is the Online version of SharePoint 2013. When you sign in to Office 365, or your organization’s corporate intranet site, you’ll see links to Newsfeed, OneDrive, and Sites in the global navigation bar. These are your entry points…
In this blog, I will show you how to bypass a “Synthetic Key” table in QlickView. Why bypassing a “Synthetic Key” table? If you have multiples links between two tables, QlikView generates automatically a “Synthetic Key” table. (here “$Syn 1” table). The QlikView best practice recommend to remove such kind of key table for a question of performance and “correctness” of the result. How to bypass this “Synthetic key” table? The “Link Table” is the…
