Sunday, July 16, 2006

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

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
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 @ 5:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT

Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT - view details
SQL Server 20005 introduces the PIVOT operator to Transact-SQL for creating crosstab queries in a much simpler way. If you're used to working with cross tab queries and pivot tables and are tired of having to hard code the options in your CASE operator(s), then check out this excellent video on the PIVOT operator and how to use it.
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 @ 5:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager)

Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager) - view details
One of the most common SQL Server topics is how to shrink a database file. It seems strange - we seem to be in a time where people are wanting larger databases yet everyone wants to know how to shrink. This video, recorded by SQL guru Scott Whigham, puts an interesting spin on the standard "How to Shrink" instructions. You'll not only learn how to shrink but Scott gives several best practices and tips and tricks for shrinking including a few "Don't do this"-type of tips!
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 @ 5:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Using Aliases and the Client Network Utility

Using Aliases and the Client Network Utility - view details
Scott Whigham, our resident SQL Guru, says that creating aliases for his SQL Servers is one of his favorite "little things" to do on his servers. It isn't a big thing - aliases are very simple actually - but they sure does make life easier. This video shows you how you can create aliases, what the benefits of aliases are, and when you would likely use them. A great video for all skill levels
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 @ 5:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Schemas, Objects, and Ownership in SQL Server 2000

Schemas, Objects, and Ownership in SQL Server 2000 - view details
Schemas in SQL Server 2000 are completely different from schemas in XML, Oracle and even SQL Server 2005. You could argue that the word schema is the most re-defined word in all of the SQL world but you'd probably find that the SET keyword is at least as re-defined if not more. Anyway, this video is all about security and you need to know what schemas and users are in SQL Server 2000 (especially if you plan on moving forward to SQL Server 2005 at some point). The main concept to take away from this video is object ownership and how to change it. It's sort of hidden in the tools/language but is a very important task for all SQL DBAs
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 @ 5:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins

SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins - view details
The most basic security in SQL Server starts with SIDs - security Identifiers. If you know someone's SID, then you can track them all through your SQL Server instance, for example. This video explains a little about the architecture of SQL Server by showing you the master database's sysxlogins table and how you manage and work with SQL Server Authentication logins. If SQL Server security is your job or you're an aspiring DBA, this is pretty much a must-watch 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 @ 5:08 AM   0 comments  

Thursday, July 13, 2006

New Microsoft SQL Server Video Tutorial: Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)

Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) - view details
Linked servers can really help you get "out of a jam" with SQL. If you'd like to be able towrite SQL queries against Microsoft Access and JOIN the data to a SQL Server table, for example, then you'll love the flexibility that linked servers offer you. This video is just an overview of how linked servers work and how you can use them in your queries to simplify your life.
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:03 PM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - view details
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services 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 @ 12:03 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 6 - Verifying Our Installation and Reviewing The Install Logs

Part 6 - Verifying Our Installation and Reviewing The Install Logs - view details
This is, as the title implies, Part 6 in our 7-part series on installing SQL Server 2005 for the first time. In this video, SQL guru Scott Whigham has finished the installation and shows you the logs that SQL Server uses to track the installation along with several of the changes that have now occurred on your system.
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:02 PM   0 comments  

New Microsoft SQL Server Video Tutorial: When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause

When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause - view details
The traditional areas of difficulty for SQL developers are aggregates, JOINs, and subqueries. Most people have no trouble understanding when to use COUNT instead of SUM but they get "stuck" when it comes to determining how to filter the data. Suppose you are asked to find all orders in 2006 in which customers ordered more than 5 items - how would you solve this query? Obviously you need two filters: for the date (2006) and for orders with more than 5 items. People have difficulty with this type of query however; most peolpe would approach this query along these lines: "SELECT ... FROM Orders JOIN OrderDetails ... WHERE Year(DateOrdered)=2006 AND COUNT(*) > 5". Focus on the WHERE clause for a moment: is that right? If you aren't sure or if you think it is right, then you need to watch this video to understanding why this query must use the HAVING clause.
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 @ 5:01 AM   0 comments  

New Microsoft SQL Server Video Tutorial: TOP Operator: What's New and Why Life Is much Easier Today

TOP Operator: What's New and Why Life Is much Easier Today - view details
The TOP operator has been greatly enhanced over SQL Server 2000's implementation of TOP by adding support for parameterization and the ability to use TOP in all DML statements (instead of just the SELECT). Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through using the new features of TOP and how it differs from previous versions.
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 @ 5:01 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Query Governor Bug

SQL Server 2005 Query Governor Bug - view details
SQL Server 2005 Query Governor Bug - Oops…
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 @ 5:01 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Peculiarities of the Database Role ddl_admin

Peculiarities of the Database Role ddl_admin - view details
Chances are that you've never either experienced any significant "weirdness" with the fixed database role "ddl_admin" but it does have a few little peculiarities. In this video, Scott Whigham shows you how the ddl_admin works, whether you should use it or not, and some Best Practices for assigning your users membership into ddl_admin
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 @ 5:01 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 2000 Instance

Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 2000 Instance - view details
Running the Upgrade Advisor is easy enough but understanding the reports requires a little more knowledge and experience. This video walks you through running the SQL Server 2005 Upgrade Advisor and finished with a detailed walk through of the generated reports including what you can safely ignore and what will cause problems after you upgrade.
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 @ 5:01 AM   0 comments  

