What Are You Waiting For?
I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...
2011-05-16
1,005 reads
John Sansom
Stop Asking and Start Making Decisions Today
Ever have one of those days where no matter how hard you try you just can’t seem to make any...
2011-04-25
689 reads
7 Essential Habits of Successful DBAs
There are many different paths you can travel on the journey to success. There is no precise route that everyone...
2011-04-18
1,423 reads
SQLBits 8 – That’s a Wrap
This weekend saw the 8th SQLBits conference take place amidst glorious British sunshine by the sea in Brighton.
For those unable...
2011-04-10
881 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
Taking It To The Next Level
Have you set the bar high enough to ensure your success?
You’re reading Taking It To The Next Level, day 5 of 5...
2011-03-31
1,422 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,121 reads
How To Really Listen
One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing...
2011-03-29
1,625 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
851 reads
5 Days to Outstanding DBA Customer Service
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
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