Azure Integration with Flow
Today I’m talking more about integration with Flow within Azure. Flow is focused around business power users who need to...
2018-09-21
272 reads
DataOnWheels
Azure Integration Options and Overview
Today I’d like to talk about Azure integration services that you can leverage within the platform. Integration services allow data...
2018-10-01 (first published: 2018-09-20)
1,458 reads
Why Customers Are Looking At Azure
As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting...
2018-09-19
314 reads
ExpressRoute and VPNs in Azure
In this edition of Azure Every Day, I’d like to discuss networking and interacting between your data center and Azure....
2018-09-18
235 reads
4 Usage Scenarios for Bots
So, what do you really know about bots or how they can help your organization? You may be thinking, Pragmatic...
2018-09-17
167 reads
A Quick Intro to DevOps in Azure
Today, I’d like to discuss DevOps in Azure and tell you why you should consider using DevOps when you start...
2018-09-14
936 reads
Customer Roadblocks to Azure
When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with...
2018-09-13
699 reads
Azure Storage – Hot, Cold, Archive
There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage,...
2018-09-12
717 reads
Do You Need a Relational Data Warehouse?
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come...
2018-09-27 (first published: 2018-09-11)
3,061 reads
Azure Hybrid and Security
Data Security. These words are in the forefront of many people’s minds and just hearing them may bring on an...
2018-09-11
150 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers