Entries tagged with dba - TechNet Edge

Real World DBA Episode 19 – Help! I’m a new DBA (part one)

BuckWoody — Fri, 05 Sep 2008 22:09:00 GMT

In the news, Microsoft has “Velocity”. In this week’s feature, I’ll give you the first part of a fast introduction to being a DBA. The web link is on 64-bit architectures and SQL Server, and the tip this week is on the features in SQL Server Express.

Real World DBA Episode 18 - Connecting to SQL Server

BuckWoody — Wed, 09 Jul 2008 07:00:00 GMT

In the news, the SQL Server 2008 Feature Pack for RC0 is now available. In this week’s feature, we’ll talk about accessing SQL Server. The web link is on deciding to use SQL Server or Microsoft Access, and the tip this week deals with data providers.

Real World DBA Episode 17 - SQL Server Features – Encryption

BuckWoody — Fri, 27 Jun 2008 07:00:00 GMT

In the news, CU 8 is now available for SQL Server 2005.

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

The web link is on the maximum capacities for SQL Server 2005,

and the tip this week deals with the file locations and registry entries for SQL Server 2005.

Real World DBA Episode 16 - SQL Server Features – Web Services

BuckWoody — Fri, 20 Jun 2008 07:00:00 GMT

In the news, the SQL Server 2008 Release Candidate is now available. In this week’s feature, we’ll continue the introduction to SQL Server Features and talk about SQL Server’s Web Services. The web link is on SQL Server Replication, and the tip this week deals with identifiers.

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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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.

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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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

BuckWoody — 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 4 - Prepping for Install

BuckWoody — Fri, 21 Mar 2008 14:24:00 GMT

This week the “Real World DBA” has the latest news updated community links for SQL Server. In this week’s feature, we'll colver the “big deal” about preparing for an installation, the web link shows you how to corrupt a database – on purpose, and the tip of the week is on upgrade options.

Real World DBA Episode 3 – Does Join Order Matter

BuckWoody — 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

BuckWoody — 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.

Real World DBA Episode 1: SQL Server Editions

BuckWoody — Fri, 29 Feb 2008 22:14:00 GMT

This week the Buck Woody – aka the “Real World DBA” - has the latest news on SQL Server 2008 Launch Events, and a feature on when to use each SQL Server Edition. In the Web Links section, Buck has a reference to SQL Server Best Practices, and this week’s tip helps you get to the root of performance problems fast.