Tag: "whitepapers"

SQL Server In-Memory OLTP Internals Overview for CTP1

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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 »