Search Results: Compression

• 
  Checking a File in Use and File Compression in SSIS with Task Factory

  Checking a File in Use and File Compression in SSIS with Task Factory Getting compressed files from customer is a common occurrence in today’s database world. Decompressing and loading those files can be a lot of work, even in SSIS. Task Factory makes thi

  Author:  MikeDavis     Date: 6/8/2011     Section: Blog

  tags : Compression, File in Use, File Properties, Files, Task Factory, Zip, SSIS
• 
  Task Factory - TF Compression

  In previous posts I’ve been working through some of the Task Factory components. As many of you know I went to work for Pragmatic Works earlier this year. Since then I’ve been learning all our tools, and since there’s no better way to learn than by teachi

  Author:  arcanecode     Date: 7/16/2011     Section: Blog

  tags : Pragmatic Works, SQL Server Integration Services, Task Factory, SSIS
• 
  Task Factory: Compression Task

  Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg

  Author:  briankmcdonald     Date: 9/3/2011     Section: Blog

  tags : Brian K McDonald, Compression Task, task factory
• 
  Exploring Row and Page Compression with SQL 2008 - Part 2: The estimates

  Hopefully if you are reading this post, then you have already read PART 1 of this series. http://www.bidn.com/blogs/bretupdegraff/bidn-blog/263/exploring-row-and-page-compression-with-sql-2008-part-1-the-research In review, we are taking an 80 Gig data wa

  Author:  bretupdegraff     Date: 12/13/2009     Section: Blog

  tags : Compression, SQL 2008
• 
  Task Factory - TF File Properties

  My last video on the Task Factory Compression Task was well received, so I thought I’d build on it with a video on the File Properties Task. It’s a cool little tool that will grab any of the various attributes associated with a file. If you want to see mo

  Author:  arcanecode     Date: 7/19/2011     Section: Blog

  tags : SQL Server Integraion Services, SSIS, Task Factory, Pragmatic Works
• 
  unzip file using ssis

  Yes, you can use the Execute Process Task within SSIS to unzip or zip up files. I wrote an article a while back that walks you through using Winrar , but winzip is similar. The argument will be different though. I have also used 7zip in the past. There is

  Author:  briankmcdonald     Date: 11/6/2010     Section: Forum

  tags : 7Zip, Compression, Task Factory, WinRar, WinZip, SSIS
• 
  Speaking Twice This Week

  This week I will have the opportunity to speak at two different events. The first is on Monday, April 12 th , at the SQL Lunch . I will be doing an Introduction to SSIS presentation . The presentation is online and will begin at 11:30 AM CST. If you have

  Author:  PatrickLeBlanc     Date: 4/11/2010     Section: Blog

  tags : PASS, User Group, SQL Lunch
• 
  Creating a tabular database

  In SQL Server 2012 Analysis Services, Microsoft introduced the xVelocity engine and the tabular model for databases into Analysis Services. This gives much more compression and performance, but not all of the features of multi-dimensional databases are av

  Author:  ChrisSchmidt     Date: 10/23/2012     Section: Blog

  tags : 2012, Analysis Services, BI, BISM, Business Intelligence, DAX
• 
  SQL 2008 Compression

  Hmmmm. Just a quick anecdote about SQL's backup compression. I backed up a DB, tiny one, no compression, resulted in a size of 5636 KB. I was mailing it out, so I quickly 7Zipped it, and got a size of 434KB. Pretty impressive ratio actually, but I've alwa

  Author:  MarkGStacey     Date: 1/29/2010     Section: Blog
• 
  Exploring Row and Page Compression with SQL 2008 - Part 1: The research

  Our application runs on SQL 2005 and so we are looking at the upgrade path to SQL 2008 and even SQL 2008 R2. This application has been installed at over 20 locations (clients) and they all have thier own installation and environment for SQL Server. In ord

  Author:  bretupdegraff     Date: 12/13/2009     Section: Blog

  tags : SQL 2008, Compression
• 
  Speaking at Charlotte, NC - SQL Saturday #33

  If you are near Charlotte, NC , I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server Compression 101 is at 1:30 PM. This is the first SQL Saturday under PASS management. If you have not registered for this event do so, seats

  Author:  PatrickLeBlanc     Date: 3/1/2010     Section: Blog

  tags : Compression, Speaking, SQL Saturday, Patrick LeBlanc
• 
  Just how does Data Compression work in SQL Server 2008?

  In this blog I will shed some light on exactly what goes on behind the scenes when using data compression in SQL Server 2008. Hopefully this will better help you decide which option is best for your scenario without taking a stab-in-the-dark approach to i

  Author:  kylewalker     Date: 1/24/2010     Section: Blog
• 
  Speaking at the Houston Techfest

  I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes this trip even more exciting. This is a free event that offers a diverse set of sessions. The sessions range from What's new in Java to Introducti

  Author:  PatrickLeBlanc     Date: 10/7/2010     Section: Blog

  tags : Houston Techfest, Patrick LeBlanc, Speaking
• 
  Task Factory - Advanced E-Mail and SMS Task

  I've been continuing my learning process of my companies Task Factory suite. Building on my previous work with the Compression task ( video ) and File Properties task ( video ) I've now created a new video about the Advanced E-Mail and SMS Task. After com

  Author:  arcanecode     Date: 8/5/2011     Section: Blog

  tags : Pragmatic Works, SSIS, Task Factory
• 
  MS Airlift Event in Seattle

  I have posted several entries lately about events that I’ve been attending, speaking and listening at and one of the most interesting ones was the Microsoft SQL Server 2008 R2 Partner Airlift Event. This is a chance for MS to show off all the new cool fea

  Author:  AdamJorgensen     Date: 5/24/2010     Section: Blog

  tags : Travel, Events
• 
  int's versus tinyint's in star schema -- performance issue?

  Well, in my opinion, you should be standardising the data type for your keys across the different tables, and if you have a fact table that will use int, then use ints across the warehouse. That is the methodology I use, it means that when creating a new

  Author:  MarkGStacey     Date: 7/7/2010     Section: Forum
• 
  Zipping Multiple Files Into One Archive in SSIS

  When archiving files, it is common to encounter the need to zip multiple files into one archive. This can be easily done with the help of Task Factory. For this example, I will use a file system task, the Task Factory Compression Task, and a ForEach Loop

  Author:  ShawnHarrison     Date: 11/28/2011     Section: Blog
• 
  Upcoming Community Events!

  Just a head's up. I've got a few speaking engagements coming up in the near future. Come out and join me at these fantastic free community events! 3/10/2012 - SQL Saturday #110 Tampa Introduction to Master Data Services 2012 More Info | Session Info 3/13/

  Author:  cprice1979     Date: 2/9/2012     Section: Blog

  tags : Compression, IT Pro Camp, PASS, PASS BI Virtual Chapter, SQL Saturday
• 
  Recap - SQL Saturday #32 Tampa

  This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa. First, I just want to say what an event. The lunch that was served set a new precedence for all of the upcoming SQL Lunches. We had a sit down meal with silverware and plate

  Author:  PatrickLeBlanc     Date: 1/24/2010     Section: Blog

  tags : Data Compression, SQL Saturday, Speaking