Data Warehouse vs Master Data Managment
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,445 reads
Blog Posts
DBA Myths: You can’t use an alias in a DELETE statement
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
878 reads
Microsoft + Oracle = New opportunity…Windows Azure is a happening place !
Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the...
2013-09-24
961 reads
One Year Later
Wow! It’s been one year since I launched my blog, and my how things have changed.
Accomplishments Over the Past...
2013-09-24
695 reads
PASS BoD Election Questions – Global Vs Local
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
705 reads
PASS BoD Election Questions – Summit location
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
737 reads
PASS Elections 2013
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
845 reads
PASS Elections part two
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think...
2013-09-24
596 reads
Poor Microsoft Doesn’t Understand What Tablets Are For
That’s the title of an article i came across this morning in Slate.com. I am not a big fan of...
2013-09-24
649 reads
Premium Database on Azure
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
761 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