James Serra

James is a Data Platform Architecture Lead at EY, and previously was a big data and data warehousing solution architect at Microsoft for seven years. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Blog Post

Azure IoT Central

This is a short blog to give you a high-level overview on a product called Azure IoT Central. I saw this fairly new Azure product (GA Sept 2018) in...

2022-04-11 (first published: )

137 reads

Blog Post

Microsoft industry clouds

In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this...

2022-01-28 (first published: )

150 reads

Blog Post

Distributed SQL

A very brief history of databases for online transaction processing (OLTP) workloads starts with relational databases (RDBMS), which worked well for many years. With the advent of the internet and...

2022-01-07 (first published: )

477 reads

Blogs

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Power BI connectors to Azure Synapse

By

When using Power BI and pulling data from Azure Synapse, you will use the...

Snowflake + Azure Privatelink

By

Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...

Read the latest Blogs

Forums

Filetred index

By aureliu

\hello Guys,   Mayyou help wuth the corect index filetred creation using modulo?  ...

Monitor SQL Server Job Failures

By ktflash

Ahoi, i am usually working with SSIS and SSAS, but since there is no...

DateDiff - Data Type conversion Issues

By protocoder

Hi Experts Not able to do DATEDIFF between two dates, but it works when...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers