The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,667 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
T-SQL Tuesday #48 – My take on the cloud
So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...
2013-11-13
626 reads
Murder They Wrote
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
785 reads
Retiring of the MCM Certifications, Part II
Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...
2013-09-03
1,343 reads
Retiring of the MCM Certifications
The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...
2013-08-31
4,245 reads
It’s the small things that count
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,523 reads
2013-07-22 (first published: 2009-04-30)
3,899 reads
T-SQL Tuesday #43 – Plan Operators
This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!)....
2013-06-14 (first published: 2013-06-11)
2,160 reads
Loading XML Data into SQL Server (SQL Spackle)
Learn how to load data in an XML file into a table in SQL Server.
2013-05-31 (first published: 2011-01-03)
20,531 reads
Getting the lowdown on 18456 errors
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...
2013-04-30 (first published: 2013-04-18)
2,537 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