Entries tagged with sql server - TechNet Edge

Project Gemini in SQL Server 2008 R2 - Interaktive Analysen in Excel

Steffen Krause — Wed, 02 Sep 2009 14:51:00 GMT

[German Language] Das "Project Gemini" in SQL Server 2008 R2 ermöglicht für Excel-Benutzer echte Self Service Business Intelligence. Die Benutzer können direkt aus Excel Daten aus verschiedenen Quellen importieren, miteinander in Beziehung setzen und in interaktiven Pivottabellen und -charts auswerten. Und das auch mit sehr großen Datenmengen.
In diesem Video zeige ich die komplette Erstellung einer Gemini-Anwendung.
Mehr Informationen auf der SQL Server 2008 R2 Produktseite:

http://www.microsoft.com/sqlserver/2008/en/us/R2-SSBI.aspx

Gruß,
Steffen

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

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.

SQL Server Data Services

Andrew Fryer — Fri, 09 Jan 2009 16:20:00 GMT

SQL Server Data Services, Microsoft's Cloud database, is SQL but not as you nknow it. In order to get your head around it we have used an MVP who's an expert in the subject and some Lego Duplo!

How to Avoid Transaction Logs that Grow Out of Control

TechNet Magazine — Fri, 09 Jan 2009 03:37:00 GMT

In the February 2009 issue of TechNet Magazine, Paul Randal delves into logging and recovery in SQL Server.

In this accompanying video, Paul demonstrates the importance of managing your transaction log properly in the full recovery model, and he shows you techniques for doing so.

SQL Server Datenkomprimierung

Steffen Krause — 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

Steffen Krause — 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)

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.

Database Maintenance: Avoid and Monitor Fragmentation in Indexes

TechNet Magazine — 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

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.

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.

SQL Server Upgrade with Joe Yong

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

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.