SQL Saturdays and Why We Have Them
There has been some recent controversy over SQL Saturdays after PASS HQ announced some new changes. The changes introduced a...
2016-08-19 (first published: 2016-08-18)
1,871 reads
Tim Radney
SQL Server: Consolidation Tactics and Best Practices
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I...
2016-07-21
1,506 reads
Microsoft SQL Server MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year....
2015-07-01
1,235 reads
Getting Your Worth the Struggles with Moving Ahead
I often get asked for advice on how to get started in a career as a DBA or in IT...
2014-12-19 (first published: 2014-12-10)
6,994 reads
I am joining SQLskills
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to...
2014-12-19
1,307 reads
#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,057 reads
Managing Geeks – A journey of leading by doing
I am proud to share that my good friend Andy Leonard has just released a new book. This is also...
2014-10-29
1,881 reads
SQL Server 2014 Backup and Recovery
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...
2014-10-29
1,877 reads
SQL Server 2008 SP4 Released
On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates...
2014-10-01
1,392 reads
What PASS is to me #sqlpass
I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL...
2014-09-29
1,632 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