SQLServer-Agent per Script einrichten

Posted on Jun 25, 2008 von in SQL Server
Welche Konfiguration ist überhaupt vorzunehmen? Es gibt einige Basisfunktionalitäten, die ich auf allen Servern aktiviert habe. Diese finden sich in den Eigenschaften des SQLServer-Agents, auf verschiedenen Seiten der Konfiguration wieder. mehr »

SQL Injection Attack

Posted on Jun 25, 2008 by in SQL Server
http://blogs.technet.com/swi/archive/2008/05/29/sql-injection-attack.aspx more »
Tags:

Cumulative update package 9 for SQL Server 2005 Service Pack 2

Posted on Jun 25, 2008 by in SQL Server
The Cumulative Update package 9 for SQL Server 2005 Service Pack 2 (Build 09.00.3257.00) is now available: http://support.microsoft.com/kb/953752/en-usAnd here you can get the whole information of builds that were released after SQL Server 2005 Service… more »

SQLRSS: an open source project for creating an RSS feed from database changes

Posted on Jun 24, 2008 by in SQL Server
http://blogs.msdn.com/bonniefe/archive/2008/06/23/sqlrss-an-open-source-project-for-creating-an-rss-feed-from-database-changes.aspx more »

SQL Server 2008 - The MERGE and TVP data access pattern with DataAdapters

Posted on Jun 19, 2008 by in SQL Server
http://sqlblogcasts.com/blogs/simons/archive/2008/06/18/SQL-Server-2008---The-MERGE-and-TVP-data-access-pattern-with-DataAdapters.aspx more »

Helpful Hint: Making Review of a Query Plan Easier

Posted on Jun 19, 2008 by in SQL Server
http://blogs.msdn.com/psssql/archive/2008/06/17/helpful-hint-making-review-of-a-query-plan-easier.aspx more »

Cumulative Update #8 for SQL Server 2005 Service Pack 2

Posted on Jun 17, 2008 von in SQL Server
http://blogs.msdn.com/sqlreleaseservices/archive/2008/06/16/cumulative-update-8-for-sql-server-2005-service-pack-2.aspx mehr »

Scaling Out SQL Server 2005

Posted on Jun 13, 2008 by in SQL Server
Kevin Cox from the Microsoft SQL Server Development Customer Advisory Team point it out, the SQL Server scale well. CU tosc more »
Tags: scaling

Einstieg in SQL - Verstehen, einsetzen, nachschlagen

Posted on Jun 12, 2008 von in Miscellaneous
Einstieg in SQL Verstehen, einsetzen, nachschlagen Marcus Throll, Oliver Bartosch 291 S., 2., aktualisierte und erweiterte Auflage 2007, mit CD und Referenzkarte 24,90 Euro ISBN 978-3-8362-1039-3 Structured Query Language, die strukturierte… mehr »

Paul S. Randal - Surviving Corruption: From Detection to Recovery

Posted on Jun 12, 2008 by in SQL Server
TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables by Paul S. Randal. http://www.sqlskills.com/blogs/paul/2008/06/12/TechEdDemoUsingTheSQL2005DedicatedAdminConnectionToFixMsg8992CorruptSystemTables.aspx CU… more »

Wide vs. Narrow Plans

Posted on Jun 12, 2008 by in SQL Server
http://blogs.msdn.com/bartd/archive/2006/07/27/wide-vs-narrow-plans.aspx more »
Tags: ,

SQLServer 2008 RC0 verfügbar

Posted on Jun 9, 2008 von in Vermischtes
Ab sofort ist SQLServer2008 für TechnetPlus-Abonnenten zum download verfügbar. mehr »

SQL Server 2008 RC0 now available for subscribers

Posted on Jun 9, 2008 by in SQL Server
http://blogs.technet.com/dataplatforminsider/archive/2008/06/07/sql-server-2008-rc0-now-available-for-subscribers.aspx more »

SQL Server 2008: Deprecated & Discontinued Features!

Posted on Jun 9, 2008 von in SQL Server
http://feeds.feedburner.com/~r/SqlteamcomWeblogs/~3/306228662/60618.aspx mehr »

Indexes in SQL Server 2005/2008 - Part 2 - Internals

Posted on Jun 9, 2008 von in SQL Server
http://www.sqlskills.com/blogs/kimberly/2008/06/08/IndexesInSQLServer20052008Part2Internals.aspx mehr »
Tags:

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on Jun 9, 2008 von in SQL Server
http://www.sqlskills.com/blogs/paul/2008/06/08/SearchEngineQA19MisconceptionsAroundIndexRebuildsAllocationBULKLOGGEDModeLocking.aspx mehr »
Tags: ,

SQL Server 2008 Release Candidate 0 (RC0) now available

Posted on Jun 9, 2008 by in SQL Server
First, the Microsoft branding team unveiled an official new logo for SQL Server 2008.   more »

SSIS-Pakete verteilen

Posted on Jun 7, 2008 von in SQL Server
Dieser Artikel soll erklären, welche einfache Möglichkeit es gibt, um Pakete zu verteilen, ohne die Konfiguration in den Paketen ändern zu müssen. Hier soll im speziellen auf besonders einfache Pakete eingegangen werden, die nur über Verbindungsmanager… mehr »

Building and Deploying Large Scale SQL Server Reporting Services

Posted on Jun 6, 2008 by in SQL Server
At SQLCAT there is a new technical note that introduce the Building and Deploying Large Scale SQL Server Reporting Services Environments, which provides general guidance on how to set up, implement, more »

Implicit Conversions

Posted on Jun 6, 2008 von in SQL Server
http://blogs.msdn.com/craigfr/archive/2008/06/05/implicit-conversions.aspx mehr »

SQL Server Automation Scripts

Posted on Jun 4, 2008 by in SQL Server
The Microsoft SQL Server Community introduces a new OPSDB Section (SQL Server Automation Scripts), with T-SQL Scripts for administration and analysing the entire SQL Server.You can visit OpsDB Section here. CU tosc more »
Tags: t-sql

How Microsoft IT Leverages SQL Server 2008 SSIS Dataflow Engine Enhancements

Posted on Jun 4, 2008 by in SQL Server
http://sqlcat.com/presentations/archive/2008/06/04/how-microsoft-it-leverages-sql-server-2008-ssis-dataflow-engine-enhancements.aspx CU tosc more »

PHP Driver for SQL Server 2005

Posted on Jun 4, 2008 by in SQL Server
There is a new SQL Server 2005 Driver for PHP Community Technology Preview, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.For more Information please read SQL Server 2005 Driver for PHP… more »
Tags: driver, php

Sync All Logins on a Server in a single click using SP_MSForEachDB

Posted on Jun 3, 2008 by in SQL Server
Ken Simmons, has published an interesting article about login sync, on SQL Server Central. Follow up: Sync All Logins on a Server in a single click using SP_MSForEachDB CU tosc more »
Tags: login