Eduardo Pivaral

SQL Server Database Administrator/Developer with experience in large environments.
I have worked on IT for nearly 15 years in different areas.

Microsoft Certified Solutions Associate: SQL 2016 Database Administration since 2018.
Microsoft Certified Solutions Associate: SQL Server 2012/2014 since 2017.
Microsoft Certified Professional since 2014.

Install Python on Windows

Python is the most famous development language today.
This is because is open-source, scalable and robust. It can run in almost any device with a processor (or microprocessor, we will...

2021-01-21 (first published: )

861 reads

Blogs

AI Step 1

By

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

By

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Call dynamic sql storedprocedure from SSIS execute sql task

By komal145

hi, I have a table called Rules Create table Rules ( Id int ,...

Migrating database with many orphan users.

By JasonO

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Active and Active Cluster

By shiv-356842

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query?

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;

See possible answers