Télécharger Windows Server 2012Galerie TechNet - Ressources pour les professionnels de l'informatique
Téléchargez des ressources et des applications pour Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office et d'autres produits. Découvrez des ressources écrites en VB Script, PowerShell, SQL, JavaScript ou d'autres langages de script. De nouvelles ressources étant régulièrement ajoutées, revenez souvent consulter cette page pour découvrir les nouveautés.
Chaque contribution vous est concédée sous licence en vertu d’un Contrat de licence par son propriétaire, et non par Microsoft. Microsoft ne garantit pas la contribution et ne prétend pas accorder de droits pour celle-ci.
Trier par:
|
This article is about multiple ways of splitting a column with delimited string into multiple columns .If the number of delimiters are 3 or less than that then PARSENAME function can be used to Split a column with delimited string into multiple columns like shown below : To make
|
(4)
Mis à jour 03/08/2013
Disponible 03/08/2013
307
Téléchargements
|
|
|
After a timespan of idle SSRS falls asleep;the first request will be extremly slow,up to several minutes.This PowerShell script performs a simple HTTP request to the SSRS-RM url,to simulate a normal activity.If you run it frequently you avoid the SSRS worker shutdown.
|
(16)
Mis à jour 19/10/2011
Disponible 19/10/2011
3 710
Téléchargements
|
|
|
This PoSh script tries to enumerate SQL Server instances in your network using SMO and creates an inventory as a Html document.It's similar to MS MAP,but only as a simple plain script and dedicated for SQL Server instances.With this info you could plan a SQL Server consolidation.
|
(11)
Mis à jour 27/11/2011
Disponible 27/11/2011
3 939
Téléchargements
|
|
|
This function looks up SQL Instance information via the registry on local and remote systems. Information looked up is Version, Edition type, whether the SQL Instance is part of a cluster and the other nodes in the cluster and
the full name that can be used in another script to |
(2)
Mis à jour 16/09/2013
Disponible 16/09/2013
177
Téléchargements
|
|
|
This Transact-SQL script returns the values from DMV sys.dm_exec_que
These "costs" can be "Average CPU execution time "Average logical operations" or the total values of these measures. |
(11)
Mis à jour 15/07/2012
Disponible 01/09/2011
2 052
Téléchargements
|
|
|
Article contains the information about an issue that leads to corruption in MS SQL Server backup file, possible ways to prevent data loss at times of corruption in SQL backup file and SQL Backup Recovery that is an affordable solution to repair corrupt SQL backup file.
|
(0)
Mis à jour 26/04/2013
Disponible 26/04/2013
242
Téléchargements
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(4)
Mis à jour 18/08/2011
Disponible 03/08/2011
1 522
Téléchargements
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(16)
Mis à jour 13/08/2011
Disponible 03/08/2011
2 459
Téléchargements
|
|
|
As the system table names had been changed in SQL 2008, an earlier contribution unfortunately will return with an error message on SQL 2008, 2008 R2, and 2012 - so a slightly modified script is needed to get the same information.
|
(2)
Mis à jour 05/03/2012
Disponible 07/02/2012
1 119
Téléchargements
|
|
|
Running time consuming stored procedures requires sometimes asynchronous processing. We can either implement it within the application by starting new thread and execute stored procedure in that process or we can use MSSQL Service Broker to do it within the database.
|
(0)
Mis à jour 20/06/2013
Disponible 19/06/2013
245
Téléchargements
|
|
|
This T-SQL script will refresh all views in a database (regardless of their schema) by calling sp_refreshview.
|
(2)
Mis à jour 10/09/2012
Disponible 07/08/2012
321
Téléchargements
|
|
|
This Transact-SQL statements lists all SSIS packages stored in the msdb system database with detailed information.It gives a brief overview which packages exists, who created them and which is the actual version of it.Works with SQL Server 2005 and higher versions in all editions
|
(7)
Mis à jour 26/08/2011
Disponible 26/08/2011
1 707
Téléchargements
|
|
|
Modeled after SQL Server 2008 Invoke-Sqlcmd, but fixes bug in QueryTimeout.
|
(10)
Mis à jour 05/10/2010
Disponible 05/10/2010
|
|
|
List all database tables and there indexes with detailed information about row count and used + reserved data space.
|
(7)
Mis à jour 13/08/2011
Disponible 24/07/2011
1 628
Téléchargements
|
|
|
The Transactional Replication Latency Monitoring Tool provides alerts when transactional subscribers fall behind the publishers, by more than the configured latency threshold. This tool helps reduce downtime and allows app owners to better manage their SLAs with customers.
|
(10)
Mis à jour 27/11/2012
Disponible 18/05/2012
741
Téléchargements
|
|