The SQLIOSim utility simulates the I/O patterns of Microsoft SQL Server 2005, of SQL Server 2000, and of SQL Server 7.0. The I/O patterns of these versions of SQL Server resemble one another. The SQLIOStress utility has been used to test SQL Server 2005 I/O requirements for many years. For more information and to download […]
Microsoft Launches Retail Store
Microsoft takes a new financial risk by getting into retail despite the economy. (The Trade) This Bloomberg video brought to you by News Distribution Network.
Microsoft Windows 7 OS Takes Off
High hopes for Microsoft’s latest operating system platform, Windows 7. Components communities keep their fingers crossed. (The Trade) This Bloomberg video brought to you by News Distribution Network.
Windows 7 Global Launch
Windows 7, Microsoft’s newest operating system goes on sale around the world. (Bloomberg News) This Bloomberg video brought to you by News Distribution Network.
Microsoft Windows 7 OS Faces Piracy
Microsoft feels strongly about piracy, especially in China, and faces this problem head on. (The Trade) This Bloomberg video brought to you by News Distribution Network.
Microsoft SSL Diagnostics
A common problem for administrators of IIS servers is configuring and troubleshooting SSL enabled websites. To assist in administrators efforts, Microsoft has designed a tool – SSL Diagnostics – to aid in quickly identifying configuration problems in the IIS metabase, certificates, or certificate stores. This tool allows users to review configuration information in a easy […]
HOW TO: Export all email addresses from a domain
AD Users & Computers UI lets you list the mail column for each object, which displays the default (SMTP) email address for objects. You can export the list from ADUC as csv/txt. However, any additional email addresses in the proxyAddresses attribute are not exported. There’s no GUI to list/export all email addresses. Here’s a script […]
MS SQL Backup Database to Disk
To create a full database backup using Transact-SQL Execute the BACKUP DATABASE statement to create the full database backup, specifying: The name of the database to back up. The backup device where the full database backup is written. Example BACKUP DATABASE AdventureWorks TO DISK = ‘C:BackupsAdventureWorks.BAK’
Display List of MS SQL Database Tables
use <DatabaseName>select * from information_schema.tables Example: use myDatabaseselect * from information_schema.tablesorder by table_name
Shrink (truncate) Microsoft SQL transaction log files
Shrink (truncate / purge) MS SQL transaction log files. Use <dbname>Goalter database <dbname> set recovery simplegodbcc shrinkfile (<dbname>_log, 100)gocheckpointgodbcc shrinkfile (<dbname>_log, 100)alter database <dbname> set recovery fullgo Example: Use myDatabaseGoalter database myDatabase set recovery simplegodbcc shrinkfile (myDatabase_log, 100)gocheckpointgodbcc shrinkfile (myDatabase_log, 100)alter database myDatabase set recovery fullgo