Setting up your cost-effective Azure Database Environment (2)
Chapter 2 Resources This chapter aims to look at the resources that will be needed to deliver the database solution. Sub-articles will be...
top of page
Search
SQL Shark
Sep 28, 20194 min read
Export and Archive SQL Datasets from the Reporting Server
1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...
700
SQL Shark
Sep 12, 20192 min read
SSIS - Switching from 64-bit to 32-bit
Switch package from 64bit to 32bit Case My Data Flow Task with an Excel connection doesn't run. It throws the following error: Just...
4,3920
SQL Shark
Sep 12, 20191 min read
SSIS - Manual Tests
SSIS Testing Plan: 1. Verify all tables have been imported. 2. Verify all rows in each table have been imported. 3. Verify all the...
191
SQL Shark
Sep 8, 20195 min read
SSIS - Performing Upserts
It is a common scenario, when we need a script, package or something else to perform insert and update in a table simultaneously....
920
_edited_edited.jpg)
bottom of page