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...

2019-12-04

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

Blogs

Daily Coping 9 Jul 2020

By

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)

By

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

Snowflake – Understanding constraints

By

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

Read the latest Blogs

Forums

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers