Sites anglophones


[Video] Office Hours: Ask Me Anything About SQL Server at the Volcano Hekla

Publié le 27 septembre 2021 sur brentozar.com
 

I drove up the volcano Hekla in central Iceland – also known as the Gateway to Hell – and parked the Defender here: While my travel companions hiked up higher (and took that photo), I set up the tripod and camera, then went through your hig …

SQL Server VM Best Practices

Publié le 27 septembre 2021 sur sqlservercentral.com
 

The post SQL Server VM Best Practices appeared first on SQLServerCentral.

Working with the Delete Activity in Azure Data Factory

Publié le 27 septembre 2021 sur sqlservercentral.com
 

Introduction We can use the delete activity in Azure Data Factory to delete files from both on-premises and cloud storage. In this article, we will discuss the delete activity with the various options available for the file deletion. I will show the fo …

Why pay for open-source software?

Publié le 27 septembre 2021 sur sqlservercentral.com
 

The post Why pay for open-source software? appeared first on SQLServerCentral.

How LAG compares to other techniques

Publié le 24 septembre 2021 sur sqlservercentral.com
 

The post How LAG compares to other techniques appeared first on SQLServerCentral.

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

Publié le 24 septembre 2021 sur sqlservercentral.com
 

If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By …

[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn

Publié le 23 septembre 2021 sur brentozar.com
 

The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here. Questio …

What Is a Cost-Based Optimizer?

Publié le 22 septembre 2021 sur brentozar.com
 

When you execute a query, the database server has to figure out things like: Which table to process first Which index to use on that table Whether to seek on that index or scan it Which table to process next How to join the data between those two table …

PostgreSQL Date And Time Part 2

Publié le 22 septembre 2021 sur sqlservercentral.com
 

Overview In this article, we will cover the most commonly used PostgreSQL date and time functions: LOCALTIMESTAMP(), LOCALTIME(), TO_DATE(), TO_TIMESTAMP(). If you are not yet familiar with any date and time functionality my suggestion would be to go t …

What’s the real story behind the explosive growth of data?

Publié le 22 septembre 2021 sur sqlservercentral.com
 

The post What’s the real story behind the explosive growth of data? appeared first on SQLServerCentral.

Real-Time Streaming using Power BI Streaming Dataset

Publié le 22 septembre 2021 sur sqlservercentral.com
 

The post Real-Time Streaming using Power BI Streaming Dataset appeared first on SQLServerCentral.

Use SQLAlchemy ORMs to Access MongoDB Data in Python

Publié le 22 septembre 2021 sur sqlservercentral.com
 

The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolki …

Free Training Classes for Those Who Give Back: Announcing our 2021 Scholarships

Publié le 20 septembre 2021 sur brentozar.com
 

You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization …

Azure SQL Migrations using Azure Data Studio

Publié le 20 septembre 2021 sur sqlservercentral.com
 

Database migrations to the cloud can be a daunting proposition for many database administrators and data stewards. A new extension available in the Azure Data Studio marketplace, called Azure SQL Migration, aims to simplify and streamline the process o …

Author Power BI Reports on Real-Time ServiceNow Data

Publié le 20 septembre 2021 sur sqlservercentral.com
 

As more businesses move toward data-driven digital transformation initiatives, lines of business are increasingly demanding access to their data to acquire actionable insights into performance and business health. Organizations …


Pages :