Wednesday, June 14, 2006

New Microsoft SQL Server Video Tutorial: Templates in SQL Server Management Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - view details
Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.
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

posted by Scott Whigham @ 2:02 PM   0 comments  

New Microsoft SQL Server Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
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

posted by Scott Whigham @ 2:02 PM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size

How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size - view details
What would happen to your production database(s) right now if the transaction log was 100% full? Would the files automatically grow so that there would be more space available for data or would your users be shut-out until you manually added more space? What if it happened to your data file(s)? This video talks about various ways that you, the DBA, can be proactive in managing your disk files including increasing the data file size, suggestions on using autogrowth, how the files grow and disk space is allocated in SQL Server, 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

posted by Scott Whigham @ 2:01 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 2

Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 2 - view details
Part 2 in our series on SQL Server Netlibs
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

posted by Scott Whigham @ 9:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites

Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites - view details
The setup process for SQL Server 2005 is very involved, may take you over an hour (depending on features you choose and speed of media) and often features cryptic messages and stringent requirements. This video is designed to help you understand the initial setup including installing the Pre-Requisites (such as the .NET 2.0 Framework). You'll also receive a few suggestions and recommendations for ensuring a smooth setup experience.
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

posted by Scott Whigham @ 9:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Model Database - An Overview of How to Use It and When to Use It

Model Database - An Overview of How to Use It and When to Use It - view details
Scott Whigham, author of LearnSqlServer2005.com and LearnTransactSql.com, loves to use (and talk about using) the Model database. In this video, Scott walks you through what Model is, what the "possibilities" are for using Model, and gives you a few scenarios in which you can use the Model database to solve interesting problems. As a DBA or developer you'll certainly want to know your system databases. This video helps you understand perhaps the least used of all the system databases.
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

posted by Scott Whigham @ 9:06 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 6 - Using Aliases with TCP IP Connections

Part 6 - Using Aliases with TCP IP Connections - view details
In our final video on working with the SQL Server Network Libraries, you'll learn how to use client aliases to make your life much easier. Do you currently have to connect to your SQL Server using an IP address? If so, then you'll really get some mileage out of 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

posted by Scott Whigham @ 9:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs

Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs - view details
This video, the second in our series on using Common Table Expressions (CTEs), walks you through recursion and working with hierarchies with CTEs. This video uses the Northwind database to simplify the learning process and uses some common recursive queries used in Northwind examples to highlight the basic use of the CTE.
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

posted by Scott Whigham @ 8:59 AM   0 comments  

New Microsoft SQL Server Video Tutorial: OSQL - What It Is and How to Use It

OSQL - What It Is and How to Use It - view details
OSQL is to the DOS Prompt what Query Analyzer is to Windows; i.e., OSQL is your query writing tool for working in DOS. You can interactively write code and run SQL queries, updates and the like if you want but you can also tell it to execute a script file using the "-i" switch. This video, recorded by SQL guru Scott Whigham, shows you how to use OSQL in your organization to run batch files (.bat files that run SQL scripts) and 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

posted by Scott Whigham @ 8:59 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of Collation Types and Recommendations

Install SQL Server - Discussion of Collation Types and Recommendations - view details
When you install SQL Server, you make perhaps one of the most important decisions you can make: which default collation you will use. Should you choose Windows Locale or a SQL Collation (and what's the difference)? Are SQL Server Authentication passwords case-sensitive (and why are you asking me that here)? Collations are incredibly important to SQL Server and the collation that you choose during setup can save you hours of frustration later on. Watch this video and get an excellent overview of what collations are and how you should go about choosing the right collation for your installation
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

posted by Scott Whigham @ 8:33 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices

Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices - view details
What is the difference between a SQL Server Default and a Default constraint (or are they the same thing)? Should you use a Check constraint or a Rule (and are they the same thing)? SQL Server Defaults and Rules have been around forever in SQL Server but, if you don't know what they are, then 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

posted by Scott Whigham @ 8:28 AM   0 comments  

Tuesday, June 13, 2006

New Microsoft SQL Server Video Tutorial: Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 1

Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 1 - view details
Network Libraries in SQL Server are very important to SQL security. What you choose to enable or disable can have a profound impact on potential vulnerabilities. This video, Part 1, walks through the idea of Network Libraries and helps you choose the one(s) for your installation.
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

posted by Scott Whigham @ 1:33 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Pages, Extents, and Blocksizes - What They Are and How They Work

Pages, Extents, and Blocksizes - What They Are and How They Work - view details
If knowing the architecture of SQL Server is interesting to you, then you'll enjoy this video from Scott Whigham on how things like pages and indexes work in SQL Server. This is more of a theoretical discussion that discusses the sysinternals of SQL Server at a high level. The goal is to give you an understanding of how SQL Server stores data and indexes and how your index and table design decisions can influence SQL Server in multiple ways
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

posted by Scott Whigham @ 1:33 PM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Increase a Database's Size Using the SQL Server Enterprise Manager

How to Increase a Database's Size Using the SQL Server Enterprise Manager - view details
If you don't know the ALTER DATABASE commands for increasing your SQL Server file sizes (or don't want to use it), then this video is a great head-start to learning file manipulation and management for SQL Server 2000. Veteran SQL Server trainer Scott Whigham shows you a few of his tips and tricks for working with the Enterprise Manager as well.
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

