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 41 to 60 of 142    Older >>
 

Creating a Matrix Report - SQL School Video

In this video, you will learn how to use Reporting Services to build a report that contains a matrix of data.  Read more...
By Brian Knight 2008/09/09 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,870 reads

Creating a Data Mining Reporting Services Report - SQL School Video

In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.  Read more...
By Brian Knight 2008/09/04 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,174 reads

Adding a timestamp to files in SSIS - SQL School Video

Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.  Read more...
By Brian Knight 2008/09/16 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,300 reads

Using Profiler - SQL School Video

A basic tutorial that examines how Profiler can be used in SQL Server 2005 to monitor your SQL Server instance. MVP Brian Knight shows how to create a trace and the various options you have for monitoring events.  Read more...
By Brian Knight 2008/09/02 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,479 reads

Scripting Table Management - SQL School Video

MVP Brian Knight walks through the scripting capabilities of Management Studio to show how the code for table creation and the various dependent objects. Brian looks at the options available with scripting and what the implication of choosing them will be.  Read more...
By Brian Knight 2008/08/26 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 2,341 reads

Creating Lift Charts - SQL School Video

This video covers lift charts, an advanced data mining feature in SQL Server 2008. MVP Brian Knight walks through a data mining example that tests a model with a lift chart.  Read more...
By Brian Knight 2008/08/21 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 2,008 reads

Detaching Databases - SQL School Video

One very handy technique for dealing with the need to copy or move a database involves detaching the database from your instance. MVP Brian Knight shows how easy this can be to perform on your server.  Read more...
By Brian Knight 2008/08/14 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,490 reads

Attaching Databases - SQL School Video

Learn how you can add a new database to your instance if you receive the MDF and LDF files from another source. MVP Brian Knight covers this very useful technique that is used for moving databases to new instances, servers, or even recovering from an disaster.  Read more...
By Brian Knight 2008/08/12 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,119 reads

Viewing Analysis Services Data in Excel 2007 - SQL School Video

Excel is a wonderful tool for examining the data in your SSAS cubes. MVP Brian Knight shows how you can access the data in Analysis Services or a SQL Server database from Excel 2007.  Read more...
By Brian Knight 2008/08/07 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,379 reads

Creating Views - SQL School Video

This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.  Read more...
By Brian Knight 2008/07/31 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,192 reads

Creating Stored Procedures - SQL School Video

MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.  Read more...
By Brian Knight 2008/07/29 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 10,748 reads

A Review of sqlSentry 2.5

In this review, Brian reviews one of his favorite tools in his DBA toolkit. He shows you some of the new features in this event management system and how it can shave hours off your day each day.   Read more...
By Brian Knight 2006/01/12 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 6,629 reads

Upgrading SQL Server 2000 DTS Packages to SSIS

If you're like Brian Knight, you probably have dozens if not hundreds of DTS packages running around that you're terrified to touch. SQL Server 2005 has some interesting methods to upgrade your packages to SSIS with minimal effort. This article shows you a few ways that you can use to upgrade and some of the drawbacks.   Read more...
By Brian Knight 2008/05/23 (first published: 2005/12/27) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 65,361 reads

Day 2 of TechEd

Day 2 from TechEd, this time from Brian Knight's perspective as the SQLServerCentral.com crew enjoys a week of learning and sun at the 2005 conference.   Read more...
By Brian Knight 2005/06/08 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 5,066 reads

Agile Development with Scrum

We've all been there: the project that never ends and no light at the end of the tunnel. Nothing is more disheartening to a developer, DBA or anyone else that may be on a project than a finish line that has no end in sight or worse yet, one that keeps moving. Agile and Scrum development methodologies aim to fix this problem and others by applying what will appear to be common sense after you engage in the methodology for a few projects. This article will get you acquainted with my now-favorite d   Read more...
By Brian Knight 2005/05/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,020 reads

Comparison of SQL Server 2005 Editions

On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.   Read more...
By Brian Knight 2006/09/01 (first published: 2005/02/28) | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 61,730 reads

First Impressions of SQL Server 2005: Installation and Tools

Brian Knight has started a new series base on his impressions of SQL Server 2005, Beta 2, aka "Yukon". Read about his first impressions of the product as he starts down the path of learning about the next version of SQL Server.   Read more...
By Brian Knight 2004/08/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 18,521 reads

Tutorial: Changing the Visibility Objects in Reporting Services

In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we have created our first report and have added a bit of flare to it, we will go ahead and make it even cleaner. In this very quick demonstration, we will go ahead and change the visibility of rows or columns based on given conditions.   Read more...
By Brian Knight 2004/07/20 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 17,847 reads

Tutorial: Adding Conditional Formatting into Reporting Services

Last time, we discussed how to create your first report in Microsoft SQL Server Reporting Services. The report we created was a status report on SQL Server Agent jobs. The report we created was from the template and was very crude looking because of that. In this short article, we are going to look at improving that report and answer a common newsgroup question I see. This week, we are going to set the rows of the report to alternate colors.   Read more...
By Brian Knight 2005/09/16 (first published: 2004/07/06) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 66,999 reads

Tutorial: Designing Your First Report in SQL Server Reporting Services

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 databases. In this sample report, we are going to create a job monitoring system. Specifically, we are going to connect to our SQL Server and report if the jobs succeeded or failed the last time they ran.   Read more...
By Brian Knight 2005/08/05 (first published: 2004/06/28) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 70,631 reads
<< Newer    Items 41 to 60 of 142    Older >>