Sites anglophones


SQL Window Functions in SQL Server, Oracle and PostgreSQL

Publié le 19 avril 2021 sur sqlservercentral.com
 

The post SQL Window Functions in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

Code Review & DevOps

Publié le 16 avril 2021 sur sqlservercentral.com
 

The post Code Review & DevOps appeared first on SQLServerCentral.

Azure SQL DB Frequently Asked Questions

Publié le 15 avril 2021 sur brentozar.com
 

I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means th …

SQL Monitor v11.1 now supports Azure SQL Managed Instances

Publié le 15 avril 2021 sur sqlservercentral.com
 

The post SQL Monitor v11.1 now supports Azure SQL Managed Instances appeared first on SQLServerCentral.

Load Multiple Excel Files and Worksheets with SSIS

Publié le 15 avril 2021 sur sqlservercentral.com
 

I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File …

Power Apps Canvas Apps Examples

Publié le 15 avril 2021 sur sqlservercentral.com
 

The post Power Apps Canvas Apps Examples appeared first on SQLServerCentral.

Using Data Science And Machine Learning In Identifying Fraudulent Activities

Publié le 14 avril 2021 sur sqlservercentral.com
 

In continuation of our series in Data Science, we previously looked at A Data Science Approach in Product Analytics. One of the pressing tasks, especially at FinTech and e-commerce companies such as PayPal, Stripe, eBay, etc., is to recognize fraud bef …

How to choose between SQL and NoSQL databases

Publié le 13 avril 2021 sur simple-talk.com
 

Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. One of the biggest decisions is to determine the best platforms to use for storing and delivering the application data. In th …

Your Top 10 Ideas for SQL Server

Publié le 13 avril 2021 sur brentozar.com
 

You’ve submitted thousands of bug reports and feature requests at feedback.azure.com, and here’s what you’ve voted as the top 10 requests right now: #10: MIN/MAX as non-aggregate functions. PostgreSQL and Oracle have the GREATEST/LEAS …

Have your say about PASS Summit 2021

Publié le 13 avril 2021 sur sqlservercentral.com
 

The post Have your say about PASS Summit 2021 appeared first on SQLServerCentral.

Export SQL Server Data to Excel and Add New Columns with C#

Publié le 13 avril 2021 sur sqlservercentral.com
 

The post Export SQL Server Data to Excel and Add New Columns with C# appeared first on SQLServerCentral.

PolyBase scale-out group in Azure for free

Publié le 13 avril 2021 sur sqlservercentral.com
 

This article is complementary to the book, Hands-on Data Virtualization with Polybase, which you can find here and which contains additional information and tips to test Polybase for free, or at least at the lowest cost. One of the most impressive feat …

Digital Event: Innovate Today with Azure SQL

Publié le 12 avril 2021 sur sqlservercentral.com
 

The post Digital Event: Innovate Today with Azure SQL appeared first on SQLServerCentral.

Missing Data

Publié le 12 avril 2021 sur sqlservercentral.com
 

We don’t always have perfect knowledge of the reality we are trying to model in our database. The most general approaches to handling this missing data has been either ignore it, deduce it or impute it. Ignoring something explains itself. In SQL, we ve …

An Introduction To Kusto Query Language (KQL)

Publié le 9 avril 2021 sur sqlservercentral.com
 

Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to c …


Pages :