Entries tagged with sql server - TechNet Edge

Real World DBA Episode 15 - SQL Server Features – Service Broker

Buck Woody — Fri, 06 Jun 2008 07:00:00 GMT

In the news, SQL Injection Attacks are on the rise. Learn what you can do to protect your data. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about the SQL Server Service Broker.

The web link is on scaling out Reporting Services, and the tip this week deals with choosing between Replication and Database Mirroring.

Real World DBA Episode 14 - SQL Server Features – Full Text Indexing

Buck Woody — Fri, 30 May 2008 07:00:00 GMT

In the news, The TechNet site has some new updates. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about Full Text Indexing. The web link is on Storage Performance and the tip this week deals with a place to find free tutorials on SQL Server.

Real World DBA Episode 13 – SQL Server Features –XML

Buck Woody — Fri, 23 May 2008 07:00:00 GMT

In the news, you could win a Windows Home Server, just for evaluating Microsoft products. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about SQL Server’s XML features. The web link is on Internationalization, and the tip this week deals with the Surface Area Configuration tool.

Real World DBA Episode 12 – SQL Server Features –SSIS

Buck Woody — Fri, 16 May 2008 07:00:00 GMT

In the news, Microsoft and Dell have teamed up to provide “out of the box” Business Intelligence systems.

In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about SQL Server Integration services.

The web link is on Replication with Oracle, and this week’s tip is on using Unicode data.

SQL and SMS/Configuration Manager

Joey Snow — Fri, 09 May 2008 07:01:00 GMT

At MMS last week I had just a few minutes with Greg Shields before he headed off to catch an airplane. We chatted briefly about his session where he shows how SQL Server can be used as a tool to help you with Systems Center Configuration Manager and SMS.

Real World DBA Episode 11 – SQL Server Features – Reporting Services

Buck Woody — Thu, 08 May 2008 16:29:00 GMT

In the news, Microsoft updates the “Script Center”, In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about Reporting Services. The web link is on scaling out with SQL Server 2005, and this week’s tip is on Database Tuning Advisor maintenance.

Episode 10 - SQL Server Features- Analysis Services

Buck Woody — Fri, 02 May 2008 07:00:00 GMT

In the news, Microsoft has announced that the Incremental Service Model will include Service Packs. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about Analysis Services. The web link is on Facebook and SQL Server, and this week’s tip is on Replication performance tuning.

Real World DBA Episode 9 – SQL Server Features – SQL Server Replication

Buck Woody — Fri, 25 Apr 2008 07:00:00 GMT

In the news, there’s a new way to read SQL Server Documentation.

In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about SQL Server Replication.

The web link shows you how Microsoft used Service Broker to put together MSDN

and this week’s tip is on SQL Server Services Accounts.

Episode-08 - SQL Server Features - Mirroring

Buck Woody — Fri, 18 Apr 2008 07:00:00 GMT

In the news, there’s a new Service Pack in the works for SQL Server 2005. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about Database Mirroring. The web link shows you how to set up peer-to-peer replication in SQL Server 2005 and this week’s tip is on Full Text Indexes.

Real World DBA Episode 7 – SQL Server Features - Clustering

Buck Woody — Tue, 15 Apr 2008 07:01:00 GMT

An update on SQL Server 2000 Support, Feature overview on Clustering, and securing SQL Server Accounts.

Real World DBA Episode 6 – Upgrading SQL Server

Buck Woody — Fri, 04 Apr 2008 18:12:00 GMT

In the news, Microsoft updates SQL Server Webcasts, in this week’s feature, we’ll cover the processes and procedures you need to follow for an upgrade.

The web link shows you where to find a graphic of the system tables in SQL Server 2005, and the tip of the week is on object dependencies.

Real World DBA Episode 5 – The DBA Checklist

Buck Woody — Fri, 28 Mar 2008 16:50:00 GMT

Win an Xbox, the DBA Checklist and where to find the latest sample databases and code.

Real World DBA Episode 3 – Does Join Order Matter

Buck Woody — Fri, 14 Mar 2008 21:36:00 GMT

This week the “Real World DBA” has the latest news on a new SQL Server product, and he’s joined by Joe Web to explore whether order matters in Join operations. The Web Links section shows you how to work with Service Broker, and this week’s tip helps you script your replication objects.

Real World DBA Episode 2 - Using the Right Identity

Buck Woody — Fri, 07 Mar 2008 19:24:00 GMT

This week Buck Woody has the latest news on SQL Server and a feature on and on choosing the right IDENTITY function. This week’s tip helps you deal with performance problems fast.