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 Fabric defined

Another buzzword that you may have been hearing a lot about lately is Data Fabric. In short, a data fabric is a single environment consisting of a unified architecture...

2021-06-21 (first published: )

287 reads

Modern Data Warehouse explained

I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...

2021-05-12 (first published: )

960 reads

Power BI and a Star Schema

I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...

2021-03-05 (first published: )

595 reads

Data Mesh defined

The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...

2021-02-19 (first published: )

547 reads

Blogs

Data Modeling at your fingertips

By

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

Daily Coping 30 Jul 2021

By

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

Read the latest Blogs

Forums

Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions

By VSCurtis

Hi Guys, I have an SQL Server 2012 Express database that I would like...

Deploying SQL Server Automatically

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deploying SQL Server Automatically

Setting data compression on a database or even server level possible?

By DiStas

I well realize data compression is a subject to a few variables, such as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers