Daily Coping 30 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-30
11 reads
Blog Posts
On bias
Last week saw the second month of my employment at Microsoft. I admit that I’m enjoying my job, and I can’t deny that the reduced amount of time I’ve...
2022-03-30
21 reads
Passed a CosmosDB Exam
I took the beta exam for Cosmos DB a few months back. I did this as part of the MVP program, as they were asking people to evaluate the...
2022-03-30
16 reads
Azure AD Automatic Provisioning for Snowflake
Azure AD application provisioning refers to automatically creating user identities, groups and roles in the applications that users need access to for accounts created in(more...)
The post Azure AD Automatic...
2022-03-29
107 reads
Book Review – Azure Data Factory by Example
I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book was not exactly what I was expecting, but that’s...
2022-03-29
39 reads
Daily Coping 29 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-29
10 reads
Daily Coping 28 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-28
9 reads
Parsing JSON in SQL Server with OPENJSON
Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the...
2022-03-28
53 reads
Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-28 (first published: 2022-03-15)
311 reads
Using Azure Blob Storage in Power Automate
In this video, Devin you will learn how to setup an Azure Blob Storage account and then use it in Power Automate. With Power Automate
2022-03-28 (first published: 2022-03-11)
551 reads
Blogs
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Forums
Pull mssql to Postgres
Does anyone have a script\example that would connect to SQL server instance run a...
Fill in missing hours for each VisitID during the day
create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID,...
Database copy for report work load
Hi Team, I am looking for a an help, Please see my problem below....
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers