Need to know the stats of what is going on in SSRS. Query ExecutionLog, ExecutionLog2, or ExecutionLog3 and get the time for data retrieval, processing, and time rendering.
Some very good information on how to format an iif file that can be used to import data into QuickBooks. Using this to move sales transaction information from a website into QuickBooks.
Sometimes you need to use windows authentication to SQL using SQL Management Studio, but the your domain and or username is different than who you are currently logged into you machine as. In that case run the following command from a Command Prompt.
runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”
I was installing an Excel addin across a clients production servers and for some reason when I ran the addin on one of the machines the Addin couldn’t read the config file even though it could on all the others. After digging through registry and other settings and some googling I came across this blog post. I prefixed the manifest location with “file:///” in the registry and it started working again.
I recently got to work on a pretty cool project for a client. They needed to have their employee’s electronically sign their time cards which were generated by a SSRS report exported as a PDF. To accomplish this we used DocuSign which has a really good SOAP API and was really easy to work with. Looking forward to doing more integrations for the client with DocuSign.
Earlier this month Amazon announced that you can now use RDS with SQL Server. I have been using RDS for MySQL about 9 months now and really like. It automates many of the administrative tasks, but gives you a backup within an availability zone. This will allow me to suggest AWS as a hosting option for some of the high availability .NET apps that I work on.
I recently started using Cloudberry’s Backup Desktop edition as my Carbonite (Online Backup) subscription is running out. In their newest version 2.0 they have added the ability to backup to a local folder or network share. With storage space so cheap now I would much rather backup my music and videos locally. I just bought a 2TB external eSATA drive for $100. The plan is to backup documents and other smaller files to Amazon S3. So far this is working out really good. The only thing that it is missing is version control for the local backups. It maybe there someone in the options, but just haven’t found it yet. I have been really happy with Cloudberry’s products and at the speed that they keep up with new functions that Amazon rolls out for S3 or Cloudfront. I have come to rely on Clouberry S3 Explorer for managing my CloudFront distributions.
Google announced last week that they will start rolling out the ability of Google App Administrators to require a 2 step verification process for logging in. Many of us are used to this with company VPNs when using a RSA SecurID. Google is offering many options for the 2 step which is great. The best option as I see it is the application that you can install on your Android, BlackBerry or iPhone device.
When you thought it couldn’t be cheaper to start running a server on EC2 Amazon announced micro instances. You can get the micro instance for windows ($0.03/hr) and linux($0.02hr) with 613 MB of RAM. If you get a reserved instance the price drops even lower.
I got to “play” with the PayPal SOAP API last week for a website I was building on. It was very easy to work with and I was surprised at how quick I could could get a checkout page going in ASP.NET/C#. It could have been quicker but some of the documentation on the PayPal site was either out dated or confusing. Luckily with a quick Google search I could find the correct way to create the main SOAP object. If anyone needs an example of how to do a Direct one time payment let me know.