New product: Azure Data Share
A brand new product by Microsoft called Azure Data Share was recently announced. It is in public preview. To explain the product in short, any data which resides in...
2019-08-19
15 reads
James Serra's Blog
Podcasts on Modern Data Warehouse
I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
254 reads
Top SQL Server migration questions
Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to...
2019-07-29
35 reads
Top Modern Data Warehouse questions
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
776 reads
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: 2019-07-10)
307 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: 2019-06-25)
148 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: 2019-06-06)
989 reads
Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event last week, the major announcements in the data platform and AI space were: Machine Learning...
2019-05-30 (first published: 2019-05-16)
245 reads
Where should I clean my data?
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
2019-04-25
1,836 reads
Two more of my presentations
I recently made available two more presentations that you might find helpful. Feel free to download them and present them to others (adding a line that you got them...
2019-04-04
24 reads
Blogs
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".
By Gethyn Ellis
To be honest you probably think that migrating to the cloud sounds great, and...
Forums
SQL Tamagotchi! Mini-Servers as Database Pets
Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...
SQL 2014 (or any other versions) Standard - ~Embedded Licensing~
Anyone have any insights on how this licensing works and what the "Use Rights"...
SSIS - Adding Columns to existing table and load data
I am working in SSIS (Sql server version 2012) , I have a requirement...
Ask SSC