Windows Server 2012 Karşıdan YükleTechNet Galerisi - BT Uzmanları için Kaynaklar
Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office ve diğer ürünler için kaynakları ve uygulamaları yükleyin VB Script, PowerShell, SQL, JavaScript, veya diğer komut dillerinde yazılmış kaynakları bulun. Yeni kaynaklar sıklıkla eklenmektedir, bu yüzden sık sık kontrol ederek yeni neler olduğunu görün.
Her bir katkı size Microsoft tarafından değil, sahibi tarafından bir Lisans Anlaşması kapsamında lisanslanır. Microsoft katkıyı garanti etmez veya ona haklar verme konusunu belirtmez.
Şuna Göre Sırala:
|
This SQL script will helpful for daily checklist, incase of no any third party tool is available for database monitoring. script will produce the all database size, status, recovery model, data & log file size, spaceused & free space details.
|
(12)
Güncellenme 14.01.2013
Piyasaya sürülme 29.08.2012
2.173
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 03.08.2013
Piyasaya sürülme 03.08.2013
307
Karşıdan Yüklemeler
|
|
|
If you already have data in excel sheet, the data is structured in tabular format in the excel, and you want to upload all this data in SQL Server, the attached guide shows the steps to upload the entire data from the excel to SQL Server table using C#.Net
|
(1)
Güncellenme 13.02.2013
Piyasaya sürülme 13.02.2013
1.608
Karşıdan Yüklemeler
|
|
|
This SQL script is used for maintenance task of reorganizing & rebuilding of indexes task. I have inclued the fragmentation level of indexes is >5 & <30 for reorganizng & above 30 is for rebuild. Result will display as on which indexes task is executed.
|
(6)
Güncellenme 07.09.2012
Piyasaya sürülme 07.09.2012
748
Karşıdan Yüklemeler
|
|
|
This SQL script will provide you all databases Index fragmentation details. It would be helpful while scheduling or determining maintenance task of reindexing.
|
(8)
Güncellenme 06.09.2012
Piyasaya sürülme 06.09.2012
971
Karşıdan Yüklemeler
|
|
|
SQL server all jobs details:-This query is provide you the sql server all jobs details. you will get job name, job status, Last run date of job & job execution status (failed or successfull) , you can add or modify fields as per requirement. This query is running on versions of s
|
(1)
Güncellenme 04.01.2013
Piyasaya sürülme 04.01.2013
391
Karşıdan Yüklemeler
|
|
|
From long time I want to create a one query which will give me a required output of sql server logins, inshort sql server security audit report.Finally I have developed one query which will generate a report in one table having separate details for each task.
|
(3)
Güncellenme 25.10.2012
Piyasaya sürülme 25.10.2012
1.210
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 16.09.2013
Piyasaya sürülme 16.09.2013
177
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 15.07.2012
Piyasaya sürülme 01.09.2011
2.052
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 26.04.2013
Piyasaya sürülme 26.04.2013
242
Karşıdan Yüklemeler
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(4)
Güncellenme 18.08.2011
Piyasaya sürülme 03.08.2011
1.522
Karşıdan Yüklemeler
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(16)
Güncellenme 13.08.2011
Piyasaya sürülme 03.08.2011
2.459
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 05.03.2012
Piyasaya sürülme 07.02.2012
1.119
Karşıdan Yüklemeler
|
|
|
This T-SQL script will refresh all views in a database (regardless of their schema) by calling sp_refreshview.
|
(2)
Güncellenme 10.09.2012
Piyasaya sürülme 07.08.2012
321
Karşıdan Yüklemeler
|
|
|
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)
Güncellenme 26.08.2011
Piyasaya sürülme 26.08.2011
1.707
Karşıdan Yüklemeler
|
|