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
912 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,761 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,211 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,608 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
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers