Recently when trying to server up some images that were stored in an Azure storage container, we were noticing that the files presented this error message when using Chrome (but Fiddler traces showed success and it worked fine in other browsers).
It turns out this was not caused by duplicate header values being added to the response but instead it was because the image file name contained a comma that was not properly escaped by putting double quotes around the filename like this:
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "\"");
After installing the latest version of Red Gate SQL Source Control many of our non-sys-admin users were unable to see who had made changes to a database object.
After reading all the documentation and applying the suggested permission changes we found that we were still lacking some of the needed permissions to get this working. After looking through exception details in the log files we were able to get all the right permissions setup. Use the script below to grant your user/group the necessary rights.
GRANT ALTER TRACE TO [UserHere]
GRANT VIEW SERVER STATE TO [UserHere]
GRANT SELECT ON sys.sql_expression_dependencies TO [UserHere]
GRANT EXECUTE ON tempdb .dbo. RG_WhatsChanged_v4 TO [UserHere]
GRANT CREATE TABLE TO [UserHere]
GRANT ALTER on SCHEMA::dbo TO [UserHere]
After a bunch of searching and many incorrect suggestions I found the right SSDT package to get SQL Reporting projects to work in VS 2015:
Follow step 3 here:
Everything I did to get SSDT installed through Visual Studio as many suggested didn’t work for getting me access to SQL Reporting projects. Installing the SSDT package from step 3 in that link DID work.
Markdown Monster is another markdown editor that appears to support pasting screen captures into body of documents. This was a feature that was lacking in most of the editors I tested last year.
First go get UFRaw, a OSS utility for manipulating images from digital cameras. You can get it here:
Then just open up your command prompt and run something like:
c:\Data\PicsBeHere>"c:\program files (x86)\UFRaw\bin\ufraw-batch.exe" --out-type=jpeg --out-path=. ./*.cr2
I’ve been working recently on some deadlock issues in SQL Server.
Here is some good info on the various lock modes, durations, ownership etc.