Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.
To create a PowerView report first we need to create a BI Semantic Model Connection,
but If we did not deploy...
2012-03-21
2,860 reads
ssdat@hotmail.com
- Website: https://sdtslmn.blog/
SQL Server 2012 Virtual Launch
Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.
You can register the event by using the...
2012-02-02
911 reads
Remove All Foreign Keys
To clear test data from a database we could use truncate commands but sometimes we need to get rid of...
2011-10-11
40,760 reads
Change User Desktop Folder Path by Using PowerShell
We could change your desktop folder location by using the following powershell script. Actually we need to change values of...
2011-08-14
5,202 reads
Export SQL Server Error Messages from Event Viewer As HTML
i use the following powershell script to retrive all sql server error logs from event viewer and export as a...
2011-06-23
1,100 reads
SQL Server Separation of Duties
Microsoft published a white paper named "SQL Server Seperation of Duties". Security always an important problem for DBAs and many...
2011-06-23
1,606 reads
Taking Script of Sql Server Jobs for Migration
when migration sql server database to a new server, i use the following powershell script to take all sql server...
2011-06-23
2,450 reads
Blogs
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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