Archiv für: "Juli 2008"

Grossbuchstaben eines Strings zurückgeben

Zugegeben nicht gerade etwas, das man jeden Tag braucht, aber falls doch... DECLARE @s varchar(100); SELECT @s = 'Und Was Habe Ich Damit Zu Tun?'; SELECT x.OnlyInitials FROM (SELECT SUBSTRING(@s, N.Number, 1) FROM… mehr »

PHP Driver 1.0 for SQL Server 2005 released with source

http://blogs.technet.com/dataplatforminsider/archive/2008/07/28/php-driver-1-0-for-sql-server-2005-released-with-source.aspx mehr »

Microsoft Visual Studio Team System 2008 Database Edition GDR July CTP Released

Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP is available for download.Download it here: http://www.microsoft.com/downloads/deta ... laylang=en CU tosc more »

tablediff

http://blogs.msdn.com/benjones/archive/2008/07/18/tablediff.aspx mehr »

Microsoft ® Source Code Analyzer for SQL Injection – July 2008 CTP

http://blogs.msdn.com/sqlsecurity/archive/2008/07/12/microsoft-source-code-analyzer-for-sql-injection-july-2008-ctp.aspx mehr »

Free "Basic Training" for SQL Server

Scaling Up Reporting Services 2008 vs. Reporting Services 2005

Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory

SQL Server 2008 Beta Exams

The Microsoft certifications blog for developer & SQL Server technologies, makes an Open Inventation for SQL Server 2008 DBA 71-432 and SQL Server 2008 BI 71-448, only through the end of July.Link:… more »

Microsoft Security Bulletin Summary for July 2008

http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx more »

SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx mehr »

T-SQL Programmability Features in SQL Server 2008

Itzik Ben-Gan starts with a Whitepaper for SQL Server 2008 - An Introduction to New T-SQL Programmability Features in SQL Server 2008.Link: http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx A must read! CU tosc more »

Performance Impact: Bookmark Lookup is Expensive - Even in Memory

http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx mehr »

SQL Injection

http://blogs.technet.com/andrew/archive/2008/07/01/sql-injection.aspx more »

Jobs on production instances

A wonderful handout for SQL Server Jobs by Tara Kizer. CU tosc more »