Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat
-
167 Views
Comments
- Author: SQL Server Customer Advisory Team
- 08-31-2010
Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed often and...
-
356 Views
Comments
- Author: SQL Server Customer Advisory Team
- 08-13-2010
Wanted to let the community know the SQL Server Product Group just released version 4.2 of the SQL Server Migration Assistant! With this version, Microsoft has announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL...
-
1,651 Views
Comments
- Author: SQL Server Customer Advisory Team
- 07-30-2010
Introduction Now that you have your database set up in SQL Azure , the next step is to load your data to this database. Your data could exist in various sources ; valid sources include SQL Server, Oracle, Excel, Access, flat files and others. Your data...
-
1,019 Views
Comments
- Author: SQL Server Customer Advisory Team
- 06-09-2010
I recently returned from Convergence 2010; the annual North American Microsoft Dynamics User Conference in Atlanta. It was a really great conference with many Customer, Partner, and Microsoft presentations and success stories. It was inspiring to see...
-
767 Views
Comments
- Author: SQL Server Customer Advisory Team
- 06-06-2010
There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all, it is THE event for developers and IT Professionals. And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There...
-
909 Views
Comments
- Author: SQL Server Customer Advisory Team
- 05-28-2010
The SQLCAT team and the SQL Azure team have been working closely together with a number of customers even before we launched our CTP (Community Technology Preview) in November, 2009 at the PDC (Professional Developers Conference). After our production...
-
988 Views
Comments
- Author: SQL Server Customer Advisory Team
- 05-20-2010
Author: Kun Cheng Reviewer: Alexei Khalyako Last week, I was presented with an interesting Full-text search problem, which I like to share with you, especially the ones who need to support international markets with SQL Server Full-text solution. The...
-
904 Views
Comments
- Author: SQL Server Customer Advisory Team
- 05-14-2010
We have been pretty excited about the last few weeks where there has been a lot of buzz about SQL Server 2008 R2 RTM. As noted in the SQL Server Data Platform Insider blog posting , this release has a lot of interesting features and is a major release...
-
1,167 Views
Comments
- Author: SQL Server Customer Advisory Team
- 05-11-2010
Author: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions. The specific application...
-
1,074 Views
Comments
- Author: SQL Server Customer Advisory Team
- 04-05-2010
In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive...
1 2 3 4 5 Next > ... Last »
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|