Meet the team
Sign In
RSS
Home
»
sqlCat
»
Technical Notes
Options
Email Blog Author
RSS for posts
Tags
Analysis Services
ASLB
Availability
backup
Backup Compression
Business Intelligence
Cloud
Configuration
Consolidation
Data Loading
Data Warehouse
Database
Disaster Recovery
I/O
Log
OLAP
OLTP
Other
Performance
Reporting Services
Scalability
SharePoint
SQL Server
Transaction Log
Upgrade
Technical Notes
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Technical Notes
Considerations for Using Azure Data Sync
Posted
4 months ago
by
sthoward
1
Comments
Author: Steve Howard Technical reviewers: Prem Mehra, Thomas Kejser, Shaun Tinline-Jones, Murshed Zaman, Praveen M, Sudhesh Suresh Azure Data Sync...
Technical Notes
Updated Spatial Features in the SQL Azure Q4 2011 Service Release
Posted
5 months ago
by
SpatialEd
0
Comments
The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL Server 2012. SQL Server 2012 spatial features are being...
Technical Notes
Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September 2011 Service Release
Posted
6 months ago
by
SpatialEd
0
Comments
Writers: Ed Katibah (Microsoft) Technical Reviewers: Michael Kallay (Microsoft), Milan Stojic (Microsoft) and Michael Rys (Microsoft) Published:...
Technical Notes
New Spatial Features in the SQL Azure Q2 2011 Service Release
Posted
6 months ago
by
SpatialEd
0
Comments
New post on the Technet Wiki summarizing the new spatial features in the SQL Azure Q2 2011 Service Release: http://social.technet.microsoft.com/wiki...
Technical Notes
When to Break Down Complex Queries
Posted
6 months ago
by
sthoward
8
Comments
Writer: Steve Howard Technical Reviewers: boB Taylor, Jay Askew, David Levy, James Podgorski, Thomas Kejser, Shaun Tinline-Jones, Stuart Ozer, Lubor...
Technical Notes
Announcing the first wave of SSAS Maestros
Posted
7 months ago
by
denny.lee
9
Comments
We are proud to announce the first wave of SSAS Maestros v1.0. After three 3-day sessions in Redmond, London, and Hong Kong in Feb/Mar 2011 with hundreds...
Technical Notes
Lessons Learned from Benchmarking a Tier 1 Core Banking ISV Solution - Temenos T24
Posted
over 1 year ago
by
Cheng_kun
0
Comments
TEMENOS T24 is a complete banking solution designed to meet the challenges faced by financial institutions in today’s competitive market. By working with Microsoft, Temenos was able to take advantage of the latest Windows and SQL Server technologies to tune T24 and run it well on Microsoft platform. The lessons learned in the tech note were derived from T24 solution tuning engagement, but most of them apply to other typical OLTP workloads as well....
Technical Notes
Eliminating Deadlocks Caused By Foreign Keys with Large Transactions
Posted
over 1 year ago
by
sthoward
2
Comments
Author : Steve Howard Technical Reviewers : Kun Cheng, Shaun Tinline-Jones, Alexei Khalyako Executive Summary Validating foreign keys requires additional...
Technical Notes
SQL Server Indexing: Using a Low-Selectivity BIT Column First Can Be the Best Strategy
Posted
over 1 year ago
by
sthoward
2
Comments
Published : January 201 1 Author : Steve Howard Technical Reviewers : Mark Souza, Alexei Khalyako, Thomas Kejser, Stuart Ozer, Shen Xu, Chuck Heinzelman...
Technical Notes
Lessons Learned and Findings from a Large Fast-Track POC
Posted
over 1 year ago
by
Nicholas Dritsas
0
Comments
Authors: Nicholas Dritsas, Danny Tambs Reviewers: Mike Ruthruff, Alexei Khalyako Executive Summary To aid Contoso’s goal in establishing an enterprise...
Technical Notes
Table-Valued Functions and tempdb Contention
Posted
over 1 year ago
by
sthoward
3
Comments
Published : January 2011 Author : Steve Howard Technical Reviewers : Sunil Agarwal, Shaun Tinline-Jones, Alexei Khalyako, Thomas Kejser, Mike Ruthruff...
Technical Notes
Reporting Services Performance in SharePoint Integrated Mode in SQL Server 2008 R2
Posted
over 2 years ago
by
CarlRabeler
13
Comments
Author: Carl Rabeler Reviewers: Prash Shirolkar, Robert Bruckner, Dean Kalanquin, Guilherme Boreki, Tanka Sunuwar, Brian Hartman, Craig Guyer, Kevin...
Technical Notes
Character data types versus number data types: are there any performance benefits?
Posted
over 2 years ago
by
AlexeiK
0
Comments
Author: Alexei Khalyako Technical Reviewers: Thomas Kejser,Stuart Ozer, Prem Mehra, Peter Scharlock Editor: Beth Inghram Introduction Working...
Technical Notes
Microsoft Consolidation Planning Tool for SQL Server (CPT) is Available for Download
Posted
over 2 years ago
by
premmehra
6
Comments
Microsoft Consolidation Planning Tool for SQL Server (CPT) is an Excel Add-In that helps database architects in planning their consolidation efforts. One...
Technical Notes
Analysis Services Distinct Count Optimization Using Solid State Devices
Posted
over 2 years ago
by
denny.lee
16
Comments
A Real Practices Case Study at Xbox LIVE Authors : Joseph Szymanski, Tyson Solberg, Denny Lee Technical Reviewers : Lindsey Allen, Akshai Mirchandani...
Technical Notes
Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks
Posted
over 2 years ago
by
admin
8
Comments
Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks Authors : Sedat Yogurtcuoglu, Henk van der Valk, and Thomas...
Technical Notes
Excel, Cube Formulas, Analysis Services, Performance, Network Latency, and Connection Strings
Posted
over 2 years ago
by
CarlRabeler
3
Comments
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Marius Dumitru, John Sirmon, Nick Medveditskov This technical note discusses the usage of...
Technical Notes
Top 10 Hidden Gems in SQL 2008 R2
Posted
over 2 years ago
by
KevinCox
4
Comments
With all the new features in SQL 2008 R2, here are the major ones getting all the press: PowerPivot Parallel Data Warehouse Application and Multi...
Technical Notes
Mirroring a Large Number of Databases in a Single SQL Server Instance
Posted
over 2 years ago
by
SanjayMishra
28
Comments
Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox...
Technical Notes
Analysis Services Load Balancing Solution
Posted
over 2 years ago
by
CarlRabeler
6
Comments
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser ...
Technical Notes
Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices
Posted
over 2 years ago
by
CarlRabeler
26
Comments
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser This...
Technical Notes
Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization
Posted
over 2 years ago
by
AlexeiK
1
Comments
Author: Alexei Khalyako Contributors : Dmitry Artemov, Sergey Pyrin Technical Reviewers: Vijay Tandra Sistla , Mike Weiner, Mark Souza Editor...
Technical Notes
SQL Server Reporting Services Disaster Recovery Case Study
Posted
over 3 years ago
by
denny.lee
10
Comments
Authors : Ayad Shammout (CareGroup Healthcare), Denny Lee Technical Reviewers : Lukasz Pawlowski, Sanjay Mishra, Prem Mehra, Michael Thomassy, Lindsey...
Technical Notes
Deploying a Business Intelligence Solution Using SharePoint 2007, SQL Server 2008 Reporting Services, and PerformancePoint Monitoring Server 2007 with Kerberos
Posted
over 3 years ago
by
CarlRabeler
4
Comments
Author: Carl Rabeler Reviewers: Prem Mehra, Troy Starr, Kevin Donovan, Burzin Patel, Doron Bar-Caspi, Prash Shirolkar, John Wyss This technical note...
Technical Notes
Resolving PAGELATCH Contention on Highly Concurrent INSERT Workloads
Posted
over 3 years ago
by
tkejser
15
Comments
Authors: Thomas Kejser, Lindsey Allen, Arvind Rao and Michael Thomassy Contributors and reviewers: Mike Ruthruff, Lubor Kollar, Prem Mehra, Burzin Patel...
Page 1 of 3 (56 items)
1
2
3