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 - Database Professional
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
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
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
#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
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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