Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Devin Knight

Devin is a 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 is a participating member of the local users’ group (JSSUG).

Archives: February 2010

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 script to create a…

Read more

8 comments, 2,626 reads

Posted in Devin Knight on 23 February 2010

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 don’t forget… Read more

0 comments, 238 reads

Posted in Devin Knight on 22 February 2010

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 Studio called Solution Configurations, which will allows you to toggle between… Read more

0 comments, 322 reads

Posted in Devin Knight on 17 February 2010

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 Studio called Solution Configurations, which will allows you…

Read more

4 comments, 1,818 reads

Posted in Devin Knight on 17 February 2010

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 to pay for… Read more

0 comments, 229 reads

Posted in Devin Knight on 12 February 2010

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 Works Foundation was… Read more

0 comments, 252 reads

Posted in Devin Knight on 9 February 2010

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 parameters to do things that you would typically see in an Analysis…

Read more

0 comments, 1,894 reads

Posted in Devin Knight on 5 February 2010