TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database

http://www.sqlskills.com/blogs/paul/2008/08/29/TechEdDemoCreatingDetachingReattachingAndFixingASuspectDatabase.aspx mehr »

Plan Reuse abfragen

DECLARE @string varchar(500) SELECT @string = '%SomeString%' SELECT SCP.usecounts, SCP.cacheobjtype, SCP.objtype, [Statement].text, Executionplan.query_plan FROM sys.dm_exec_cached_plans SCP OUTER APPLY… mehr »

Where the Heck is DMO?

http://blogs.msdn.com/dtjones/archive/2008/08/28/where-the-heck-is-dmo.aspx mehr »

Should Microsoft provide a transaction log reader tool?

http://www.sqlskills.com/blogs/paul/2008/08/26/ShouldMicrosoftProvideATransactionLogReaderTool.aspx mehr »

High-performance FILESTREAM tips and tricks

http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx mehr »

Can GUID cluster keys cause non-clustered index fragmentation?

http://www.sqlskills.com/blogs/paul/2008/08/20/CanGUIDClusterKeysCauseNonclusteredIndexFragmentation.aspx mehr »

How to tell if you have instant initialization enabled?

http://www.sqlskills.com/blogs/paul/2008/08/11/HowToTellIfYouHaveInstantInitializationEnabled.aspx mehr »

Why Single-Column Primary/Foreign Keys Can't Always Accurately Model/Constrain Your Data

http://weblogs.sqlteam.com/jeffs/archive/2008/08/13/examining-database-primary-keys.aspx more »

Virtual Lab: What's New in SQL Server 2008 for Database Administrators

Free on-line lab to started quickly:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358030&EventCategory=3&culture=en-US&CountryCode=US CU tosc more »

Webcast: Upgrade and Migration to SQL Server 2008

Learn to install and upgrade to SQL Server 2008, check out this free webcast:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US CU tosc more »

SQL Server 2008 is RTM, YES!

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Aug 9 2008 10:01:31 The download ISOs are available from MSDN Subscriber Downloads and/or TechNet Subscriber Downloads, I didn't know when it will be available for non-MSDN/TechNet… more »

SQLServer 2008 RTM verfügbar

Ab sofort ist SQL Server 2008 RTM für TechnetPlus- /MSDN-Abonnenten zum download verfügbar. Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Aug 7 2008 10:01:31 mehr »

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 »