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,848 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
906 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,626 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,083 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,081 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,592 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,441 reads
Blogs
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Understanding Lakehouse Permissions in Microsoft Fabric
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
The Cost of Not Having a DBA
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Forums
what etl tool are folks moving toward?
Hi as we replace on prem machines , sometimes not with vm's, what should...
Union where it matches against only one shared column
Hi folks I have two tables, both with a NAME, START and END fields...
How to update using data from three tables?
I am in the process of migrating from MySQL to SQL Server. I have...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers