James Serra's Blog

Power BI Security

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the...

2020-03-19 (first published: )

486 reads

SQL Database MI benefits

As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an...

2020-03-10 (first published: )

474 reads

Power BI Real-time Streaming

With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created...

2020-02-19 (first published: )

1,672 reads

Azure Storage tips

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...

2020-01-24 (first published: )

366 reads

DevOps for databases: “DataOps”

DevOps, a set of practices that combines software development (Dev) and information-technology operations (Ops), has become a very popular way to shorten the systems development life cycle and provide continuous delivery of...

2020-01-16 (first published: )

992 reads

My latest presentations

Just wanted to make everyone aware of my latest presentations that I recently uploaded. Details below. I also have a list of all my presentations with slide decks here.   Azure...


27 reads

Microsoft Ignite Announcements

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform...

2019-11-13 (first published: )

681 reads


Daily Coping 9 Jul 2020


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

The Manager’s Guide to Git Training for DBAs (Video / Podcast)


Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss...

Snowflake – Understanding constraints


One of the concepts in Snowflake that I find many struggle with is how...

Read the latest Blogs


Unique Clustered Columnstore Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unique Clustered Columnstore Index

Moving away from an RDBMS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving away from an RDBMS

Azure Analysis Service: Process Tabular Model with SSIS

By Lidou123

Hello, I hope you are well. I know this is not the right place...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers