What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,108 reads
James Serra's Blog
Salaried employee vs contractor
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,116 reads
Miss SQLBits 9? No problem, all videos are online
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the...
2011-10-31
2,270 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,519 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
853 reads
What is Microsoft TAP and RDP?
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,234 reads
SSIS – Can’t Enable/Disable within Data Flow Tab
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,027 reads
Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,773 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,137 reads
Formula engine and storage engine in SSAS
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,216 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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