James is a big data and data warehousing technology specialist at Microsoft. 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.

Data Lakehouse & Synapse

I am starting to see this relatively new phrase, “Data Lakehouse”, being used in the data platform world. It’s the combination of “Data Lake” and “Data Warehouse”. In this...

2020-09-17 (first published: )

584 reads

More ADLS Gen2 enhancements

On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2): Archive tier is now GA: The archive tier provides...

2020-07-14 (first published: )

237 reads

Blogs

Solve SQL Server Resource Database Crash

By

Based on Microsoft Documentation <The Resource database is a read-only database that contains all...

Daily Coping 20 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My 800th post!

By

It took me a little bit longer to get here than I expected but...

Read the latest Blogs

Forums

Poor peformance

By ramyours2003

I ran the update stats on a  table by creating the indexes, when i...

SQL Server data file distribution

By soumyarani0317

I am a newbie to SQL Server administration and config. Apologies if I appear...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers