Archiv für: "Juli 2008"

Grossbuchstaben eines Strings zurückgeben

Posted on Jul 29, 2008 von in SQL Server
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
dbo.Number N
WHERE
N.Number BETWEEN 1 AND LEN(@s) AND
ASCII(SUBSTRING(@s, N.Number, 1)) BETWEEN 65 AND 90
FOR XML PATH('')) AS x(OnlyInitials);

OnlyInitials
------------
UWHIDZT

(1 row(s) affected
Tags: ,

PHP Driver 1.0 for SQL Server 2005 released with source

Posted on Jul 29, 2008 von in SQL Server
http://blogs.technet.com/dataplatforminsider/archive/2008/07/28/php-driver-1-0-for-sql-server-2005-released-with-source.aspx
Tags:

tablediff

Posted on Jul 21, 2008 von in SQL Server
http://blogs.msdn.com/benjones/archive/2008/07/18/tablediff.aspx

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

Posted on Jul 21, 2008 von in SQL Server
http://blogs.msdn.com/sqlsecurity/archive/2008/07/12/microsoft-source-code-analyzer-for-sql-injection-july-2008-ctp.aspx

Microsoft Security Bulletin Summary for July 2008

Posted on Jul 9, 2008 by in SQL Server
http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx
Tags:

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

Posted on Jul 9, 2008 von in SQL Server
http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx

Performance Impact: Bookmark Lookup is Expensive - Even in Memory

Posted on Jul 7, 2008 von in SQL Server
http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx

SQL Injection

Posted on Jul 2, 2008 by in SQL Server
http://blogs.technet.com/andrew/archive/2008/07/01/sql-injection.aspx
Tags:
1 comment »