posted by Scott Whigham @ 1:16 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Installing SQL Server 2000 - Basic Overview

Installing SQL Server 2000 - Basic Overview - view details
This video is a quick walk-through of the SQL Server install. It is aimed for those viewers wanting to see a quick install and then, after they have a good overview of how it works, want to delve deeper (by watching the other installation videos). Perfect for newbies and people migrating to SQL Server from other systems
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

posted by Scott Whigham @ 12:32 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY

Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY - view details
If your queries and stored procedures use @@IDENTITY (perhaps you have legacy code updated from SQL Server 7.0 or earlier), you'll likely get good value from watching this video on replacing @@IDENTITY calls with the T-SQL function SCOPE_IDENTITY(). This video shows very plainly the negative possiblities of using @@IDENTITY today (triggers are a real problem) and, after you watch this tutorial, you'll never want to use @@IDENTITY again!
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

posted by Scott Whigham @ 12:22 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - view details
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching
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

posted by Scott Whigham @ 12:13 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them

Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them - view details
There are far too many SQL functions to list here but what is important is what they are, what the difference is between them, and how you could/should use them. What's the difference between Niladic and Deterministic? Is GETDATE() Deterministic or Non-Deterministic? Is RAND() guaranteed to return a random number? Is NEWID() allowed as a parameter to other functions? If you haven't heard terms like Niladic or Deterministic before then you'll really appreciate this video. Also, SQL guru Scott Whigham gives an excellent breakdown of some common functions
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

posted by Scott Whigham @ 12:13 PM   0 comments  

New Microsoft SQL Server Video Tutorial: ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections

ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections - view details
The SQL Native Client, new with SQL Server 2005, is the preferred way to connect to a SQL Server 2005 instance today. This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
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

posted by Scott Whigham @ 12:11 PM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio

How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio - view details
Curiously enough, Microsoft decided against scripting out the indexes when you script out the table in the SQL Server 2005 Management Studio. This video shows you the default "behavior" of the Management Studio, how you can spot the "problem", and how you "fix" it. It's a strange decision by Microsoft to omit this (an accident, perhaps?) but don't get caught by this "undocumented feature"!
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

posted by Scott Whigham @ 12:08 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Result sets, Recordsets, and the Client Server model

Result sets, Recordsets, and the Client Server model - view details
This video is really helpful for you newbies - those of you who want to get up to speed on all the terms, jargon, parlance, and lexicon of SQL Server. Is a field the same as a column? An alias the same as a header? Is Result Set the same as resultset? The answer to all three questions is "Probably yes, depending on who's asking!" This video helps you dissect several (not all) of the confusing terms and tries to help you speak the language fluidly and easily. Is a recordset the same as a resultset? If you don't know, 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

posted by Scott Whigham @ 11:19 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager

Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager - view details
Quick - what is the default port number for SQL Server's TCP IP connections? Anyone who knows SQL Server knows the default port number and, if you were a hacker who wanted to attack a SQL Server, you would start with trying to go after a SQL Server using the default port number (which, by the way, is 1433). This video shows you how to identify the current port number that SQL Server is using and how to change it. This is an excellent video for configuring your SQL Server for secure connections.
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

posted by Scott Whigham @ 11:19 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them

Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them - view details
SET commands in T-SQL control the environment in which SQL Server or the client processes that client queries. This view shows you some of the more common SET commands, how they work, scoping (are they scoped to the statement, the batch, the connection?), and how you can use SET commands to increase throughput and help increase your SQL knowledge.
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

posted by Scott Whigham @ 11:18 AM   0 comments  

New Microsoft SQL Server Video Tutorial: EXCEPT and INTERSECT - An Introduction to Syntax and Concepts

EXCEPT and INTERSECT - An Introduction to Syntax and Concepts - view details
New in Transact-SQL for SQL Server 2005 are the EXCEPT and INTERSECT operators. These are not new SQL concepts; rather, these are just being added to SQL Server after being supported in other systems. Chances are that you've written your fair share of EXCEPT and INTERSECT-type queries but using a different syntax. NOTE: this video talks extensively about INNER and OUTER JOINs therefore a solid understanding of both is assumed.
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

posted by Scott Whigham @ 11:11 AM   0 comments  

New Microsoft SQL Server Video Tutorial: JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?

JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? - view details
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.
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

posted by Scott Whigham @ 11:11 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Upgrade The Documentation of SQL Server 2005 (Books Online)

