home  >  people  >  DevinKnight

DevinKnight

Devin Knight

Profile

Name:
Devin Knight
Location:
N/A
Bio:
Devin (MCTS) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin helps run his local users’ group (JSSUG) as a Vice President.
Interests:
N/A

Community info

Member since:
10/27/2009 11:25:07 AM
Rank:
2
Role:
SiteAdministrator
Total Posts:
27
Total points:
1347

Personal Information

Favorite Music:
N/A
Favorite TV Shows:
N/A
Favorite Books:
N/A
Favorite Cuisines:
N/A
Occupation:
Senior BI Consultant & Trainer
Sex:
Male
Industry:

 You have chars left.

mshapiro

mshapiro  Devin, Is there a way to dynamically name a reportign services subscription file when you generate it to a netowrk share. For example name it as FileName + IntegerDate? You said that it will auto increment the file name if a file already exists. Also is there a way to delete the old file if you want before creatign a new one? Thanks, Max

3/9/2010 12:37:27 PM  ·   · 

Page 1 of 1 (1 items)
Latest Articles RSS Feed
  • Using SSIS to Automate the Creation of Cube Partitions
    This article will show you a method for using SSIS to create SSAS partitions in and automated process. No longer will you have to create partition in the designer. Create an SSIS package to do all the work for you the schedule it to run when needed.
    2/2/2010 6:01:42 PM - Comments: 4
  • Developing an End to End Data Mining Report
    In this article you will learn how to develop an End to End Reporting Services report using a Data Mining dataset. The article assumes you already have a data mining model created but if you do not a sample is provided.
    1/24/2010 5:25:59 PM - Comments: 1
  • Creating a Reporting Services Data Driven Subscription
    In this article you will learn how to create a Data Driven Subscription so your reports will run unattended on a schedule dynamically.
    1/4/2010 9:25:59 AM - Comments: 2
  • Analysis Services Usage-Based Optimization (UBO)
    Devin continues to show how performance optimization in SSAS can be done in a few short steps. This article details a feature called Usage-Based Optimization (UBO) that allows you to use user queries to tune query performance.
    12/28/2009 10:34:20 PM - Comments: 0
  • Analysis Services Aggregations
    In a previous article Devin showed how creating partitions can help performance optimization in SSAS. Now you are ready for the next performance tuning phase where you will design aggregations on your partitions.
    12/25/2009 12:04:46 AM - Comments: 0
  • Creating a Reporting Services Subscription
    This article gives you step by step instructions on how to enable Subscriptions on a report so users will have a report automatically delivered to them to a Windows File Share.
    12/22/2009 9:25:59 AM - Comments: 0
  • Analysis Services Partitions
    Dealing with large amounts of data in a cube can drag down performance on two levels (query performance and processing performance). In this part one article learn how you can performance tune Analysis Services to increase both query and processing performance.
    12/21/2009 6:16:01 PM - Comments: 2
  • Five SSIS Best Practices you can Take to the Bank
    This article will give you a good start on best practices that you can follow while creating SSIS solutions.
    12/16/2009 9:25:59 AM - Comments: 5
  • SSIS Interview Questions and Tips
    Preparing to interview for a SSIS job? Read this article to help you get ready for what could be some unexpected questions.
    11/27/2009 8:41:49 PM - Comments: 1
  • Using Excel 2007 in SSIS 2005
    Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade.  This results in the majority of companies still running previous versions of SQL Server (2005, 2000, and even earlier).  Many times as the developer yo...
    3/2/2010 10:16:14 PM - Comments:1
  • Using Database Transactions across multiple SSIS Tasks
    If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed.  For example, if you have a transaction running on an entire package some tasks may not rollback on a failure.  A file system task is one of...
    3/2/2010 8:17:55 AM - Comments:1
  • IntelliSense Slow to Refresh
    IntelliSense in SQL Server 2008 can sometimes not be very intelligent.  It’s there to help you can sometimes cause more problems than it does solve problems.  Here’s one of those problems cases: Create a table without using the UI.  Just type a basic scri...
    2/23/2010 11:36:14 AM - Comments:0
  • Free Webinar Series This Week
    If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners.  This series is meant to get you up to speed on many topics like TSQL, DBA Fundamentals, SSIS, SSAS, SSRS, and Performance Tuning.  Oh and did...
    2/22/2010 6:50:40 PM - Comments:0
  • Development Lifecycle Deployment SSAS, SSRS, SSIS
    Many companies have a very rigid development lifecycle for all products or solutions they develop.  Deploying to each of these environments (Development, UAT, and Production) can be a nightmare to maintain.  Luckily there is a great feature in Visual Stud...
    2/17/2010 10:26:07 AM - Comments:0
  • Foundation Class Review
    This week was an exciting teaching week for me.  I taught the Pragmatic Works Foundation class, one of my favorite and most rewarding classes to teach.    This class is designed to help individuals who have a passion for technology but do not have means t...
    2/12/2010 10:22:46 PM - Comments:0
  • Pragmatic Works Foundation Class Introduction
    You may have noticed a flux of new blog post entires yesterday from a group of people talking about the Pragmatic Works Foundation.  This is a great group of people that are new to IT and learning the basics of SQL Server. Per our website: The Pragmatic W...
    2/9/2010 8:38:56 AM - Comments:0
  • SSRS Commonly Required Date Expressions
    Reporting Services has many expressions that can manipulate date fields.  These expressions can be used just about anywhere in SSRS including object properties, displayed data, and parameters.  Recently I’ve worked on some projects that required date para...
    2/5/2010 2:01:40 PM - Comments:0
  • Handling Escape Sequences in SSIS Expression String Literals
    The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic.  When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code.  ...
    1/27/2010 1:18:27 PM - Comments:3
  • SSIS Checkpoints with Tasks Running in Parallel
    Several months ago I blogged about why Checkpoints are a great feature in SSIS to use.  It seems with every feature there are potential problems you can run into and it is no different with Checkpoints.  The major problem or what some people would call a ...
    1/22/2010 1:40:42 PM - Comments:2
