SQL Server SELECT

SELECT [tips tricks and commentary] FROM [my experiences] WHERE subject IN ('database', 'data warehouse', 'business intelligence')

Wednesday, May 9, 2018

How to Execute an SSIS Package on Azure from On-premise or IaaS Server

›
So you have SSIS packages deployed to Azure using ADFv2 and an Azure-SSIS Integration Runtime but you still have on-premise or IaaS SQL Serv...
Thursday, May 3, 2018

Integration Services Catalogs Node Not Visible in SSMS When Connecting to Azure Server w/ Azure SSIS Integration Runtime

›
So you went through all the steps to configure and deploy SSIS on Azure using an Azure SQL Server, Azure SQL Database (for SSISDB), Azure Da...
Tuesday, May 1, 2018

SSRS Continuous Deployment PowerShell Script using ReportingServicesTools

›
Way back in 2010 I wrote a post  about how to use RS.exe to automate the publishing of SSRS objects such as reports, datasource, folders, et...
Monday, April 30, 2018

PowerShell PSSecurityException: UnauthorizedAccess

›
I just fought with this for close to an hour and the solution was REALLY simple so I thought I'd try and save someone else an hour of th...
Thursday, April 26, 2018

Continuous Integration (CI) with Azure DevOps, SSIS, and SQL Server Database Projects

›
What are we doing here? This is the first part of a two-part series covering 1) CI (continuous integration/build) and 2) CD (continuous de...
Sunday, March 11, 2018

Estimated Number of Rows = 1 Query Very Slow or Not Returning Data

›
A query that is slow that should be fast (e.g. underlying tables are not enormous, has been fast in the past, etc. - I'll let you dete...
Thursday, March 8, 2018

Visual Studio SQL Server Project (SSDT) OPENQUERY Warning

›
Using OPENQUERY in a stored procedure in a Visual Studio SQL Server project will result in the following warning. SQL70558: The column de...
‹
›
Home
View web version

About Me

My photo
d.elish
Everywhere & Nowhere in My Airstream Trailer
Delivering bulletproof, data-centric software solutions to organizations such as Disney, PwC, Cymer, Boston Scientific, the Pittsburgh Steelers, Blue Cross Blue Shield of Massachusetts, Irving Oil, Bain Capital, LoJack, PETCO, and State Street Bank for over 14 years. Driven by a passion for problem solving, technology, and profitability.
View my complete profile
Powered by Blogger.