Articles with this tag assume no knowledge prior to reading them.
Adding a graphic to the header of a report. Most reports require some sort of identifying header at the top of each page. While the header itself may be text, using a graphic provides a more polished look (though in my example I use a plain graphic). I’ll begin with the report created for the…
What is SQL Server Reporting Services (SSRS) SQL Server Reporting Services (SSRS) is Microsoft’s platform for designing, developing and delivering dynamic reports. Report Types SSRS provides a variety of reports such: Tabular, Matrix reports (crosstab or pivot table) – for summarizing data and reviewing it in multiple dimensions, charts and graphs – for visually illustrating…
Please see my other Database Development articles. Performing division on integer values. Often, recordsets contain values that naturally reveal metrics that provide helpful insight into the data. In this example, I list records about people. Each record contains information about a person’s age, gender and name. First, I list each person’s age, the sum of…
Please see my other Database Development articles. Implementing decision-making into logic The ability to control how logic is executed is central to all logic within the data layer. Within T-SQL, the following examples illustrates the primary constructs used for this purpose. Looping: The WHILE keyword provides the ability to execute deterministic actions for a prescribed…
Please see my other Database Development articles. Performing shorthand arithmetic While it’s possible to perform simple arithmetic operations by repeating the use of variables, shorthand notation provides a much more efficient way of writing the same operations. In the examples below, notice not once do I repeat a variable to perform an operation (increment, decrement,…
Please see my other Database Development articles. Leveraging the Object Explorer Filter to work more efficiently. The SQL Server Studio Manager’s primary interface to database objects is the object explorer. While this tool is very powerful, the results it displays can be quite overwhelming, especially in a production environment. To make locating objects more efficient,…
Please see my other Database Development articles. Introduction Before I define the process of designing a database, or “normalization,” I think some background is essential. In most implementations of SQL Server databases, the system they are designed to support are generally defined in two broad categories: Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP).…
Creating a new Excel spreadsheet at runtime and writing data into it. I’ll begin with two separate text files, each representing sales from two states: California and Oregon. First, I’ll add a DataFlow task and add add to it two Flat File sources each configured to pull in data from the text files. When configuring…
The primary component for extracting, transforming, and loading data. First, drag an OLE DB source unto the designer. Modify the data source by creating a new connection manager and the correct database and table. For this example, I will only leave three columns selected for retrieval. Now drag/drop a Derived Column transformation and connect the…
Using a file-system task to create a folder. First, drag a File System task object unto the designer and rename it according to its purpose. Configure the task to create a directory, set the path for it, and UseDirectoryIfExists=True. Now, execute just that task within the package and your new directory will be created.
TechMbaBi 