T-SQL Programmability Features in SQL Server 2008
Jul 7th
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
Jul 7th
http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx mehr »
Jobs on production instances
Jul 1st
A wonderful handout for SQL Server Jobs by Tara Kizer.
CU
tosc more »
Installing Clustered SQL Servers - Outline, Checklists, Document Sheets
Jun 30th
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
Jun 30th
http://blogs.msdn.com/craigfr/archive/2008/06/27/subqueries-in-between-and-case-statements.aspx mehr »
Differences between ISNULL and COALESCE
Jun 27th
http://blogs.msdn.com/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx more »
BgInfo, WMI and SQL Server
Jun 27th
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
Jun 27th
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
Jun 27th
http://feeds.feedburner.com/~r/SqlServerCodetipsAndTricksPerformanceTuning/~3/320706728/working-on-sql-admin-hacks-tips-and.html more »
SQLServer-Agent per Script einrichten
Jun 25th
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
Jun 25th
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
Jun 25th
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
Jun 24th
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
Jun 19th
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
Jun 19th
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
Jun 17th
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
Jun 13th
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
Jun 12th
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 »
Paul S. Randal - Surviving Corruption: From Detection to Recovery
Jun 12th
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
Jun 12th
http://blogs.msdn.com/bartd/archive/2006/07/27/wide-vs-narrow-plans.aspx more »
SQLServer 2008 RC0 verfügbar
Jun 9th
Ab sofort ist SQLServer2008 für TechnetPlus-Abonnenten zum download verfügbar. mehr »
SQL Server 2008 RC0 now available for subscribers
Jun 9th
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!
Jun 9th
http://feeds.feedburner.com/~r/SqlteamcomWeblogs/~3/306228662/60618.aspx mehr »