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:
SiteAdministrator
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:

 You have chars left.

MattSmith

MattSmith  Thanks. I'm looking forward to being involved with the community. I see alot of potential here!

3/9/2010 2:38:37 PM  ·   · 

SQLPadawan

SQLPadawan  By the way, You da' Man!

2/25/2010 8:31:05 PM  ·   · 

SQLPadawan

SQLPadawan  Brian, I tried registering three times and I never received the promised confirmation email. Please advise.

2/25/2010 8:30:39 PM  ·   · 

lduvall

lduvall  In the 9am SSIS webinar, you showed how to turn off the Splash screen in BID. I can't get mine to work. This is what I put in the target. It wouldn't let me put the command inside the quotes. "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" -NOSPLASH

2/25/2010 10:53:13 AM  ·   · 

ericbock

ericbock  Brian, your old "Blog relocating" post on whiteknighttechnology.com [ http://whiteknighttechnology.com/cs/blogs/brian_knight/archive/2008/01/21/1820.aspx ] contains a link that doesn't properly redirect to your blog here. Seeing how whiteknighttechnology.com comes up first when I googled your name I thought you might want to update the link or the redirect.

1/22/2010 9:06:08 AM  ·   · 

nitya

nitya  Thanks for the autographed book! http://tweetphoto.com/8531429

1/11/2010 4:59:44 PM  ·   · 

marcoadf

marcoadf  I brian. Let me congratulate you for all you've done and still doing for the BI community. I have a lot of experience in all BI tools of microsoft, and now its time to share all this knowledge. And I want to start filling my blog. I want to make some videos as you do in jumpstarttv. There is no problem of creating a video just to introduce, and link into my BIDN blog (and vice-versa) to deeper information? Best Regards Marco Francisco

1/9/2010 7:06:16 AM  ·   · 

ashishnaik1

ashishnaik1  Hi Brian! Is the book contest is still going on?

1/6/2010 8:43:16 AM  ·   · 

DevinKnight

DevinKnight  Watch your back. I'm coming after you and your points lead!

12/29/2009 8:28:17 AM  ·   · 

sudeeptaganguly

sudeeptaganguly  Thanks Brian. I will send you the details. Thanks once agin.

12/28/2009 3:22:57 AM  ·   · 

sudeeptaganguly

sudeeptaganguly  Hello Brian. Is the contest is still going on?

12/24/2009 1:50:46 AM  ·   · 

nitya

nitya  Thanks Brian.

12/22/2009 5:51:35 PM  ·   · 

jmertz

jmertz  This site is just what I am needing for my current project - what timing. Thanks!

12/21/2009 3:12:47 PM  ·   · 

bretupdegraff

bretupdegraff  Hey Brian! Did I make the top 10?

12/7/2009 1:12:44 PM  ·   · 

nitya

nitya  Brian, Kindly answer this http://www.bidn.com/forums/microsoft-business-intelligence/integration-services/31/visual-of-package-without-bids#82 Correct me if i am wrong

12/4/2009 6:16:23 PM  ·   · 

DustinRyan

DustinRyan  yo yo, dawg.

12/4/2009 3:43:03 PM  ·   · 

DustinRyan

DustinRyan  Yo.

12/4/2009 3:42:15 PM  ·   · 

sudeeptaganguly

sudeeptaganguly  Hello Brian, I want to learn about BI. So if you can post some articles, which is for Level: 100, than it will be great. Only after I understand the basics, I can look for advance articles. Thanks.

12/2/2009 6:49:53 AM  ·   · 

dmlenz

dmlenz  Is the sticky topic title in the data warehouse design a typo? "welcome to the ssis forum"

12/1/2009 1:44:52 PM  ·   · 

nitya

nitya  I've been evaluating BI Xpress and am already in love with it

12/1/2009 11:29:14 AM  ·   · 

anilmsql

anilmsql  Thanks a ton Brian, Pleasure to be here :)! This site is gonna rock! for all BI related technologies. Cheers! Anil

12/1/2009 9:13:25 AM  ·   · 

TimMitchell

TimMitchell  Glad to help! Feedback coming your way shortly.

11/29/2009 8:17:22 PM  ·   · 

TimMitchell

TimMitchell  Looking forward to the launch of BIDN!

11/28/2009 11:52:20 PM  ·   · 

BrianKnight

BrianKnight  Working on the BIDN launch!

11/27/2009 11:25:38 PM  ·   · 

BrianKnight

BrianKnight  Getting ready to launch BI xPress 2.0

11/12/2009 9:03:20 PM  ·   · 

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 .
  • 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