The Azure SQL portfolio
The post The Azure SQL portfolio appeared first on SQLServerCentral.
Flyway Without the Typing
The post Flyway Without the Typing appeared first on SQLServerCentral.
Mount an Azure Data Lake Storage Gen2 Account in Databricks
The post Mount an Azure Data Lake Storage Gen2 Account in Databricks appeared first on SQLServerCentral.
How to Flatten JSON in Azure Data Factory?
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
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
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
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
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
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
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
The post Our Top Findings from The State of Database Monitoring Survey appeared first on SQLServerCentral.
SQL Server identity column
The post SQL Server identity column appeared first on SQLServerCentral.
Oracle sequences – 12c features including “identity”
The post Oracle sequences – 12c features including “identity” appeared first on SQLServerCentral.
Array and Custom Data Types in PostgreSQL
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
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 …