Ale, music and enjoying life.
Was playing with a POC app recently. I pushed out a web deploy to an Azure App Service. Everything built and deployed without issue. The app fired up and nothing just the vanilla error message returned. I checked the site logs via Kudu and…
Had a need to run a dacpac script that wasn’t part of pre or post deployments. You can use sqlcmd to do that for you by issuing the following:- Sqlcmd –S <server>\<instance> -v <variablename>=<variablevalue> -i <sql script to run>.sql So… Sqlcmd –S localhost\myinstance -v databasename=mydatabase…
When running SSIS components through SQL Server Agent jobs sometimes an error may appear and when viewing the job history you’ll see the helpful “To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report”. If…
Connection string data should always be removed of obfuscated in source control. There are many approaches to accommodating this. Scott Hanselmann has a great post on this. Azure makes this even easier if you’re hosting a web app that’s referencing a database somewhere. To…
Hit an issue recently where a csv file was being transformed through an SSIS package but persisting to the database as zero value integers for all null value columns. Spent time examining table constraints through trying to establish why this was occurring. It’s not the…