MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,683 reads
Windows 2008 Server : Moving Cluster Quorum Disk to New SAN
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,476 reads
SQL Server: Measuring The Index Fragmentation
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,714 reads
SQL server: Deciphering Wait resource
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
32,146 reads
SQL Server - Index Fragmentation - Understanding Fragmentation
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,315 reads
Caveats of a CONTROL SERVER permission
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,943 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,952 reads
SQL server 2005 Database Mail stopped functioning after installing Service Pack 3
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,250 reads
How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,547 reads
Importing images to SQL server database using T-Sql
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
11,316 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