Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient...
2019-05-06
55 reads
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
2019-05-06 (first published: 2019-04-22)
1,594 reads
SQLDay starts in a week! Stay tuned during this week as it could be full of surprises! We are ready & prepared and speakers start to arrive next Saturday!...
2019-05-05
17 reads
Had a conversation with a good friend in the SQL Community about OpenSSH and how it fits as a transport layer for PowerShell Remoting. I pointed him towards several...
2019-05-04
5 reads
On Thursday 2 May 2019, Microsoft announced a new edition of SQL Server, targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere....
2019-05-03
234 reads
(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...
2019-05-03 (first published: 2019-04-22)
527 reads
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-05-03 (first published: 2019-04-22)
492 reads
One of the most common questions I am asked about ETL configuration is how much memory SSIS requires. When configuring a new instance of SQL Server running SSIS, or...
2019-05-02
194 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
17 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
5 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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