James Serra's Blog

Big Data Workshop

A challenge I have with customers who want to get hands-on experience with the Azure products that are found in a modern data warehouse architecture is finding a workshop...

2019-07-30 (first published: )

349 reads

The Microsoft Power Platform

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they...

2019-07-08 (first published: )

237 reads

Common Data Model

The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.  Another way...

2019-06-20 (first published: )

1,128 reads

Blogs

Daily Coping 4 Jun 2020

By

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

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

estimated execution plan

By sizal0234

  I have an SP which is truncating a table and then insert into...

optimizing SSIS package

By sizal0234

  I am trying to optimize an SSIS package which has multiple streams..so step...

SSRS report doesn't show some of the non-null data for some reason...

By sgmunson

Okay folks... riddle me this one:   Why does SSRS not display the non null...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers