Thursday, July 24, 2008

New SharePoint Video Tutorial: Installing SQL Server Management S tudio Express Edition And Connecting To The SharePoint Database

Installing SQL Server Management Studio Express Edition And Connecting To The SharePoint Database - view details
Behind the scenes of Windows SharePoint Services(WSS), is Microsoft SQL Server. If you allow SQL to install the SQL Server 2005 Embedded Edition when you first install WSS, you can then take advantage of SQL management for your database. By visiting www.Microsoft.com/sql you can download the SQL Server Managemnt Studio (SSMS) Express Edition, which we will be installing in this video. In this video tutorial, Grant will walk you through the complete installation of SSMS and demonstrate to you how you can connect to your SharePoint database.

Highlights from this video:
  • Setting up your install
  • Browsing for/connecting to your server when working in SSMS
    • The magic string for connecting to your SharePoint server
  • Navigating the Object Explorer in SSMS
  • What can we do with our information in our database?
  • Browsing through your tables
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: install, ssms, sql server, management studio, connect, database, installing,

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View

How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View - view details
In this video we will take a look at what makes up a SharePoint site via a behind-the-scenes look. We know that the majority of our SharePoint management is done using a web interface to either a SharePoint site or to the SharePoint configuration management on the server that has SharePoint installed on it. In this video we will go below that surface level to what is operating below with SQL.

Highlights from this video:
  • About the SharePoint structure
  • How SharePoint interacts with SQL Server
    • What happened when I first installed my SharePoint server?
    • What will be installed specifically for SQL Server?
  • Demystifiying the 4 main databases
    • System Database
    • Admin Content
    • WSS Content
    • WSS Search
  • Digging deeper: Exploring the WSS Content database
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, management, manage, structure, database, server,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 7 - Miscellaneous For matting Options

Part 7 - Miscellaneous Formatting Options - view details
In our last video in the series we will?? briefly discuss some of the miscellaneous topics that didn't fit anywhere else in this series in regards to formatting our chart.

Highlights from this video:

  • Working with the 3-D effect on your chart
  • Using the format code and point labels
  • Editing the appearance of specific values when working with a color palette
    • Changing bar color
    • Gradients
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: chart, graph, chart control, custom, format, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

Wednesday, July 23, 2008

New SharePoint Video Tutorial: Installing SQL Server Management S tudio Express Edition And Connecting To The SharePoint Database

Installing SQL Server Management Studio Express Edition And Connecting To The SharePoint Database - view details
Behind the scenes of Windows SharePoint Services(WSS), is Microsoft SQL Server. If you allow SQL to install the SQL Server 2005 Embedded Edition when you first install WSS, you can then take advantage of SQL management for your database. By visiting www.Microsoft.com/sql you can download the SQL Server Managemnt Studio (SSMS) Express Edition, which we will be installing in this video. In this video tutorial, Grant will walk you through the complete installation of SSMS and demonstrate to you how you can connect to your SharePoint database.

Highlights from this video:
  • Setting up your install
  • Browsing for/connecting to your server when working in SSMS
    • The magic string for connecting to your SharePoint server
  • Navigating the Object Explorer in SSMS
  • What can we do with our information in our database?
  • Browsing through your tables
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: install, ssms, sql server, management studio, connect, database, installing,

posted by Scott Whigham @ 11:00 AM  

New SharePoint Video Tutorial: How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View

How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View - view details
In this video we will take a look at what makes up a SharePoint site via a behind-the-scenes look. We know that the majority of our SharePoint management is done using a web interface to either a SharePoint site or to the SharePoint configuration management on the server that has SharePoint installed on it. In this video we will go below that surface level to what is operating below with SQL.

Highlights from this video:
  • About the SharePoint structure
  • How SharePoint interacts with SQL Server
    • What happened when I first installed my SharePoint server?
    • What will be installed specifically for SQL Server?
  • Demystifiying the 4 main databases
    • System Database
    • Admin Content
    • WSS Content
    • WSS Search
  • Digging deeper: Exploring the WSS Content database
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, management, manage, structure, database, server,

posted by Scott Whigham @ 10:58 AM  

New SharePoint Video Tutorial: Moving a SharePoint Content Databa se To A Different Disk on the Same System

Moving a SharePoint Content Database To A Different Disk on the Same System - view details
When you install Windows SharePoint Services 3.0 on to Windows 2003 server, by default it will install a SQL Server Embedded edition to host to the database. The database, by default, will be built on the C:/ drive. In this video we're going to take a look at how you can you the SQL Server Express tools to move the database to a different drive letter, because perhaps you're running out of room on the C:/ drive or your database design is needing you to move the database. This is a fairly quick and easy thing to do, provided you have the right tools.

Highlights from this video:
  • Downloading/opening the SSMS tools
  • Connecting to your SQL Server
  • Where is all of my SharePoint content located?
    • Information about the content databases
  • Detatching databases from the server
    • Suggestions for pre-detatchment
    • Why did my "Detatch Database" fail?
  • Adding databases to a new disk drive

and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: move, moving, database, sql, ssms, management studio, disk, drive,

posted by Scott Whigham @ 10:55 AM  

Friday, July 4, 2008

New SQL Server Video Tutorial: Backup and Recovery - An Introduct ion to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - view details
Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql backup, sql server backup types, sql server transaction log backup

posted by Scott Whigham @ 4:35 AM