SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
721 reads
Blog Posts
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
545 reads
Cain does LSA Secrets dump on Vista and higher now
Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...
2011-04-19
2,078 reads
Confessions of a DBA – Part 4
This is the last part of my confession series since this is showing me only in negative light. I wish...
2011-04-19
1,262 reads
MCM: To pass, or not to pass
I’ve been counting down the days until I get the score from my second attempt at the SQL Server MCM...
2011-04-19
500 reads
Powershell Day 19
Day 19 Sql Server with .Net Using .Net programming is we can connect to sql server, its similar with any...
2011-04-19
543 reads
SSAS – Using Dimension OrderBy AttributeKey
Often when building dimensions there is a need to order you dimension attributes by something other than the NameColumn or...
2011-04-19
4,134 reads
Tech events in Kosova 2011
Hello everybody, some tech events are announced to be held in Kosova soon …
Soon other details will be posted and...
2011-04-19
524 reads
The Mentoring Experiment
Andy Warren (LinkedIn | Blog | @sqlandy) and I had an idea for a way to give back to the community and...
2011-04-19
1,127 reads
"What's the point?"
This is a crucial question with regards to what needs to be done. It really hit home after listening to...
2011-04-18
808 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