Busy times
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
435 reads
DotNine SQL Server and more
Wait Statistics #4 LCK_M_xx
In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...
2014-09-26
1,272 reads
Speaking at SQLSaturday #311 Bulgaria
More good news! I will be speaking on SQLSaturday #311 Bulgaria.
If you read this blog and will attend the event,...
2014-09-16
521 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,338 reads
Speaking at SQLSaturday #336 Holland
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
710 reads
New website
As you can see the webpage has changed!
New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
–...
2014-08-11
509 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we...
2014-07-11
578 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...
2014-07-11
3,318 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,205 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
425 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