Entries tagged with sql server - TechNet Edge

SQL Server Datenkomprimierung

steffenk — Tue, 30 Sep 2008 09:48:00 GMT

Dieser Screencast zeigt das neue Feature Datenkomprimierung in SQL Server 2008

Interview mit Jürgen Thomas zu SQL Server und SAP

steffenk — Fri, 26 Sep 2008 11:30:00 GMT

Heute endlich mal ein Interview in deutscher Sprache. Das bedeutet, ich muss es weder übersetzen noch aufschreiben.

Jürgen Thomas ist in der SQL Server Produktgruppe für die Zusammenarbeit mit SAP zuständig. Darum geht es in diesem Interview natürlich um SAP und um Features, die für SAP wichtig sind wie Datenkomprimierung, DMVs und Storage-Konfiguration

Gruß,
Steffen

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.

Database Maintenance: Avoid and Monitor Fragmentation in Indexes

TechNetMagazine — Wed, 25 Jun 2008 20:17:00 GMT

In the August 2008 issue of TechNet Magazine, Paul S. Randal gives an overview of Top Tips For Effective Database Maintenance. In this accompanying video, Paul demonstrates the need to monitor fragmentation and how shrink (and autoshrink) can cause serious problems.

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.

SQL and SMS/Configuration Manager

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

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.

SQL Server Upgrade with Joe Yong

Joey — Mon, 07 Apr 2008 16:33:00 GMT

One of the biggest challenges when a new product is released is upgrades. I had a chance to sit down with SQL upgrade guru Joe Yong from Scalability Experts. We chat about upgrading from SQL Server 2000 and SQL Server 2005 to SQL Server 2008. Joe explains the differences in the Upgrade tools in SQL Server 2008 as well as providing us some guidance in setting up lab environments for upgrade testing. Visit Joe's blog at http://blog.scalabilityexperts.com/.

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.

SQL Server 2008 Policy Based Management Interview

Joey — Tue, 25 Mar 2008 09:30:00 GMT

One of the cool new features in SQL Server 2008 is the ability to manage your servers via policy, using policy based management. I had a chance to sit down with Dan Jones Senior Program Manager on the SQL team and discuss the history behind SQL's management, what policy based management is, and how policy based management will help DBA's and IT Pro's manage their SQL servers more effectively.

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.