The Next Phase of My Career
For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...
2013-11-18
619 reads
Nebraska SQL from @DBA_ANDY
Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,484 reads
New Page - "How to Get Involved With the SQL Server Community"
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
509 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
611 reads
T-SQL Tuesday #42 - The Long and Winding Road
It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T). Wendy's...
2013-05-14
662 reads
Announcing SQL Saturday 197 Omaha Pre-Cons!
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
803 reads
The Value of Certifications
A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...
2013-02-05
1,093 reads
Why is My New Server Under CPU Pressure?
Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...
2013-01-28 (first published: 2013-01-24)
2,923 reads
Everybody Needs to Know About Recovery
My friend and SQL Server professional Tim Radney (blog/@tradney) has written a new entry in the Joes2Pros series:
You can get...
2012-11-01
756 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
631 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