“They need help, we must help.” #forGarethSwan (Thu, 14 Jan 2021)
We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to ... Continue reading
The post “They need help, we must help.” #forGarethSwan appeared first on SQLServerCentral.
>> Read more
RIP Gareth Swanepoel and GoFundMe (Thu, 14 Jan 2021)
Last week we lost another SQLFamily member. Gareth Swanepoel passed away on 8 Jan 2021. He was a fellow speaker, jolly fellow, and Microsoft PM. Across many years of...
The post RIP Gareth Swanepoel and GoFundMe appeared first on SQLServerCentral.
>> Read more
Order of Execution in SQL Explained (Fri, 01 Jan 2021)
Knowing the order of execution in SQL helps you better understand SQL’s “hair pulling” errors! As you start to work with SQL you find that some of the errors don’t make sense or you wonder why
you’re able to use a column alias in the ORDER BY clause but not in a join condition. As […]
The post Order of Execution in SQL Explained appeared first on Essential SQL.
>> Read more
SQL FULL OUTER JOIN (Tue, 29 Dec 2020)
Today we’re going to look at the SQL full outer join and see how we can reconstruct it using other join clauses. By doing so well get a better understand of how it and the other joins works.
If you want to learn more about theses or other joins, I would encourage you to check […]
The post SQL FULL OUTER JOIN appeared first on Essential
SQL.
>> Read more
Oracle Autonomous JSON Database (AJD) (Tue, 19 Jan 2021)
What is Oracle Autonomous JSON Database Oracle recently announced Autonomous JSON Database(AJD), a new cloud service for developers looking for an easy-to-use, cost-effective JSON database with
simple NoSQL APIs. At first glance, we see that AJD provides all the basic features of MongoDB, with its high performance and flexible structure, completely providing all SQL functionality. …
The post Oracle Autonomous JSON Database (AJD) appeared first on Database Tutorials.
>> Read more
How To Install Metricbeat on Centos (Tue, 12 Jan 2021)
We will instal metricbeat on centos in this article. First, lets talk about metricbeat. What is Metricbeat? Metricbeat is one of the plugins of ElasticSearch. Metricbeat collects data from the
operating system and the services running on the server according to the modules used at certain intervals and stores this data in elasticsearch. It allows …
The post How To Install Metricbeat on Centos appeared first on Database Tutorials.
>> Read more
ADVANCEd Excel Access
databases VBA macros
SQL scripts
BI Reports
data
integrity big data
data science data mining
data mapping
data profiling data visualization
data modeling
financial analysis
SCORE CARDS
BENCHMARKS PERFORMANCE KPI METRICS