Sites anglophones


The Azure SQL portfolio

Publié le 20 septembre 2021 sur sqlservercentral.com
 

The post The Azure SQL portfolio appeared first on SQLServerCentral.

Flyway Without the Typing

Publié le 17 septembre 2021 sur sqlservercentral.com
 

The post Flyway Without the Typing appeared first on SQLServerCentral.

Mount an Azure Data Lake Storage Gen2 Account in Databricks

Publié le 17 septembre 2021 sur sqlservercentral.com
 

The post Mount an Azure Data Lake Storage Gen2 Account in Databricks appeared first on SQLServerCentral.

How to Flatten JSON in Azure Data Factory?

Publié le 17 septembre 2021 sur sqlservercentral.com
 

When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, howeve …

[Video]: Office Hours at Diamond Beach

Publié le 16 septembre 2021 sur brentozar.com
 

I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/. 00:00 Introductions 1:21 Null Pointer: When we move to Azure SQL DB, should we worry about having all our data …

Updated First Responder Kit and Consultant Toolkit for September 2021

Publié le 15 septembre 2021 sur brentozar.com
 

I’ve slowed the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates ca …

Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer 

Publié le 15 septembre 2021 sur sqlservercentral.com
 

The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly u …

[Video] Office Hours at the Seltjarnarnes Lighthouse

Publié le 14 septembre 2021 sur brentozar.com
 

You posted and upvoted SQL Server questions at https://pollgab.com/room/brento, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer ’em. Here’s what we covered: 00:00 Introductions 00:58 Gio: Any known gotch …

[Video] Office Hours: Ask Me Anything in the Reykjavik Harbor

Publié le 13 septembre 2021 sur brentozar.com
 

You posted and upvoted questions at https://pollgab.com/room/brento to pick what you’d like to see covered in a Q&A session: Here’s what we covered: 00:00 Introductions00:26 Mehdi: Hi Brent! What is the first step when SQL Server i …

Be aware of the risk that you are taking when using AWS EC2 I3 instance type

Publié le 13 septembre 2021 sur sqlservercentral.com
 

Introduction Amazon Web Services Elastic Cloud Computing (a.k.a. EC2)  is a service that lets anyone with a credit card rent a virtualized server from Amazon. To cater to different clients’ needs, AWS provides various instance types that are eithe …

Our Top Findings from The State of Database Monitoring Survey

Publié le 13 septembre 2021 sur sqlservercentral.com
 

The post Our Top Findings from The State of Database Monitoring Survey appeared first on SQLServerCentral.

SQL Server identity column

Publié le 13 septembre 2021 sur sqlservercentral.com
 

The post SQL Server identity column appeared first on SQLServerCentral.

Oracle sequences – 12c features including “identity”

Publié le 10 septembre 2021 sur sqlservercentral.com
 

The post Oracle sequences – 12c features including “identity” appeared first on SQLServerCentral.

Array and Custom Data Types in PostgreSQL

Publié le 10 septembre 2021 sur sqlservercentral.com
 

Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if w …

[Video] Office Hours: Ask Me Anything About SQL Server at Hallgrímskirkja

Publié le 9 septembre 2021 sur brentozar.com
 

I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:18 __normally_weird (Sean C): Can you dispel the now p …


Pages :