Skip to content
Closure
  • Databases
    • Microsoft SQL Server
    • Oracle Database
  • Business Intelligence
    • Data Warehouse
    • Microsoft Excel
  • Python
  • Data Science & Ai
  • Microsoft Azure
  • Microsoft Outlook
  • Unix
Closure
DataPlatform.gr
  • Databases
    • Microsoft SQL Server
    • Oracle Database
  • Business Intelligence
    • Data Warehouse
    • Microsoft Excel
  • Python
  • Data Science & Ai
  • Greek
  • English
DataPlatform.gr
  • Greek
  • English
SQL Server in the Cloud Era. Time for Azure SQL Databases?

SQL Server in the Cloud Era. Time for Azure SQL Databases?

18 December 2020Stratos Matzouranis

Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. With SQL Server in Virtual Machine services… read more

How do we find what's slowing down queries in SQL Server?

How do we find what's slowing down queries in SQL Server?

December 15, 2020Stratos Matzouranis

Many times we will see that a query is delayed and we would like to know what is delaying it. To do this we need to know the wait types and what each of them means. Specifically… read more

What is Tabular model and how it differs from Multidimensional in SQL Server Analysis Services

What is Tabular model and how it differs from Multidimensional in SQL Server Analysis Services

December 8, 2020Stratos Matzouranis

Microsoft in Analysis Services for the creation of Business Intelligence (Data Warehouse) beyond the use of Multidimensional Cubes also provides the Tabular model approach. Tabular models are new, faster to build and easier to use.… read more

How to bulk data into database using Oracle Data Pump (impdp)

How to bulk data into database using Oracle Data Pump (impdp)

December 1, 2020Stratos Matzouranis

Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. In a previous article we saw the use of Oracle Data… read more

Useful VBA routines in Microsoft Excel (Part 2)

Useful VBA routines in Microsoft Excel (Part 2)

24 November 2020Stratos Matzouranis

In continuation of the previous article we will see some more VBA (Visual Basic for Applications) routines that we can use in Microsoft Excel. These routines can be executed by calling them on a button or after some… read more

How to install SQL Server on Linux

How to install SQL Server on Linux

19 November 2020Stratos Matzouranis

In this article we will see how easy it is to install SQL Server 2019 on a machine with a Linux operating system and more specifically on a Red Hat distribution. We will also see how we connect and how we can… read more

How we collect blocking queries via Extended Event and how we read its data

How we collect blocking queries via Extended Event and how we read its data

16 November 2020Stratos Matzouranis

In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will create an Extended Event that records blockings. All we need to do is create it… read more

The Great Database Battle – SQL Server vs Oracle Database

The Great Database Battle – SQL Server vs Oracle Database

16 November 2020Stratos Matzouranis

The two best-known RDBMS (Relational Database Management Systems) with the largest market shares are Microsoft SQL Server and Oracle Database. They have a lot in common but also a lot of differences between them. Let's see in detail: Filegroups: They are… read more

How do we backup an Oracle Database that is in archive-log mode

How do we backup an Oracle Database that is in archive-log mode

12 November 2020Stratos Matzouranis

In this article we will analyze what it takes to take an online backup of an Oracle database that is in archived-log mode. In order to take a backup in addition to the datafiles, we should also take a backup of the controlfile,... read more

Posts pagination

" Page 1 … Page 12 Page 13 Page 14 … Page 18 »

Trending

Active Directory Windows Server Auditing ETL Transaction Log Query Store Oracle Database High Availability Python Office 365 Programming Security Monitoring Alerting RDBMS Grid Linux Disaster Recovery Data Guard RAC Flashback Database Data Analysis Data Pump Microsoft GDPR SQL GoldenGate Unix Scheduling BULK Operations Indexes Extended Events Backup / Restore Cloud Excel Row-Versioning Azure SQL Database VBA RMAN Ola Hallengren Maintenance Solution Automations Force Plan Azure Performance Tuning Databases Database Links Always On Availability Group Reporting SQL Server Replication

Categories

  • Business Intelligence (17)
    • Data Warehouse (3)
    • Microsoft Excel (12)
  • Containers (1)
  • Data Science & Ai (7)
  • Databases (140)
    • Microsoft SQL Server (81)
    • Oracle Database (60)
    • PostgreSQL (1)
  • Microsoft Azure (11)
  • Microsoft Outlook (1)
  • Microsoft Windows (2)
  • Python (10)
  • Unix (6)

See also

  • How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares

  • How we set an Azure Storage Account as a Cloud Witness in Windows Failover Cluster Quorum

  • How to install SQL Server on Linux

  • How do we set up a Windows Server as an NFS Server to have shared NFS disks on Unix

  • What is Oracle Real Application Cluster (RAC)

Recent Posts

  • How to convert a database from Physical Standby to Logical Standby in Oracle Data Guard
  • How to roll back an Oracle Database using a restore point in a Data Guard environment
  • How can we increase performance on Oracle GoldenGate Replicat target with parallelism?
  • How to create users in databases that belong to a SQL Server Always On Availability Group
  • How to create a Logon Trigger to control which users are allowed to connect to an Oracle Database

Recent Comments

  • Stratos Matzouranis on Τι είναι η PostgreSQL και πως κάνουμε μία πλήρης εγκατάσταση
  • Panagiotis Chronopoulos on Τι είναι η PostgreSQL και πως κάνουμε μία πλήρης εγκατάσταση
  • Anael on Πώς μπορούμε να λαμβάνουμε email κάθε φορά που έχουμε blocking session σε βάση δεδομένων της Oracle
  • Stratos Matzouranis on Πώς μπορούμε να εξάγουμε καθημερινά δεδομένα από τον SQL Server σε Excel και να τα στέλνουμε με email
  • Χρήστος Μαυροειδής on Πώς μπορούμε να εξάγουμε καθημερινά δεδομένα από τον SQL Server σε Excel και να τα στέλνουμε με email

Copyright © 2025 DataPlatform.gr - Founded by Stratos Matzouranis

We use cookies to personalize content and ads, provide social media features, and analyze our traffic. In addition, we share information about how you use our website with social media, advertising and analytics partners, who may combine it with other information you have provided to them or that they have collected in connection with your use of the services their.
View settingsAll cookies are allowed
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-advertisement1 yearThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Advertisement".
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by the GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the "Analytics" category.
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the "Functional" category.
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by the GDPR Cookie Consent plugin. The cookies are used to store the user consent for the cookies in the "Necessary" category.
cookielawinfo-checkbox-others11 monthsThis cookie is set by the GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by the GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the "Performance" category.
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not the user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
__gads1 year 24 daysThis cookie is set by Google and stored under the name dounleclick.com. This cookie is used to track how many times users see a particular advert which helps in measuring the success of the campaign and calculate the revenue generated by the campaign. These cookies can only be read from the domain that it is set on so it will not track any data while browsing through other sites.
_ga2 yearsThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assign a randomly generated number to identify unique visitors.
_gid1 dayThis cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number of visitors, the source where they came from, and the pages visited in an anonymous form.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
IDE1 year 24 daysUsed by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
test_cookie15 minutesThis cookie is set by doubleclick.net. The purpose of the cookie is to determine if the user's browser supports cookies.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
_gat_gtag_UA_165367103_11 minuteNo description
SAVE & ACCEPT
Powered by CookieYes Logo