SQLblog.net


Placeholder for procedures and whatnot.
| Comments

SSRS Report with Datasets from a Stored Procedure with Parameters, Runs Very Slowly

In most cases, SQL Server is smart enough to figure out the best execution plan for a Stored Procedure with Parameters. There are times, however, that this execution plan does not work. This was the case in an SSRS report I created which was pulling from a Stored Procedure with
Read More
| Comments

Adding DateID Using Derived Columns in (SSIS) SQL Server Integration Services

You may need to convert one or more of your date fields into an integer field. Maybe you will be using this field as a Key for your Data Warehouse DimDate field where the format would be yyyymmdd with no dashes. I will be using "Derived Columns" in SSIS to
Read More
| Comments

Deploying Reports to the (SSRS) Report Server

The first thing we need to do is find the URL location of the Reporting Server. Navigate and log in to the Reporting Services Configuration Manager. You can see that there are two URL Locations. Report Manager URL and Web Services URL. If you copy link listed under Report Manager
Read More
| Comments

Insert and Update Records with an SSIS ETL Package

Using SQL Server ETL to Insert New Records and/or Update existing records. This is the “Emp” table I created in my RunningTotals Database. I created the following fields and populated with 5 records: Next, I created an Excel Spreadsheet with a list of New Employees and a couple employees
Read More
| Comments

FileZilla FTP Server with a Windows 7 Firewall

FileZilla with a Windows 7 Firewall FileZilla Installation I love FileZilla. This is a free FTP Solution and it works beautifully and is easy to configure. Download the server version for free at https://filezilla-project.org/ to a folder on your computer. I saved mine to my SQL Folder. I
Read More
| Comments

Practice SSIS ETL Project using SQL Server 2012

This is a fun SQL Server Integration Services (SSIS) project that will help you become familiar with creating an ETL packages. ETL stands for Extract >>> Transform >>> Load. The Source File is a tab-delimited text file you should name “source.txt”. Copy/Paste the "raw" (view raw) text below into the
Read More