Category: "SQL Server"

MSDN and TechNet SQL Server Sites Linked

Cheers! CU tosc more »

RML Utilities for Microsoft SQL Server Released

The Microsoft PSS SQL Support Team, give us a set of useful tools that could change/help our life. Check out the RML Utilities here: RML Utilities for Microsoft SQL Server To download the RML Utilities for SQL Server, visit the following Microsoft… more »

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition Andreas Kosch 2006 entwickler.press 212 Seiten 19,90 Euro ISBN 3-935042-85-X SQL Server 2005 Express Edition – ein Taschenbuch, das deutsche Entwickler-Einstiegswerk zum kleinsten der SQL Server 2005 Familie. Der Autor –… mehr »

Great New Resource for SQL Server 2005 Books Online Information

The Microsoft SQL Server Team and the SQL User Edutcation Team has been working hard to get better,more and good information out to there users. They have created a new a customized Windows Live search, that limits results to SQL Server… more »

Microsoft SQL Server 2005 Service Pack 2a ?

UPDATE READ THIS: Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates Microsoft SQL Server 2005 Service Pack 3 Beta now available Cumulative update package 10 for SQL Server 2005 Service Pack 2 Microsoft SQL Server 2005 Service Pack… more »

SQL Server Hosting Toolkit

Microsoft Download Center published Microsoft SQL Server Database Publishing Wizard 1.1 (for hosting costumers) and Microsoft SQL Server Database Publishing Services 1.0 (for hosters). This toolkit was posted by the SQL Server team on SQL Server Hosting… more »

Listing all databases backup

Are you sure, that you make your db backups? CREATE VIEW ViewLastBackup AS SELECT a.name AS 'DataBase', Backup_Date, Days_since_last_Backup FROM master.dbo.sysdatabases AS a LEFT JOIN (SELECT database_name,MAX(backup_finish_date) AS Backup_Date,… more »

Listing a specified field in a database

Sometimes you know the field name, but forget about in which table it is. This small procedure will help you ;). USE AdventureWorks --- the database must be specified GO CREATE PROCEDURE procAllTableswithField(@columnname nvarchar(400)='%') AS… more »

Performance data: SQL 2000 versus SQL 2005

At Microsoft Office Assistance a new content has been added comparing the performance data about SQL 2000 versus SQL 2005 with SharePoint Portal Server: Appendix: SQL Server Performance Test Results... with some interesting results! Farm size SQL… more »

E-Learning rund um SQL Server 2005 und Visual Studio 2005

Bis Ende März sind auf Microsoft–Trainings für Entwickler kostenlose E-Learning-Kurse nutzbar. SQL-Server: Kurs 2939: Programmieren von Microsoft® SQL Server™ 2005 Kurs 2940: Erstellen von Diensten und Benachrichtigungen mithilfe von Microsoft® SQL… mehr »