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
22 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-10
13 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)
140 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)
950 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)
242 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,820 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
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
1,971 reads
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes...
2019-03-14
102 reads
My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
355 reads
Blogs
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Introduction to SQL Server Execution Plans
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Forums
How to send queued emails
After an upgrade, sql server stopped sending emails. Problem is not solved but during...
TLS 1.2 and Database mail
Hi, We use office 365, and just recently received an email from them saying...
Left join not pulling all from left table
T has 57,000 distinct rows Z has over a million. I did row over...
Ask SSC