Wednesday, July 12, 2006

New Microsoft SQL Server Video Tutorial: Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages

Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages - view details
Right now, on your SQL Server, are stored procedures that certain people could execute that would blue screen (BSOD) your SQL Server's host machine. Seriously. Well, that's part of the story at least. Yes, it's true - xp_cmdshell and sp_OACreate could blue screen your machine but you'd have to be a sysadmin (by default) to execute them. In this video, you'll learn about several dangerous stored procedures and how to neutralize their impact on your system. If security is of utmost importance to you and your team, then this video on SQL Server security and stored procedures is well worth watching
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:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets

Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets - view details
The opposite of the PIVOT operator is UNPIVOT. Since PIVOT creates cross tab queries (or "pivots" the data across the vertical and horizontal axis by turning row values into columns), UNPIVOT can take a crosstab query's resultset and normalize the results by turning the column data into rows. Make sense? If not, you need to 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:11 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server's Services - MSSQLSERVER, SQLAGENT, MSDTC and more

SQL Server's Services - MSSQLSERVER, SQLAGENT, MSDTC and more - view details
More and more we need to know the internals of the heavy software - the architecture of the beast, if you will. This video's goal is to teach you the services that SQL Server uses - the SQL Server service (MSSQLServer for the default instance and MSSQL$InstanceName for other instances), the SQL Agent service, and the ancillary services like Full-Text's Microsoft Search Service and the MSDTC - the Microsoft Distributed Transaction Coordinator Service. This video provides an excellent overview of how SQL Server works within the operating system and how the services work with each other
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: Setting Database Options Using the Enterprise Manager - Setting the Database State Options

Setting Database Options Using the Enterprise Manager - Setting the Database State Options - view details
This is one of those "Oh okay, I didn't know exactly what that did" type of videos. SQL Server MCDBA Scott Whigham walks you through the settable database options that you find in the Enterprise Manager and presents the information in any easy-to-follow format that anyone can understand.
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: Part 2 - Installing the SQL Server Upgrade Advisor from the CD and Upgrading From the Web

Part 2 - Installing the SQL Server Upgrade Advisor from the CD and Upgrading From the Web - view details
The SQL Server Upgrade Advisor should be updated prior to use on a production server and, in this video, Scott Whigham (author of LearnSqlServer.com) shows you how to upgrade the Upgrade Advisor and how to run it for your upgrade.
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  

Monday, July 10, 2006

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error

SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error - view details
What do you do when your transaction log is full - how do you fix it? This video walks about just that as well as highlights some gotchas along the way. This video talks architecture as well as providing practical examples or truncating the log and backing up the log as options.
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 @ 4:47 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Query Analyzer - Beyond the Basics (SQL Server 2000)

Query Analyzer - Beyond the Basics (SQL Server 2000) - view details
For those of you who want to go beyond the basics of hitting F5 to execute your query (CTRL+E works as well), this video walks you through some of Scott Whigham's favorite "tweaks" to the SQL Server 2000 Query Analyzer. Scott Whigham is the author of LearnSqlServer.com, LearnDTS.com and LearnTransactSql.com and has many, many years customizing and optimizing SQL Server including the tools. This video will really give you some good ideas for using the Query Analyzer and will help you speed up your day-to-day tasks.
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:48 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 7 - A Look at the Installed Folders

Part 7 - A Look at the Installed Folders - view details
In our final video on installing SQL Server 2005 for the first time we take a look at what folders are installed. What does MSSQL.1 mean? What is MSSQL.2? How does SQL Server choose what goes in which folders? Learn about it here.
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:48 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports

Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports - view details
Another in our series on SQL Server 2005's Network Libraries, this video shows you a rather obscure and not-often-used technique of configuring your SQL Server to listen on multiple TCP/IP ports. TCP/IP is the most common way to connect to SQL Servers (including 7.0 and 2000) so the more you know, the better you are!
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:48 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 3 - Understanding the SQL Server Configuration Manager's Display of TCP IP Properties

Part 3 - Understanding the SQL Server Configuration Manager's Display of TCP IP Properties - view details
The SQL Server Configuration Manager is a handy tool but perhaps it isn't the easiest tool to understand when you want to change/modify/view your server's TCP/IP settings. In this video, SQL Server consultant Scott Whigham walks you through each screen in the Configuration Manager and explains the meaning of some of the (cryptic) menu items and gives examples of how the settings affect your 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 @ 12:47 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them

Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them - view details
Common Table Expressions (CTEs) are an interesting addition to SQL Server 2005's Transact-SQL language. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the basics of what CTEs are, the syntax and concepts of using CTE and gives you a few examples in this video. This video is part 1 in our series on CTEs and is designed to be an introduction to the syntax and the concepts of using CTEs.
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:47 PM   0 comments  

