How to restore the tail end of a transaction log
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,536 reads
Tim Radney - Database Professional
SQL Saturday 112 Recap
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a...
2012-05-17
599 reads
It was time for an upgrade
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
645 reads
Spend two hours with me at #sqlsat107.
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
640 reads
Becoming the dumbest guy in the group
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
768 reads
I am speaking at #sqlsat111 on TEMPDB.
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
568 reads
I am a Linchpin Team Mate
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,008 reads
SQLSAT107
I was recently selected to speak at SQL Saturday 107 in Houston TX. I am really excited to be selected...
2012-03-26
546 reads
SQL Skills IE3 #sqlskills
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
708 reads
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
622 reads
Blogs
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...
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...
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