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.

   Items 1 to 20 of 142    Older >>
 

Using Views and Synonyms for Abstraction - SQL School Video

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.  Read more...
By Brian Knight 2009/01/22 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,277 reads

Writing a Basic MDX Query Pt.2 - SQL School Video

In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.  Read more...
By Brian Knight 2008/12/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,576 reads

Writing a Basic MDX Query Pt.1 - SQL School Video

MDX is the query language for multidimensional queries, usually against SSAS cubes. Brian Knight introduces us to the basics of MDX in this video.  Read more...
By Brian Knight 2008/12/09 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 8,835 reads

Viewing the Data Profiling Task Data - SQL School Video

It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.  Read more...
By Brian Knight 2009/01/27 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,029 reads

Using the Timestamp Data Type - SQL School Video

The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.  Read more...
By Brian Knight 2009/01/29 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,277 reads

Using the CheckSum Function - SQL School Video

There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.  Read more...
By Brian Knight 2008/12/18 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,846 reads

SQL Server Options to Avoid - SQL School Video

Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.  Read more...
By Brian Knight 2009/01/06 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,126 reads

SQL Server Management Studio for Beginners - SQL School Video

Learn the basics of how to work with Management Studio in this SQL School video.  Read more...
By Brian Knight 2009/01/01 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 7,524 reads

Running Singleton Queries Against a DMX Data Mining Model - SQL School Videos

Learn how you can run a singleton data mining query against a cube with a mining model.  Read more...
By Brian Knight 2009/02/24 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 1,734 reads

Running A Basic DMX Query - SQL School Video

This SQL School video introduces us to the data mining queries that you can run from BIDS in an Analysis Services project.  Read more...
By Brian Knight 2009/02/26 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,521 reads

Mining Model Viewers - SQL School Video

In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.  Read more...
By Brian Knight 2009/02/05 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 1,971 reads

Post SQL Server 2008 Upgrade - SQL School Video

After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.  Read more...
By Brian Knight 2009/01/08 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,183 reads

Installing Sample 2008 Databases - SQL School Videos

Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.  Read more...
By Brian Knight 2009/02/03 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,827 reads

Installing & Congfiguring DM Add-in for Excel - SQL School Video

This SQL School video explains how to use the Data Mining add-in for Excel 2007. The installation and configuration are covered.  Read more...
By Brian Knight 2009/02/19 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,894 reads

Formatting SSAS Measures - SQL School Video

ln this SQL School video, learn how you can format the various measures in your SSAS cubes.  Read more...
By Brian Knight 2009/03/05 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,378 reads

Data Mining in Excel 2007 Pt.2 - SQL School Video

In this video MVP Brian Knight continues on with more advanced data mining using Excel.  Read more...
By Brian Knight 2009/02/12 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,237 reads

Data Mining in Excel 2007 Pt.1 - SQL School Video

Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.  Read more...
By Brian Knight 2009/02/10 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,891 reads

Creating Mining Structure - SQL School Video

In this SQLSchool video, MVP Brian Knight shows us how to create a simple data mining model in Analysis Services.  Read more...
By Brian Knight 2009/02/17 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,758 reads

Using SSIS Precedence Constraints - SQL School Video

MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.  Read more...
By Brian Knight 2008/11/27 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,961 reads

Creating a Basic Policy in SSMS - SQL School Video

In SQL Server 2008, we have a new way of enforcing rules on our servers. This video has MVP Brian Knight showing us how to create a basic policy in Policy Based Management.  Read more...
By Brian Knight 2008/11/18 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,665 reads
   Items 1 to 20 of 142    Older >>