msftdbprodsamples.codeplex.com

blog.hoegaerden.be

BI: Beer Intelligence? · Articles

http://blog.hoegaerden.be/articles

Serving you my best brews, one pint at a time! Latest revision: December 18, 2013). On this blog you’ll find a mix of typical blog posts and some longer posts as well.  These longer posts are what I’d like to call articles. And they’re usually written in tutorial-style. This page is meant to contain a list of all the articles, grouped by category and sorted chronologically with the newest first.  This makes it easier for everyone to find them and gives an easy-to-use overview of what’s available. 160; Re...

moidulhassan.wordpress.com

moidulhassan – Its all about data

https://moidulhassan.wordpress.com/author/moidulhassan

Its all about data. The goal is to turn data into information, and information into insight. A blog by Moid ul Hassan. August 22, 2014. When and how to use the aggregate transformation in SSIS. Aggregate transformation allows to aggregate the data from the data source pushed in the SSIS. It can be used in scenarios where we have to group, sum or count the data, for example aggregate transformation can be used to sum the total monthly sales made by employees. Create a new integration services project.

blog.hoegaerden.be

BI: Beer Intelligence? · automation

http://blog.hoegaerden.be/tag/automation

Serving you my best brews, one pint at a time! You are currently browsing articles tagged automation. Deploying PDFs, and more [SSRS]. May 24, 2014. One of my presentations last year covered the topic of automating SSRS deployments through the RS Utility. So here’s the script for exactly that! For the interested reader: the scripts from my session can be downloaded through this follow-up post: Automating SSRS Deployment: Download. WriteLine( Running script DeployPDF.rss. Hiddenprop.Value = False. Name, P...

devinknightsql.com

Power Query | Devin Knight

https://devinknightsql.com/category/power-query

124; Comments RSS. Power BI Custom Visuals. Creating a Date Dimension with Power Query. Posted on June 16, 2015. A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here’s some of the quick benefits and reasons why you need a date table:. Helpful when filtering data. Filter by year, quarter, month, etc. Helpful for drilling into a hierarchy of dates. Expand 2015 to see all the months within that year. Go to Power Query tab&#46...

blog.hoegaerden.be

BI: Beer Intelligence? · Silly SQL #1: OLE DB Destination [SSIS]

http://blog.hoegaerden.be/2014/08/13/silly-sql-1-ole-db-destination-ssis

Serving you my best brews, one pint at a time! Lsaquo; Deploying PDFs, and more [SSRS]. Silly SQL #1: The Movie! Silly SQL #1: OLE DB Destination [SSIS]. August 13, 2014. Sometimes we take silly little things we do in our daily life for granted and assume everyone else is aware of them too.  That’s where we’re wrong: as I’ve found out, they aren’t! However, for tables with over 200 fields this method is quite tiresome (and annoying for colleagues unless they’re using a headset).  Nice as I am I ...160; A...

blog.hoegaerden.be

BI: Beer Intelligence? · Automating SSRS Deployment: Download

http://blog.hoegaerden.be/2013/01/30/automating-ssrs-deployment-download

Serving you my best brews, one pint at a time! Lsaquo; SQLUG: Automating SSRS Deployments. Connecting Shapes In Word ›. Automating SSRS Deployment: Download. January 30, 2013. As promised yesterday during my SQLUG presentation on Automating SSRS Deployments Using Built-in SQL Server Tools. You can download the slides and demos through this link. Comments feed for this article. Trackback link: http:/ blog.hoegaerden.be/2013/01/30/automating-ssrs-deployment-download/trackback/. On March 2, 2013 at 3:48 PM.

blog.hoegaerden.be

BI: Beer Intelligence? · Scripts

http://blog.hoegaerden.be/scripts

Serving you my best brews, one pint at a time! The posts on my blog are not always your typical blog post.  Sometimes I consider them to be called article. Other times I post a script to achieve a specific task.  This page is meant to hold a reference and short description to all scripts I ever posted. Recursively Delete SSIS Folder. To achieve the task, dynamic SQL, table variables and some system tables and undocumented stored procedures are being used. Script: Find All Empty Columns In Database. SQL S...

codeplex.com

CodePlex - supertigerzou

http://www.codeplex.com/site/users/view/supertigerzou

Project Hosting for Open Source Software. Member Since November 25, 2010. Last Visit January 4, 2015. Sample app for Adventureworks database. No personal statement has been written. No activity in the last 60 days. 91;Moved] Access Control Service Samples and Documentation. Code Snippet With Syntaxhighlighter Support for Windows Live Writer. Datajs - JavaScript Library for data-centric web applications. Microsoft SQL Server Community Samples: Integration Services. Windows Workflow Foundation on Codeplex.