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 takes a new financial risk by getting into retail despite the economy. (The Trade) This Bloomberg video brought to you by News Distribution Network.
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, Microsoft’s newest operating system goes on sale around the world. (Bloomberg News) This Bloomberg video brought to you by News Distribution Network.
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.
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 […]
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 […]
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’
use <DatabaseName>select * from information_schema.tables Example: use myDatabaseselect * from information_schema.tablesorder by table_name
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