When a the User at the database level has no login, but there is one in the database. exec sp_change_users_login “auto_fix”, “cw_reports”;
Read moreSSRS Scripts
Find reports that are not mapped to a data source: SELECT ItemPath = c.[Path], ItemName = c.Name, DatasourceRefrenceName=ds.Name FROM [Catalog] AS c INNER JOIN DataSource AS ds ON ds.ItemID = c.ItemID WHERE ds.Link IS NULL AND ds.Extension IS NULL order by ItemPath
Read moreSQL Server Backup and Maintenance Scripts
https://ola.hallengren.com/sql-server-backup.html
Read moreQuickBooks iif Import Files
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. Import lists into QuickBooks with IIF http://www.my-quickbooks-expert.com/import-quickbooks.html
Read moreSQL Management Studio – Windows Authentication – different domain
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:domainusername “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe”
Read moreVSTO SP1 Install, Can’t Find Config File
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 […]
Read moreDocuSign
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. […]
Read moreAmazon RDS for SQL Server
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 […]
Read moreCloudberry Backup Desktop
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 […]
Read moreGoogle App User and 2 Step Verification
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 […]
Read more