Tag: "whitepapers"

SQL Server In-Memory OLTP Internals Overview for CTP1
Sep 24th
Kalen Delaney hat bereits im Juni ein Whitepaper zu SQL Server 2014 veröffentlicht. Titel: SQL Server In-Memory OLTP Internals Overview for CTP1
Wer daran interessiert ist, etwas über die SQL Server 2014 In-Memory Technologie zu erfahren, welche bish… mehr »

Premium Preview for SQL Database Guidance
Jul 31st
Windows Azure SQL Database has released a limited Premium preview for SQL Database. By reserving a fixed amount of capacity for your SQL Database and its secondary replicas, the Premium preview for SQL Database will deliver more predictable performance for cloud applications, relative to existing SQL Database Web and Business Editions… more »

Microsoft BI Authentication and Identity Delegation
Mar 14th
There is a new whitepaper available belonging to the BI stack.
Summary: From straightforward client/server designs to complex architectures relying on distributed Windows services, SharePoint applications, Web services, and data sources, Microsoft B… more »

Custom Code
Okt 2nd
Bereits vor einiger Zeit habe ich dieses Whitepaper von Devin Knight (Pragmatic Works) gefunden. Hier wird an einem einfachen Beispiel die Verwendung von Custom Code für Reports erklärt.
Die dort präsentierte Lösung ist sehr interessant, wenn man … mehr »
SQL Server 2012 Upgrade Technical Guide - in depth
May 30th
Microsoft has recently released the SQL Server 2012 Upgrade Whitepaper.
This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012.
SQL Server 2012 Upgra… more »

Working with SSIS Expressions
Dec 8th
There is a new whitepaper written by Brian Knight (pragmaticworks) available. It is a short introduction into SSIS Expressions and can be downloaded for free. … more »
SQL Server’s Price/Performance vs IBM DB2 Oracle DB
Oct 13th
Are these realy 'whitepapers'?:
Do Not Pay Too Much For Your Database Licenses
SQL Server Gives You More Advanced Features (Out-Of-The-Box)CU tosc more »
Database Upgrade to SQL Server 2008
Jul 26th
Whitepaper at SQLCAT by Dmitry Artemov: Database Upgrade to SQL Server 2008, Tools and Approaches
This paper documents approaches and tools that can help to upgrade of SQL Server databases from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 (or… more »
Analysis and Reporting Services, Design and Implementation
Jun 22nd
Interesting whitepaper at SQLCAT - Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study… more »

New Whitepaper (HA and DR)
Jun 8th
Proven SQL Server Architectures for High Availability and Disaster Recovery
Thanks to Paul S. Randal for sharing the information!
This new whitepaper describes the five most commonly deployed high-availability and disaster-recovery architectures… mehr »
Master Data Services: New white papers
Apr 16th
New Master Data Services white papers are available on MSDN.
This series of technical articles describes Organizational Approaches to Master Data Management, for SQL Server 2008 R2.
Master Data Management from a Business Perspective
Master Data… more »
High Availability with SQL Server 2008 - by Paul S. Randal
Nov 2nd
Paul S. Randal describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes… more »
Fast and Reliable Backup and Restore of a VLDB over the Network
Aug 19th
Thomas H. Grohser discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs) in this SQL Server Technical… more »
High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study
Aug 6th
SQLCAT, has published a new whitepaper / technical case study High Availability and Disaster Recovery at ServiceU for SQL Server 2008.
Follow up:
SQLCAT:… more »
Plan Caching in SQL Server 2008
Aug 4th
Greg Low, has published a whitepaper Plan Caching in SQL Server 2008, it's an update of the whitepaper "Batch compilation, Recompilation and Plan Caching Issues in SQL Server 2005" by Arun Marathe, targeted at SQL Server 2008.
Summary: This paper… more »
SQL Server 2008 Failover Clustering
Jul 9th
SQLCAT, has published a whitepaper SQL Server 2008 Failover Clustering for SQL Server 2008 failover clustering.
Summary: This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008… more »
Disk Alignment Best Practices for SQL Server 2008
May 13th
SQLCAT, has published a whitepaper Disk Partition Alignment Best Practices for SQL Server for configuring optimal disk performance. Follow up: SQLCAT: http://sqlcat.com/whitepapers/archive/2009/05/11/disk-partition-alignment-best-practices-for-sql-… more »
Troubleshooting Performance Problems in SQL Server 2008
Apr 21st
There is a new withe paper on SQL Server 2008 performance troubleshooting and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O BottlenecksSlow-Running Queries
Extended EventsData Collector and the MDWDownload from the Microsoft… more »
Whitepaper-Links collection page for SQL Server
Apr 16th
Paul S. Randal and his wife Kimberly L. Tripp of SQLskills.com linked to whitepapers written/published by reputable sources, consolidated in a Whitepaper-Link Collection.Here it is: http://www.sqlskills.com/whitepapers.asp
CU
tosc more »
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 »
