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 »

Installing Clustered SQL Servers - Outline, Checklists, Document Sheets

http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx mehr »

Subqueries in BETWEEN and CASE Statements

http://blogs.msdn.com/craigfr/archive/2008/06/27/subqueries-in-between-and-case-statements.aspx mehr »

Differences between ISNULL and COALESCE

http://blogs.msdn.com/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx more »

BgInfo, WMI and SQL Server

BgInfo from Sysinternals (now Windows Sysinternals, by Mark Russinovich) automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more interesting… more »

Report Server Catalog Best Practices

This technical note is part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series which provides general guidance on how to set up, implement, and optimize an enterprise scale-out architecture for your… more »

Working On SQL Admin Hacks, Tips and Tricks

http://feeds.feedburner.com/~r/SqlServerCodetipsAndTricksPerformanceTuning/~3/320706728/working-on-sql-admin-hacks-tips-and.html more »

SQLServer-Agent per Script einrichten

Welche Konfiguration ist überhaupt vorzunehmen? Es gibt einige Basisfunktionalitäten, die ich auf allen Servern aktiviert habe. Diese finden sich in den Eigenschaften des SQLServer-Agents, auf verschiedenen Seiten der Konfiguration wieder. mehr »

SQL Injection Attack

http://blogs.technet.com/swi/archive/2008/05/29/sql-injection-attack.aspx more »

Cumulative update package 9 for SQL Server 2005 Service Pack 2

The Cumulative Update package 9 for SQL Server 2005 Service Pack 2 (Build 09.00.3257.00) is now available: http://support.microsoft.com/kb/953752/en-usAnd here you can get the whole information of builds that were released after SQL Server 2005 Service… more »

SQLRSS: an open source project for creating an RSS feed from database changes

http://blogs.msdn.com/bonniefe/archive/2008/06/23/sqlrss-an-open-source-project-for-creating-an-rss-feed-from-database-changes.aspx more »

SQL Server 2008 - The MERGE and TVP data access pattern with DataAdapters

http://sqlblogcasts.com/blogs/simons/archive/2008/06/18/SQL-Server-2008---The-MERGE-and-TVP-data-access-pattern-with-DataAdapters.aspx more »

Helpful Hint: Making Review of a Query Plan Easier

http://blogs.msdn.com/psssql/archive/2008/06/17/helpful-hint-making-review-of-a-query-plan-easier.aspx more »

Cumulative Update #8 for SQL Server 2005 Service Pack 2

http://blogs.msdn.com/sqlreleaseservices/archive/2008/06/16/cumulative-update-8-for-sql-server-2005-service-pack-2.aspx mehr »

Scaling Out SQL Server 2005

Kevin Cox from the Microsoft SQL Server Development Customer Advisory Team point it out, the SQL Server scale well. CU tosc more »

Einstieg in SQL - Verstehen, einsetzen, nachschlagen

Einstieg in SQL Verstehen, einsetzen, nachschlagen Marcus Throll, Oliver Bartosch 291 S., 2., aktualisierte und erweiterte Auflage 2007, mit CD und Referenzkarte 24,90 Euro ISBN 978-3-8362-1039-3 Structured Query Language, die strukturierte… mehr »

Einstieg in SQL - Verstehen, einsetzen, nachschlagen

Paul S. Randal - Surviving Corruption: From Detection to Recovery

TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables by Paul S. Randal. http://www.sqlskills.com/blogs/paul/2008/06/12/TechEdDemoUsingTheSQL2005DedicatedAdminConnectionToFixMsg8992CorruptSystemTables.aspx CU… more »

Wide vs. Narrow Plans

http://blogs.msdn.com/bartd/archive/2006/07/27/wide-vs-narrow-plans.aspx more »

SQLServer 2008 RC0 verfügbar

Ab sofort ist SQLServer2008 für TechnetPlus-Abonnenten zum download verfügbar. mehr »

SQL Server 2008 RC0 now available for subscribers

http://blogs.technet.com/dataplatforminsider/archive/2008/06/07/sql-server-2008-rc0-now-available-for-subscribers.aspx more »

SQL Server 2008: Deprecated & Discontinued Features!

http://feeds.feedburner.com/~r/SqlteamcomWeblogs/~3/306228662/60618.aspx mehr »