SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that...
2011-04-28
1,721 reads
Blog Posts
SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that they were opening up the presentation schedule a little...
2011-04-28
4 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 reads
Connection strings and application name
G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...
2011-04-27
14,823 reads
Daily Denali Delight – Day 5
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-27
989 reads
It’s a Deal, It’s a Steal…
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
642 reads
Microsoft Certification Exams: Costs are Increasing
It was announced yesterday that the cost of taking a Microsoft exam will increase from the 1 July. In the...
2011-04-27
2,392 reads
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
526 reads
Presenting On DR & HA Twice This Week
Just a quick mention that I'm presenting Paging DR Availability, You're Wanted in the Recovery Room twice this week - today,...
2011-04-27
575 reads
The developer / DBA relationship.
G’day,
A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as...
2011-04-27
2,660 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