SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name ='FindColumnName'
ORDER BY schema_name, table_name;
Not sure why I lose this window sometime, but here is how to get it back:
With a report file selected: View -> Report Data.
It is a shortcut of Ctrl+Alt+D
Set Background property of the detail to:
= IIf(RowNumber(Nothing) Mod 2 = 0, “#EEEEEE”, “Transparent”)
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.