Generating a SQL Server, SSAS, SSIS, SSRS Memory Dump via PowerShell script (and SQLDumper.exe)

Recently, we published a PowerShell script to create memory dumps of SQL Server, SSAS, SSRS, and SSIS – called it SQLDumpHelper.ps1 . The PS script uses SQLDumper.exe and it makes it very easy to generate the dumps by avoiding having to look up SQLDumper.exe command switches. I wrote the PS script as an extension to…

0

An internal error happened while generating a new DBTS for database ‘Db1’

Recently I worked on an issue that encountered this error and I had to research the source code to figure it out. Msg 42029, Level 16, State 1, Line 3 An internal error happened while generating a new DBTS for database “Db1”. Please retry the operation This error has to do with the Database Timestamp…

0

How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)

Here is a request that came up recently: “When installing SSDT manually it downloads a shell copy of Visual Studio 2017 from the Internet. However, if I get the offline copy of SSDT for VS2017 it does not include the Shell copy of VS2017 so the install fails because no Visual Studio 2017 instance is…

0