Friday, July 07, 2006

New Microsoft SQL Server Video Tutorial: Part 4 - Choosing the Right SQL Server Authentication Mode

Part 4 - Choosing the Right SQL Server Authentication Mode - view details
Our fourth video in this series on installing SQL Server 2005, this video focuses on SQL Server 2005 security with a discussion of the Authentication modes. Included in this video are discussions on SQL Server Best Practices for Security, the differences between Windows Authentication Mode and Mixed Mode (which allows SQL Server login authentication) 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 @ 1:51 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 5 - Collations and How to Choose the Most Compatible Collation

Part 5 - Collations and How to Choose the Most Compatible Collation - view details
Collations, sort orders, code pages, character sets - whew! Most people, including even some advanced administrators, have a difficult time understanding what collations are and how to effectively use collations. This video walks you through what they are, how they work, and how you use them. You'll also learn why this screen of the setup is perhaps the most important - it's the only choice you'll make during the SQL Server 2005 setup process that cannot be changed later on!
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:51 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers

Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers - view details
Continuing our series on the AdventureWorks database, Scott Whigham walks you through how to create database diagrams using AdventureWorks as well as using the DDL triggers for database-level events. A very interesting video with some exciting new SQL Server 2005 features.
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:51 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 7.0 Instance

Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 7.0 Instance - view details
For those of you wanting to upgrade your SQL Server 7.0 to SQL Server 2005, you'll want to run the SQL Server 2005 Upgrade Advisor against your SQL Server 7.0 instance before running the upgrade. This video walks you through running the Upgrade Advisor and provides insights into the meanings of the Upgrade Advisor reports including what is important and what you can safely ignore.
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:51 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of Whether Sharing SQL Server with IIS and Other Applications is Recommended

Install SQL Server - Discussion of Whether Sharing SQL Server with IIS and Other Applications is Recommended - view details
Veteran SQL trainer Scott Whigham talks to you about how to put your SQL Server on the web without unnecessarily exposing it directly to potential hackers, all wrapped in a discussion about whether you should install SQL Server on the web server or another server in your organization. This video also talks about how dynamic data pages, such as ASP, ASP.NET, and JSP, work with respect to 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 @ 1:51 PM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005

Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005 - view details
Part 2 in our series on What's New in SQL Server 2005's Toolbox, Scott Whigham walks you through a few more important tools and changes in SQL Server 2005.
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:41 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes

Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes - view details
When you install SQL Server 2005, remote connections are disabled. This can cause confusion for newbies trying to install and work with SQL Server for the first time. This video shows you the secure-by-default design and how to configure your SQL Server for remote connections and TCP IP.
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:41 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Part 2 - Choosing the Right Installation For Your Organization

Part 2 - Choosing the Right Installation For Your Organization - view details
Scott Whigham continues the series on installing SQL Server 2005 with this video on the setup choices.
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:41 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
Most SQL Server administrators and developers do not take full advantage of the model database, whether because they don't need to or don't know how. This video walks you through how SQL Server uses the model database (the architecture of SQL Server's CREATE DATABASE) and gives you suggestions for how you can use the model database to trap errors, perform audits, 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 @ 11:41 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

How SQL Server Logs Errors - The SQL Server Error Log and Configuration - view details
The SQL Server Error Log Viewer in SQL Server 2000 leaves quite a bit to be desired. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.
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:41 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Change the SQL Server TCP IP Port Number Using the Server Network Utility

How to Change the SQL Server TCP IP Port Number Using the Server Network Utility - view details
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance &$45; do you know? So does everyone else! One of the first things that a DBA does (if he/she wants to setup a secure SQL Server) if to change the default SQL Server port number from 1433 to something else. This video shows you the how, the how it works, and also gives recommendations for network libraries and more. This should be considered required viewing for all SQL Server DBAs
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:24 AM   0 comments  

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

Master Database - An Overview of Some of the Common System Tables and Objects - view details
Veteran SQL trainer Scott Whigham shows you the details of the master database including a tour of the common tables (such as sysxlogins and sysconfigures), the system views (like syslogins) and the virtual tables that give performance information. You'll also learn about the system stored procedures (like sp_help, sp_helpdb and others) and much more. A must-watch-video for anyone wanting to know the sysinternals of SQL Server 2000
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:08 AM   0 comments  

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

Pages, Extents, and Blocksizes - What They Are and How They Work (SQL Server 2000) - view details
Another in our series on the internals of SQL Server, this video focuses on data storage, particularly data pages and how SQL Server stores the data on pages. All SQL Server developers and administrators should know the page size, what an "extent" is, what types of pages there are, and the basics of the internal storage engine and this video helps you learn the fundamentals.
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:08 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands

Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands - view details
There are lots and lots of DBCC commands related to performance tuning but did you know that several SET commands can help you out with your query tuning? This video, recorded by SQL consultant Scott Whigham, teaches you several of the most commonly used DBCC and SET commands for performance tuning and provides some tips and tricks for their use. Note: you'll want to likely have a solid foundation in query writing before viewing this video. An understanding of execution plans would also be helpful.
To download this video,