Welcome to TechNet Blogs Sign in | Join | Help

October 2007 - Posts

BizTalk Server 2006 LifeCycle Demos description V1.0

It's here : http://blogs.msdn.com/benjguin/archive/2006/03/30/565021.aspx#_Toc131507714 Most demos are executed on the following platform : Read More...
Posted Wednesday, October 31, 2007 1:40 PM by patricg | 0 Comments

Master Data Management Web Site...

It's here : http://www.microsoft.com/sharepoint/mdm With a detailed roadmap here : The Microsoft MDM Roadmap The main points are : The Stratature +EDM product will be released as a Technology Preview in February, 2008 to a select group of customers. A Read More...
Posted Wednesday, October 31, 2007 1:30 PM by patricg | 0 Comments

SQL Server 2005 Analysis Services Load Testing...

Summary : Microsoft Visual Studio 2005 Team System includes a Load Test tool that you can use for performance and stress testing of a Microsoft SQL Server 2005 Analysis Services deployment. The Load Test tool runs the tests that you create, and optionally Read More...
Posted Monday, October 29, 2007 4:05 PM by patricg | 0 Comments

SQL SERVER TIPS n°5 : TempDB Best practices

In this tip we will talk about some of the best practises for configuring TempDB database and its placement: The size and physical placement of the tempdb database can affect the performance of a system. For example, if the size that is defined for tempdb Read More...
Posted Thursday, October 18, 2007 7:24 PM by patricg | 0 Comments

Explication VISUELLE des Jointures SQL...

Si vous êtes un peu perdu entre les INNER, OUTER ou FULL Join, voici un message qui essaye de résumer visuellement l'ensemble : La suite ici : http://www.codinghorror.com/blog/archives/000976.html Attention a prendre toutefois avec précaution car l'exemple Read More...
Posted Tuesday, October 16, 2007 9:50 AM by patricg | 0 Comments

SQL SERVER TIPS n°4 : Remote Execution using EXECUTE command

In previous versions of SQL Server (Prior to SQL Server 2005) you could execute EXECUTE command only on the local server. With SQL Server 2005 EXECUTE command now has AT parameter which can be used for executing the statement on a remote linked server. Read More...
Posted Tuesday, October 16, 2007 9:36 AM by patricg | 0 Comments

Série d'annonceS sur le support optimisé de PHP sur la plateforme Windows-IIS-SQL Server...

· Zend and Microsoft announce today that we will continue work on FastCGI and scalable PHP hosting on Windows Servers . Specifically, Zend has committed to redistribute FastCGI in Zend Core, its certified PHP 5 offering. · Zend will ensure that Zend Core Read More...
Posted Friday, October 12, 2007 1:59 PM by patricg | 0 Comments

NOUVEAU Blog "Mission Critical, Datacenter et Datawarehouse" sur SQL Server !

A signaler la création d'un nouveau blog sur SQL Server par un architecte du MTC Paris. Sa vocation est avant tout d'être un espace d'échange autour des technologies de base de données, et en particulier sur les aspects Mission Critical, Dataceneter et Read More...
Posted Thursday, October 11, 2007 2:39 PM by patricg | 0 Comments

Le PRIX DE SQL Server 2008 NE CHANGERA pas !

C'est désormais officiel ! No price hike for SQL Server 2008, Microsoft says. DENVER – On top of new features in the next version of SQL Server 2008 the most alluring attribute should be that the database’s price will not change, according to Microsoft Read More...
Posted Monday, October 08, 2007 6:08 PM by patricg | 0 Comments

Outils Gratuits IDERA...

Idera est bien connu pour proposer toute une gamme d'outils complémentaires pour SQL Server. Vous pourrez les trouver sur leur site. Mais saviez-vous qu'ils mettent à disposition 3 outils gratuits ? Ils sont accessibles à partir d'ici : http://www.idera.com/FreeTools/default.aspx Read More...
Posted Friday, October 05, 2007 6:43 PM by patricg | 1 Comments

SQL SERVER TIPS n°3 : How can I view I/O statistics on the physical database files in a database?

The system function fn_virtualfilestats , available in both SQL Server 2000 and SQL Server 2005, or sys.dm_io_virtual_file_stats (in SQL 2005 only) allows you to do exactly what you’re looking for. The function returns statistical information gathered Read More...
Posted Friday, October 05, 2007 4:08 PM by patricg | 0 Comments

Les Groupes Utilisateurs font leur show !

Groupe Utilisateurs Exchange - L'intégration d'Exchange avec OCS : http://www.microsoft.com/france/vision/WebcastTechnet.aspx?eid=3b3e93d3-df92-4671-87d7-d873fae2f54c Club MOSS - La gestion de contenu d'entreprise et la collaboration : http://www.microsoft.com/france/vision/WebcastTechnet.aspx?eid=eb78d323-e2ef-4626-b5bc-1919e8ac32a3 Read More...
Posted Friday, October 05, 2007 3:17 PM by patricg | 0 Comments

Vous avez toujours révé de visualiser comment SQL Server alloue les espaces dans ses FICHIERS ?

Et bien il existe un petit outil très sympathique permettant de faire cela. Il s'appelle SQL Internals Viewer et est téléchargable gratuitement. Attention : il n'est qu'en version 0.11 beta donc encore en cours de développement mais fournit déjà pleins Read More...
Posted Friday, October 05, 2007 12:47 PM by patricg | 0 Comments

Vous avez toujours voulu avoir comment Microsoft gère ses serveurs SQL internes ?

Et bien, vous pouvez télécharger les scripts Microsoft AITScripts.zip et vous en saurez beaucoup plus à ce sujet. Parmi les 182 fichiers présents dans le zip, vous pouvez commencer par le SQL Maintenance Jobs V3.doc qui décrit l'ensembe des scripts présents. Read More...
Posted Friday, October 05, 2007 10:48 AM by patricg | 0 Comments

Accès au code source du Framework .NET 3.5 !

Ce sera possible avec Visual Studio 2008. Comme indiqué par Scott Guthrie sur son blog, One of the things my team has been working to enable has been the ability for .NET developers to download and browse the source code of the .NET Framework libraries, Read More...
Posted Thursday, October 04, 2007 11:09 AM by patricg | 0 Comments

SQL Server Tips n°2 : BEST PRACTICES for Shrinking T-Log Files and database FILES

Best Practices for shrinking transaction log files : How many times have you received an alert that the disk has run out of space and when investigated you found that the log file is what caused the disk space to run out of space. In today's tip we will Read More...
Posted Wednesday, October 03, 2007 3:43 PM by patricg | 0 Comments

SQL Server TiPS n°1 : Stop Using Services.MSC For Changing Service AccOUNTS

Did you know that when SQL Server service account is configured with a Windows NT account , SQL Server sets various Windows user rights and permissions on several files, folders, and several registry keys. However, when you use SERVICES from CONTROL PANEL Read More...
Posted Wednesday, October 03, 2007 1:56 PM by patricg | 1 Comments
 
Page view tracker