Joel Greijer

This happened to me once, source and target databases was located on the same server running 14.0.1000.169 Microsoft SQL Server Enterprise (64-bit) Consecutive executions never fail. I could not reproduce the error until next day. My workaround has been to simply add "re-try execution" a number of times in SQL Agent job. SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005  Description: "Insert bulk statement does not support recompile.".  End Error

When loading azure data factory, either via "Load Data" from your DW database, or via "Monitor and Manage" links. It never loads or show an empty page. In Edge it Loads forever, Showing splash screen In Chrome, it just shows an empty page (accesstoken.htm) The solution is that Microsoft requires third party cookies to be enabled in your client browser. This is bad, but as a workaround for Chrome: go to chrome://settings/content/cookies And add the follwoing domains to Allow section azure.com microsoftonline.com login.microsoftonline.com azureedge.net

Default behavior of sql server install is to lock down ability to set ntfs rights on sqlbackup folder to unlock this you have to run the following as admin. This will transfer ownership to administrator for subfolder takeown /f c:\sqlbackup /a /r /d y Use at your own risk

Due to some nasty bugs in invoke-sqlcmd wrapper in powershell we must use the following workaround to be able to pass multiple parameters/variables to sqlcmd.exe from powershell $parameterizedCmd = 'sqlcmd -b -E -I -S . -d master -i "script.sql"' + ' -v Parameter1="' +$PsParameter1+ '"' + ' -v Parameter2="' +$PsParameter2+ '"' write-verbose $parameterizedCmd # invoke-expression and invoke-sqlcmd are insanely bugged # workaround by executing via cmd /c instead & cmd /c $parameterizedCmd

IgnoreFailure RedirectRowsToError OutputFailComponent RedirectRowsToNoMatchOutput LookupNoMatchBehavior NoMatchBehavior

When making changes to an existing report and publishing it to a Sql Server Reporting Services 2016 instance. The changes are not showing up when you refresh your browser throught the report manager or the report service url. I started noticing this problem when making changes to data source or data sets embedded within a report. The errors caused was something like Microsoft.Reporting.WebForms.ReportServerException: The data source 'DataSourceName' cannot be found. (rsDataSourceNotFound) or The report execution [random number] has expired or cannot be found. (rsExecutionNotFound) The cause of this seem to be that reporting services caches your report (and embedded data sources) for your session. This cache is not correctly invalidated by consecutive deploys. You can work around this by Clearing your browser cookies from your reporting services site Using your browser incognito mode (Not tested) Disable client cookies in SSRS server properties  https://msdn.micros...

This is a sample of how you would create and assign members to three roles for your tabular cube using TSML json script. To execute, open new query connection to your ssas tabular server in management studio, then execute The example in msdn has an extra, invalid bracket set, after "sequence": which fails the script. It has been removed in my working sample below   {   "sequence": {     "operations": [       {         "createOrReplace": {           "object": {             "database": "YourTabularCubeName",             "role": "Admin"           },           "role": {             "name...