Blog Posts - SQLServerCentral

“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

News and Notes on the Structured Query Language

learning something every day 😎😎 (Thu, 21 Jan 2021)
>> Read more

[MS SQL] Deploy on-prem database to Azure SQL DACPAC fail on encrypted stored procedures (Fri, 22 Jan 2021)
>> Read more

blog – Essential SQL

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

Database Tutorials

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