Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,410 reads
Gethyn Ellis
DDL Triggers
We had a request from a developer who wanted to access data from a source database and another database on...
2010-01-20
1,006 reads
SQL Server 2008 R2 - Release May2010
SQL Server 2008 R2 now has a release date...May 2010.
Check out the microsoft site for more details...link to follow
2010-01-20
555 reads
SQL Server Resource Governor
I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
2010-01-20
1,083 reads
January Roundup
I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is...
2010-01-16
698 reads
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
724 reads
Permon Counters Missing Windows 64 Bit SQL Server 32 Bit
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
746 reads
A Day Off
I'm having a day off tomorrow, got some nice things planned including a trip to the beach with the puppies....
2009-12-10
482 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
449 reads
weekly update
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
588 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