The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
729 reads
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
729 reads
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
738 reads
Starting Wednesday, December 9, 2009, I am on vacation until Monday, January 4th, 2010. Instead of traveling somewhere else for...
2009-12-08
401 reads
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,399 reads
Devenius Software is offering a free tool to help you manage SQL Server encryption keys. Its called the SQL Encryption...
2009-12-05
550 reads
2010 is beginning to look like a great year for SQLSaturday events this year. Already, there are nine planned, and...
2009-12-05
414 reads
While I have been working for Red Gate Software for nearly three years, it was only until this year that...
2009-12-05
754 reads
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,450 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
66 reads
Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of...
2009-11-26
1,437 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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