Entries tagged with database administration - TechNet Edge

LINQ and Entity Framework, for the DBA

Andrew Fryer — Mon, 18 May 2009 07:33:00 GMT

Two kinds of people are interersted in SQL Server, the DBA and the Developer. While Developers have been getting very interested in LINQ and Entity Framework and their support in SQL Server 2008 this is all a bit confusing for the DBA. Two UK evangelists Mike Taulty (the developer) and Andrew Fryer (the DBA) discuss these new developer tools and their significance for the DBA at the SQL Bits goes fourth conference

SQL Services - What does it mean for the DBA

Andrew Fryer — Thu, 07 May 2009 17:44:00 GMT

Simon Munro of EMC Consulting discusses the the new SQL Services platform with Microsoft evangelist Andrew Fryer at the highly popular SQL Bits goes fourth UK community event.

Real World DBA Episode 20 – Help! I’m a new DBA (part two)

Buck Woody — Sat, 28 Feb 2009 00:00:00 GMT

In the news, The SQL Server site has been redesigned.

In this week’s feature, I’ll give you the final part of a fast introduction to being a DBA. The web link is on RAID levels, and the tip this week is on replication.

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

Buck Woody — 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

Buck Woody — 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

Buck Woody — 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

Buck Woody — 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

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.

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

Buck Woody — 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

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.

Real World DBA Episode 1: SQL Server Editions

Buck Woody — 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.