Business Intelligence und Reporting mit Microsoft SQL Server 2005
Mai 12th
Das Buch bietet einen gut strukturierten Zugang in die vielfältige Welt der Business Intelligence (BI) und liefert einen kompetenten Überblick über die BI Funktionalitäten des SQL Server 2005. Dabei reicht die Bandbreite der behandelten Themen von OLAP… mehr »
SQL Server 2005 - Backup, Integrity Check and Index Optimization
May 9th
http://ola.hallengren.com more »
Did you track the growth of your database-backup?
May 7th
Frequently you'll want to know how fast your database-backup has been growing. Perhaps you have implement a SAN Backup-Device for Backup-to-disk, or you only want know how fast your database has been growing.This TSQL statement will query the… more »
Zeilenversionsverwaltung (Row Level Versioning)
Mai 7th
Ein Feature, welches mit SQL Server 2005 gekommen ist und meiner Meinung nach bisher nur wenig Beachtung gefunden hat, ist die Möglichkeit auf eine Zeile zuzugreifen, während jemand anders in einer Transaktion eine Änderung durchführt und diese noch… mehr »
Conversion and Arithmetic Errors: Change between SQL Server 2000 and 2005
May 7th
http://blogs.msdn.com/craigfr/archive/2008/05/06/conversion-and-arithmetic-errors-change-between-sql-server-2000-and-2005.aspx more »
Why you should upgrade to SQL Server 2008
May 7th
There is an interesting post by Buck Woody: http://blogs.msdn.com/buckwoody/archive/2008/05/06/why-you-should-upgrade-to-sql-server-2008.aspx
CU
tosc more »
Understanding the error message: “Login failed for user ''. The user is not associated with a trusted SQL Server connection.”
May 5th
http://blogs.msdn.com/sql_protocols/archive/2008/05/03/understanding-the-error-message-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection.aspx more »
Serverweite Berechtigungen und verwaiste Benutzer
Apr 30th
Ausgehend von der Fragestellung, einen Überblick über die Berechtigungen in den verschiedenen Datenbank eines Servers zu erstellen, fand ich die dahinter gelagerten Möglichkeiten auch recht reizvoll. Nachdem ich bereits vor einigen Wochen ein kleines S… mehr »
Steps to troubleshoot connectivity issues
Apr 30th
http://blogs.msdn.com/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues more »
SQLExamples: Common Solutions for T-SQL Problems
Apr 30th
There is a new great WIKI ressource for common T-SQL solutions at MSDN Code Gallery, it's called SQLExampels.In this WIKI presented information, represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers (you know Arnie Roland… more »
Conversion and Arithmetic Errors
Apr 29th
http://blogs.msdn.com/craigfr/archive/2008/04/28/conversion-and-arithmetic-errors.aspx more »
Pro T-SQL 2005 Programmer's Guide
Apr 24th
Das Buch bietet eine Menge interessanten Lesestoff für den fortgeschrittenen, ambitionierten T-SQL Entwickler. Es schliesst damit eine Lücke zwischen der Einsteigerlektüre und den allumfassenden Entwicklerbüchern auf der einen Seite und der sehr… mehr »
Tuning the Performance of Backup Compression in SQL Server 2008
Apr 24th
There is an interesting technical note by using the backup compression and its benefits in SQL-Server 2008 at SQLCAT.
Follow up: http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
CU… more »
Das Programmierhandbuch SQL Server 2005
Apr 23rd
Das vorliegende Buch bietet auf knapp über 1000 Seiten einen rundherum gelungenen Überblick über die Programmierung des SQL Servers 2005. Dabei beginnen die Autoren mit der Beschreibung der Installation, gefolgt von der Datenmodellierung und T-SQL… mehr »
How to cheat at Securing SQL Server 2005
Apr 22nd
Microsoft hat in den SQL Server 2005 zahlreiche neue Sicherheitsfeatures eingebaut, die einen leistungsfähigeren Datenbankserver möglich machen, in dem Sicherheitsrisiken minimiert sind. Diese Features finden sich sowohl in administrativen Tools als… mehr »
Microsoft SQL Server 2005 Service Pack 3!
Apr 22nd
UPDATE READ THIS: Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates
Microsoft SQL Server 2005 Service Pack 3 Beta now available
Last week, Francois Ajenstat announced on The Data Platform Insider that Microsoft will deliver SQL-Server 2005… more »
Storage Consideration for SQL Server 2005 DW environment
Apr 22nd
http://blogs.technet.com/vipulshah/archive/2008/04/21/storage-consideration-for-sql-server-2005-dw-environment.aspx mehr »
How It Works: What is a Sleeping / Awaiting Command Session
Apr 22nd
http://blogs.msdn.com/psssql/archive/2008/04/21/how-it-works-what-is-a-sleeping-awaiting-command-session.aspx mehr »
Great New Resource for SQL Server 2008 Books Online Information
Apr 21st
The SQL User Edutcation Team have created a new scoped Search macro on Windows Live search.It helps you to narrow your search to just the SQL Server 2008 Books Online documentation(BOL) and eliminate extranneous results from other sources, like the SQL… more »
SQL-Server 2008 Books Online auf Windows Live
Apr 21st
Analog zur SQL-Server 2005 Books Online Scoped Search hat das SQL User Education Team eine search engine entwickelt, die nur Ergebnisse der SQL Server 2008 Onlinedokumentation liefert (BOL).
SQL Server 2008 Books Online Scoped Search mehr »
Orphan SQL-Server accounts
Apr 18th
By using SP_MSForEachDB you can detect and display orphan SQL-Server accounts from all the databases of your SQL-Server.
EXEC SP_MSForEachDB 'USE [?];
-- SYSTEM DATABASE ARE EXCLUDED
IF DB_ID(''?'') > 4
SELECT ''?'' as DBName,
name AS… more »
SQL Server Management Studio Standard Reports
Apr 18th
Buck Woody has completed his full list of SQL Server Management Studio Standard Reports. You can get to them from the tag Standard Reports , but he has also posted a list of them all with the links.Follow up this link:… more »
SQL Server Policy-Based Management - PMB
Apr 10th
There is a new blog maintained by the entire team of SQLPMB. This blog is dedicated to Policy-Based Management introduced in SQL Server 2008.
http://blogs.msdn.com/sqlpbm/default.aspx
CU
tosc more »
Determine the last change of the sa password?
Apr 4th
Let us face it, when did you last change the sa password?
You can check last change in SQL Server 2005, for the sa login by using LOGINPROPERTY function.
Execute the following T-SQL code: more »
Which service pack do I have installed?
Apr 3rd
Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level.By selecting @@VERSION in a query window ...SELECT @@VERSION AS "SQL Server Version"you / I get following result: more »