Simulate SQL Server Activity on a Disk Subsystem with SQLIOSim from Microsoft

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 SQLIOSim utility from Microsoft see KB231619.

NOTE: The SQLIOSim utility replaces the SQLIOStress utility. The SQLIOStress utility was formerly named the SQL70IOStress utility.

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 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.

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 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 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 to read view mode or to run the tool silently with only the creation of a log file. During use, administrators can simulate the SSL handshake to find errors. They can also quickly "hot swap" certificates for testing purposes.

These packages come in two forms: Express and Full. The express will only give the pertinent tools for administrators to use SSL Diagnostics while full install installs the same files with the appropriate documentation. Included in the full install is a SSL Frequently Asked Questions that can assist in the learning of SSL for administrators.

More details & download SSL Diagnostics for x86 or x64.

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 to do that - ListEmailAddresses.vbs.

File: ListEmailAddresses.zip

What does it exactly do?
- Queries Active Directory for Contacts & Groups
- Lists their email addresses
- Queries Users
- Lists enabled users' email addresses
- Lists disabled users' email addresses separately
- Outputs to command line and also to a text file - c:\proxyaddresses.txt
- X.400 addresses are ignored

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:

1. The name of the database to back up.
2. The backup device where the full database backup is written.

Example

BACKUP DATABASE AdventureWorks 
TO DISK = 'C:\Backups\AdventureWorks.BAK'

Display List of MS SQL Database Tables

use <DatabaseName>
select * from information_schema.tables

Example:

use myDatabase
select * from information_schema.tables
order by table_name

Shrink (truncate) Microsoft SQL transaction log files

Shrink (truncate / purge) MS SQL transaction log files.

Use <dbname>
Go
alter database <dbname> set recovery simple
go
dbcc shrinkfile (<dbname>_log, 100)
go
checkpoint
go
dbcc shrinkfile (<dbname>_log, 100)
alter database <dbname> set recovery full
go

Example:

Use myDatabase
Go
alter database myDatabase set recovery simple
go
dbcc shrinkfile (myDatabase_log, 100)
go
checkpoint
go
dbcc shrinkfile (myDatabase_log, 100)
alter database myDatabase set recovery full
go

View logical log filename and physical location for MS SQL database files

View logical log filename and physical location (current DB only).
select physical_name from sys.database_files where type = 1

View logical log filename for all DBs:

select a.name, b.name as 'Logical filename', b.filename from sys.sysdatabases a
inner join sys.sysaltfiles b
on a.dbid = b.dbid where fileid = 2

Microsoft Web Platform Installer 2.0

The Microsoft Web Platform Installer 2.0 (Web PI) is a free tool that makes it simple to download, install and keep up-to-date with the latest components of the Microsoft Web Platform, including Internet Information Services (IIS), SQL Server Express, .NET Framework and Visual Web Developer. In addition, install popular open source ASP.NET and PHP web apps with the Web PI.

Web PI 2.0 Includes

• Popular Web Apps
  Install free popular ASP.NET and PHP web apps such as DotNetNuke and WordPress.
  
• .NET Framework
  Install the latest version of the .NET Framework. This includes everything you need to work with ASP.NET.
  
• IIS and Extensions
  Install the latest version of IIS, including latest IIS Web extensions like IIS Media Services.
  
• SQL Server
  Install the latest version of SQL Server 2008 Express. This includes both the database engine and tools.
  
• Visual Web Developer
  Install the latest version of Visual Web Developer Express, Our full featured free web development tool.
  
• Extra and Goodies
  In addition to everything above, the Web PI also includes the latest community version of PHP for Windows.

Download:
http://microsoft.com/web/channel/products/WebPlatformInstaller.aspx.