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

Regular Columnist: Brian Knight

SQLServerCentral.com profile

Brian Knight, MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server DTS (Wrox Press). Brian is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

<< Newer    Items 21 to 40 of 142    Older >>
 

Creating a Maintenance Plan in SSMS - SQL School Video

Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.  Read more...
By Brian Knight 2008/11/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,082 reads

Using the Aggregate Transform - SQL School Video

MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.  Read more...
By Brian Knight 2008/12/04 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,356 reads

Using the Sort Transform - SQL School Video

This SQL School video shows just how you can sort the data in your SSIS packages.  Read more...
By Brian Knight 2008/11/25 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,243 reads

Using Script Component as a Transformation - SQL School Video

Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.  Read more...
By Brian Knight 2008/11/20 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,956 reads

Using the File System Task - SQL School Video

In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.  Read more...
By Brian Knight 2008/11/13 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,208 reads

Using Data Viewers - SQL School Video

Integration Services is a great system for performing ETL operations between databases. In this video we show how you can use Data Viewers to determine if you are correctly transforming data.  Read more...
By Brian Knight 2008/11/06 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,002 reads

Using Break Points in SSIS - SQL School Video

MVP Brian Knight brings us a look at how you can easily debug your Integration Services packages.  Read more...
By Brian Knight 2008/11/04 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,655 reads

SSIS Configuration Files - SQL School Video

This edition of SQL Server examines the various options available in Integration Services configuration files.  Read more...
By Brian Knight 2008/10/30 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,177 reads

Showing OLAP Data in SSRS - SQL School Video

Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.  Read more...
By Brian Knight 2008/10/14 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,245 reads

Creating a Database Diagram in SSMS - SQL School Video

In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.  Read more...
By Brian Knight 2008/10/02 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,997 reads

Scheduling SSIS Packages - SQL School Video

In this new SQL School video, MVP Brian Knight shows how you can schedule your SSIS packages to execute at a specific time or on a recurring schedule.  Read more...
By Brian Knight 2008/10/09 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,361 reads

Row Count Transform - SQL School Video

Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.  Read more...
By Brian Knight 2008/10/16 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,368 reads

Restoring a Full Database in SSMS - SQL School Video

This SQL School video will show you how to use Management Studio to restore a database in SQL Server 2005.  Read more...
By Brian Knight 2008/10/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,849 reads

Parameterizing SSRS Reports - SQL School Video

MVP Brian Knight continues with Reporting Services in this SQL School video that shows you how you can add parameters to your Reporting Services report to customize them.   Read more...
By Brian Knight 2008/10/07 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,076 reads

Parameterizing an Execute SQL Task - SQL School Video

In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.  Read more...
By Brian Knight 2008/10/23 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,803 reads

Multi Select Parameters in SSRS - SQL School Video

Diving deeper into Reporting Services with this SQL School video, MVP Brian Knight shows how to create a report with a multi-select parameter, allowing the user to select multiple items for inclusion in the report.  Read more...
By Brian Knight 2008/10/21 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,800 reads

Execute an SSIS Package in SSMS - SQL School Video

This video shows how you can use Management Studio to execute your Integration Services packages.  Read more...
By Brian Knight 2008/09/23 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,302 reads

Making SSIS Connections Dynamic - SQL School Video

Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.  Read more...
By Brian Knight 2008/09/25 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,925 reads

Creating a Full Backup in SSMS - SQL School Video

This video shows you how to perform one of the core functions of a DBA: performing a full backup. The use of Management Studio is shown in this video.  Read more...
By Brian Knight 2008/09/18 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,191 reads

Creating a Tabular Report - SQL School Video

SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.  Read more...
By Brian Knight 2008/09/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,647 reads
<< Newer    Items 21 to 40 of 142    Older >>