How to Upgrade The Documentation of SQL Server 2005 (Books Online) - view details
Although the actual release for public sale of SQL Server 2005 in December of 2006, Microsoft felt compelled to release an update (a "refresh") of the documentation only a few weeks later. This video shows you how you can tell which version of Books Online (BOL) that you are running, how to update your BOL, and walks you through the process. It's actually a pretty hefty update too - over 115MB of "refreshed" documentation for a piece of software released for public sale only a few weeks earlier. You'll definitely want to upgrade your Books Online as soon as possible.
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

posted by Scott Whigham @ 11:11 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Multiple Instances - Lecture on When They're Appropriate and Special Considerations

Multiple Instances - Lecture on When They're Appropriate and Special Considerations - view details
You probably already know that SQL Server 2000 allows you to install multiple named instances but do you know the details? When should you use named instances? How could you use them? Scott Whigham, SQL trainer, gives you his takes on working with multiple instances in this video and includes some excellent examples of when to use named instances to save yourself development and testing time
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

posted by Scott Whigham @ 10:37 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - view details
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
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

posted by Scott Whigham @ 10:30 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services

Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services - view details
SQL Server 2005 introduces a few new services and a few new choices. This video talks about the services in SQL Server 2005 including the MSSQLServer, SqlServerAgent, SqlBrowser, and 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

posted by Scott Whigham @ 10:30 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - view details
AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer2005.com and LearnTransactSql.com, is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related.
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

posted by Scott Whigham @ 10:29 AM   0 comments  

New Microsoft SQL Server Video Tutorial: MSDB Database - An Overview of Some of the Common System Tables and Objects

MSDB Database - An Overview of Some of the Common System Tables and Objects - view details
The MSDB database is one of the heaviest-used system databases. It stores everything from DTS packages to Jobs (and the history of each). This video walks you through the common tables (what are those RTBl_% tables anyway?), the common stored procedures and gives you an excellent insight into how SQL Server works
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

posted by Scott Whigham @ 9:56 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Installing Service Pack 4 - Part 1

Installing Service Pack 4 - Part 1 - view details
This video walks you through the first part of installing Service Pack 4
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

posted by Scott Whigham @ 9:56 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 1

How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 1 - view details
This video series covers how to change the authentication modes (from Mixed Mode to Windows Authentication Mode and vice-versa) and shows you the differences between Service Pack levels (an RTM install of SQL Server, for example, and an SP4 install in this case)
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

posted by Scott Whigham @ 9:56 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - view details
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement in SQL Server
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

posted by Scott Whigham @ 9:55 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Cross Database Ownership Chaining - What It Is and When to Use It - Part 1

Cross Database Ownership Chaining - What It Is and When to Use It - Part 1 - view details
Cross Database Ownership Chaining was introduced as a settable database and server option in SQL Server 2000's Service Pack 3 yet most people do not even know what it is. SQL Server trainer Scott Whigham shows you all the details about Cross Database Ownership Chaining in this video and also shows you how installing Service Pack 3 completely changes how your SQL Server's security model works. Microsoft does not recommend setting Cross Database Ownership Chaining for your server but why not? If you want to know the answer then watch this series of videos
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

posted by Scott Whigham @ 9:55 AM   0 comments  

Sunday, June 11, 2006

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of File Placement and Suggestions for High Performance

Install SQL Server - Discussion of File Placement and Suggestions for High Performance - view details
Here's a general rule of thumb for most SQL Server installations: the more hard drives that you can put your SQL Server's database files on, the faster your performance. This video talks about file placement and gives you a solid understanding of why SQL Server works better this way. If you really want to know the fundamentals and the architecture of SQL Server, this is an excellent place to start
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

posted by Scott Whigham @ 7:51 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices

Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices - view details
During the installation of SQL Server 2000 you are asked which Network Libraries you would like to choose (if you choose the Custom installation). For each Network Library, you must choose the Network Address. Which are the most common network libraries used? What are the defaults? What about TCP/IP ports - which TCP port should you use for SQL Server? This video helps you make intelligent decisions that will protect your SQL Server from hackers, worms and viruses
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

posted by Scott Whigham @ 7:51 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Install Named Instance and View Files and Folders

Install Named Instance and View Files and Folders - view details
This video is a good introduction to installing a SQL Server named instance. It also includes a tour of the changes to the file system - the new files, the new folders, and a comparison between how a default instance works versus how a named instance works.
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

posted by Scott Whigham @ 7:51 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Update Your SQL Server Documentation Manually

How to Update Your SQL Server Documentation Manually - view details
At the same time that Service Pack 3 for SQL Server 2000 was released, Microsoft "refreshed" the Books Online documentation. How can you tell whether or not you're working with the latest copy? Where do you get it? Is it installed with Service Pack 3 (and what about SP4)? This video shows you the details of Microsoft's Update to Books Online and answers all these questions
  • Category: