Categories
Micro$oft Microsoft SQL

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.

Categories
Bloomberg Linux Microsoft News Operating System OS Video Win 7 Win7 Windows Windows 7 Windows7

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.

Categories
Bloomberg Linux Microsoft News Operating System OS Video Win 7 Win7 Windows Windows 7 Windows7

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.

Categories
Bloomberg Linux Microsoft News Operating System OS Video Win 7 Win7 Windows Windows 7 Windows7

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.

Categories
Bloomberg Linux Microsoft News Operating System OS Video Win 7 Win7 Windows Windows 7 Windows7

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.

Categories
CA certificate IIS Linux Microsoft SSL TLS Windows

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.

Categories
AD/LDAP Administration Exchange 2007 Linux Mailbox Microsoft Scripts SMTP Windows

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

Categories
Backup Database Linux Microsoft Query Analyzer SQL Transact-SQL Utility Windows

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:BackupsAdventureWorks.BAK'

Categories
Linux List Tables Microsoft SQL Windows

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

Categories
Linux Microsoft SQL Windows

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