home  »  people  »  BrianKnight

BrianKnight

Brian Knight

Profile

Name:
Brian Knight
Location:
N/A
Bio:
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com.
Interests:
N/A

Community info

Member since:
10/22/2009 5:15:12 PM
Rank:
2
Role:
Member
Total Posts:
32
Total points:
724

Personal Information

Favorite Music:
Seven Nations
Favorite TV Shows:
The Office
Favorite Books:
Steven King's Dark Tower series
Favorite Cuisines:
Italian and sushi
Occupation:
Founder, Pragmatic Works and BIDN
Sex:
Male
Industry:
Loading ...

Confirm

Latest Articles RSS Feed
  • Making SSIS Lookups Dynamic and Parameterized
    In this article by Brian Knight, you'll learn how to make the Lookup Transform dynamic in SQL Server 2008. He shows you also in SQL Server 2008 how to use the Cache Transform.
    12/21/2009 9:11:02 PM - Comments: 3
  • Tutorial: Creating Your First SSIS Package
    In this tutorial, Brian shows you how to create your first basic SSIS package.
    12/17/2009 9:25:59 AM - Comments: 4
  • Calculating Percentile in SQL Server Analysis Services MDX
    In this article, you'll learn how to use MDX to calculate percentile easily. See how to condense tons of T-SQL code to simple MDX calculations.
    11/26/2009 6:00:00 AM - Comments: 0
  • Agile Development with Scrum
    In this article, you'll learn about the Scrum development methodology.
    11/24/2009 9:25:59 AM - Comments: 3
  • Adding Conditional Formatting into Reporting Services
    In this article, you'll learn how add basic formatting to an SSRS report such as alternating colors between rows or setting a fields color to be dynamic.
    11/24/2009 9:25:59 AM - Comments: 3
  • Developing Your First SSRS Report for SQL Server 2005
    Trying to get past the Microsoft SQL Server Reporting Services learning curve? Well never fret, this article is a first in a series of tutorials to walk you through creating a practical report for your company to monitor your SQL Server’s databases. In this sample report, we’re going to create a job monitoring system. Specifically, we’re going to c
    11/24/2009 9:25:59 AM - Comments: 1
  • SQL Server 101 Webinar Series
    February SQL Server 101 Series New to SQL Server or trying to enter the field? This webinar series will walk you through the Microsoft SQL Server stack so that you can become a DBA or Business Intelligence (BI) developer. Registration Open...
    2/22/2010 5:11:32 PM - Comments:1
  • SQL Saturday and PASS
    I wanted to post this letter that just went out from PASS. As it reads, Andy, Steve and I are excited to announce that we have gifted one of our prized brands, SQL Saturday to PASS to grow the brand with the community owning at a whole. Normal ...
    2/2/2010 4:54:40 PM - Comments:1
  • SQL Lunch Code - Scripting in SSIS
    Thanks for all who attended my SQL Lunch session! There was a few questions that reoccured. One was about the free components I showed. The free component was Task Factory and can be downloaded from http://www.pragmaticworks.com. The other was for the cod...
    1/19/2010 1:27:25 PM - Comments:0
  • SSAS MDX Year to Date (YTD) Calculation Example
    Often times, you want to analyze sales using a year to date view as shown below: While you can do this in an MDX formula in SSRS, you might find this calculation valuable enough to store a server-side calculation. To do this, you'll need to pick what date...
    12/18/2009 9:13:36 AM - Comments:0
  • Watch the BIDN.com Twitter Feed
    We're moving fast at the BI Developer Network (BIDN.com). In an effort to make sure you get your BI questions answered, we've installed a new twitter interface that if your question in our forums doesn't go answered after 2 days, it will escallated in a n...
    12/17/2009 10:38:49 PM - Comments:1
  • A Simple Twitter Console Application
    I've been working this week to automate the BIDN.com's twitter connectivity and to do so, decided to build a quick Twitter interface to communicate with BIDN.  I needed a simple console application that could be called via a trigger or a SQL Agent Job (my...
    12/17/2009 2:16:00 PM - Comments:2
  • The Need for More Data on Unknown Members
    As ETL developers, we typically lump anything that's NULL or something we can't find an ETL lookup match on to -1 or "unknown". We would first of course have to create an Unknown record in each dimension table then during the ETL attempt an INNER JOIN int...
    12/7/2009 7:50:35 AM - Comments:1
  • MDX Example Code
    After promising a dozen people a dozen times that I'd do this, I finally posted my MDX examples that use during my sessions http://www.bidn.com/files/ . You'll need to have the AdventureWorks cube installed, which you can get from the CodePlex site here: ...
    12/1/2009 11:06:37 PM - Comments:5
  • Microsoft BI Video Resources
    I just stumbled upon a great resource for Microsoft BI believe it or not, on the Microsoft website. The first one is a list of short concise videos about how to implmement BI:   http://www.microsoft.com/events/series/bi.aspx?tab=videos   On the same site,...
    11/29/2009 11:27:01 AM - Comments:2
  • BI xPress 2.0 Launch
    I'm excited to announce the new version of BI xPress 2.0. It has a new feature called a Package Builder. The Package Builder will allow you to capture components of SSIS into a template that you can reuse and deploy to hundreds of packages in seconds. You...
    11/13/2009 8:37:40 PM - Comments:0
10 people found.
  • SQL Saturday #38 Jacksonville, FL
    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/9/2010 8:47:12 PM
  • Task Factory
    Come see the unveiling of the next version of Pragmatic Works' SSIS extension product, Task Factory. We'll be launching a large amount of new SSIS tasks, sources, transforms and destinations. Also learn what's in store for the road map of this SSIS cornerstone product. These components will potentially shave hours off your SSIS load window and allow you to do things with SSIS that no one could ever do previously
    11/8/2009 11:44:50 AM