10 .
  • SQL Saturday #38 Jacksonville
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 8 2010 at The University of North Florida Campus, 1 UNF Drive, Jacksonville, FL 32224. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
    1/8/2010 10:20:18 AM
  • SQL Saturday #31 Chicago
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Apr 17 2010 at Holiday Inn Elk Grove Village, 1000 Busse Rd, Elk Grove Village, IL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
    12/16/2009 9:16:57 PM
  • SQL Saturday #29 Birmingham
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 27 2010 at Jefferson State Community College, 4600 Valleydale Road, Birmingham, AL 35242. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
    12/16/2009 9:11:24 PM
  • SQL Saturday #33 Charlotte
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 6 2010 at Central Piedmont Community College, 2800 Campus Ridge Rd, Matthews, NC 28105. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
    12/16/2009 9:06:29 PM
  • SQL Saturday #37 Philadelphia
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 13 2010 at Mandeville Hall, St. Joseph's University, 5600 City Line Ave, Philadelphia, PA 19131-1395. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
    12/16/2009 9:01:55 PM
  • PASS DW/BI Virtual Chapter Presents: The many-to-many compression algorithm of SSAS
    PASS DW/BI Virtual Chapter Presents: The many-to-many compression algorithm of SSAS Speaker: Eugene Asahara Date: Monday Dec 21st 12pm EST Topic Description: This session presents four optimization techniques for cubes with characteristics that are typical in click-stream analysis  and CRM-focused (Customer Relationship Management) Analysis Services 2005 cubes. https://www.livemeeting.com/cc/usergroups/join?id=8H8H93&role=attend&pw=H%3F%244%252zFK AUDIO INFORMATION -Computer Audio(Recommended) To use computer audio, you need speakers and microphone, or a headset. FIRST-TIME USERS To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting. http://go.microsoft.com/fwlink/?LinkId=90703 TROUBLESHOOTING Unable to join the meeting? Follow these steps:   1. Copy this address and paste it into your web browser:      https://www.livemeeting.com/cc/usergroups/join   2. Copy and paste the required information:         Meeting ID: 8H8H93         Entry Code: H?$4%2zFK         Location: https://www.livemeeting.com/cc/usergroups If you still cannot enter the meeting, contact support: http://r.office.microsoft.com/r/rlidLiveMeeting?p1=12&p2=en_US&p3=LMInfo&p4=support NOTICE Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
    12/1/2009 9:39:28 PM
  • PASS DW/BI Virtual Chapter Presents: Zero to Cube in 60 Minutes
    PASS DW/BI Virtual Chapter Presents: Zero to Cube in 60 Minutes Speaker:              Adam Jorgensen Date:     Fri. Dec. 18 th 12pm EST Topic Description: Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.   https://www.livemeeting.com/cc/usergroups/join?id=K65GR6&role=attend&pw=wq57S%5E%5B%2Bs   AUDIO INFORMATION ·          Computer Audio(Recommended) To use computer audio, you need speakers and microphone, or a headset.     FIRST-TIME USERS To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting. http://go.microsoft.com/fwlink/?LinkId=90703 TROUBLESHOOTING Unable to join the meeting? Follow these steps: 1.    Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/usergroups/join 2.    Copy and paste the required information: Meeting ID: K65GR6 Entry Code: wq57S^[+s Location: https://www.livemeeting.com/cc/usergroups If you still cannot enter the meeting, contact support: http://r.office.microsoft.com/r/rlidLiveMeeting?p1=12&p2=en_US&p3=LMInfo&p4=support NOTICE Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
    12/1/2009 9:31:23 PM
  • PASS DW/BI Virtual Chapter Presents: Looping, Moving Files, and Splitting Data Streams: Intermediate SSIS Tasks for the DBA
    PASS DW/BI Virtual Chapter Presents:  Looping, Moving Files, and Splitting Data Streams: Intermediate SSIS Tasks for the DBASpeaker: Tim Mitchell Date: Tues Dec 15th 12pm EST Topic Description: In this session, we'll explore some of the intermediate-level tasks and data flow components of SSIS. Join in as we review the File System Task and the For Each Loop container, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.  About Tim Mitchell Tim Mitchell is a Microsoft SQL Server consultant, developer, speaker, and trainer.  He has been working with SQL Server for over 6 years, working primarily in database development, business intelligence, ETL/SSIS, and reporting.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce.  As an active member of the community, Tim has spoken at venues including SQL Saturday and the PASS Business Intelligence virtual chapter, is an active volunteer and speaker at the North Texas SQL Server User Group in Dallas, and is a volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com.  Read Tim's blog at www.TimMitchell.net , or follow him on Twitter (twitter.com/tim_mitchell).https://www.livemeeting.com/cc/usergroups/join?id=JJCP8T&role=attend&pw=2%24%25%3CM%2Fxdz AUDIO INFORMATION -Computer Audio(Recommended) To use computer audio, you need speakers and microphone, or a headset. FIRST-TIME USERS To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting. http://go.microsoft.com/fwlink/?LinkId=90703 TROUBLESHOOTING Unable to join the meeting? Follow these steps:   1. Copy this address and paste it into your web browser:      https://www.livemeeting.com/cc/usergroups/join   2. Copy and paste the required information:         Meeting ID: JJCP8T         Entry Code: 2$%<M/xdz         Location: https://www.livemeeting.com/cc/usergroups If you still cannot enter the meeting, contact support: http://r.office.microsoft.com/r/rlidLiveMeeting?p1=12&p2=en_US&p3=LMInfo&p4=support NOTICE Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
    12/1/2009 9:24:20 PM