Mehboob

" Every cloud has a silver lining "

Archive for May, 2011

Learning Portals

Posted by Mehboob on 23/05/2011

This Issue: May 2011

Resources

Learning Portals

Cloud Power: Create the Next Big App

So you’ve got an idea for that next big app and you need to get it launched as quickly as possible. Maybe it’s a mobile app, something you want to run on Facebook, or a project that stretches your ASP.NET skills. Tune in to this five-part online event series and learn how to harness the cloud or get your apps into it. We’ll share hands-on lessons, make it real with code samples, and set you up with a 30-day complimentary Windows Azure Pass. Join as we explore the topics that matter most for today’s developers.

Training – MOC/Courseware/Exams/Clinics: Special Training Offers on Windows 7 Now Available

Microsoft Learning Partners are offering specials during the month of May for training on Course 6294: Planning and Managing Windows 7 Desktop Deployments and Environments. This five-day, instructor-led course covers how to design, configure, and manage the Windows 7 client environment. It also prepares students for Exam 70-686, Pro: Windows 7, Enterprise Desktop Administrator. Sign up for training soon to enjoy the savings!

Posted in BI-DW, MS SQL Server, MS Windows, SharePoint | Comments Off

Website Security Errors with IE9

Posted by Mehboob on 12/05/2011

Website Security Certificate Error:  Security zones to default. If you configure security settings to be too restrictive, you may prevent Internet Explorer from displaying certain Web sites. To determine whether an issue is caused by overly restrictive security settings, revert to default security settings. To do this, just follow these 5 steps:
 
Option A:
 
01. Open Internet Explorer.
 
02. Click Tools, and then click Internet Options.
 
03. Click the Security tab.
 
05. Click reset all zones to default level, and then click OK.
 
After you do this, test Internet Explorer to verify that it works correctly, if answer is NO, go for B.
 
Option B:
 
Also try the following steps:
 
1. Open an Internet Explorer window. Click “Tools,” then choose “Internet Options.” This will open the Internet Options window.
 
2. Click the “Content” tab in the Internet Options window. This will open the Content options page.
 
3. Click the “Certificates” button on the Content options page. This will open the Certificates window.
 
4. Click the “Untrusted Publishers” tab in the Certificates window. It may be necessary to scroll horizontally to see the tab.
 
5. Click to highlight the security certificate that you want to trust, then click the “Remove” button.
This will open a confirmation window.

Click the “Yes” button in the confirmation window to complete the process.

About certificate errors link: http://windows.microsoft.com/en-US/windows7/About-certificate-errors

software config:  •Windows 7 Ultimate 32 OR 64-bit  •IE9 Beta, Version 9.0.7930.16406

I hope this information help you.

Khan

MCTS.

Posted in SharePoint | Comments Off

Free SQL Server tools

Posted by Mehboob on 05/05/2011

I start with this and i hope its help dba folks…

Free SQL Server books:-

“Boost your DBA expertise” and “DBA Best Practices”  – books by RedGate

SQL Injection tools:-

Top 15 free SQL Injection Scanners- 15 free SQL injection scanners, kool

Microsoft Source Code Analyzer for SQL Injection – a static code analysis tool for finding SQL Injection vulnerabilities in ASP

UrlScan v3.0 Beta – a Microsoft security tool that restricts the types of HTTP requests that Internet Information Services (IIS) will process

HP Scrawlr – crawls a website, simultaneously analyzing the parameters of each individual web page for SQL Injection vulnerabilities

Blind Sql Injection Brute Forcer version 2 – accepts custom SQL queries as a command line parameter.

Administration:-

SQL Web Data Administrator – enables you to easily manage your SQL Server data from a web browser

SQL Server Cache Manager – allows you to return information about what is stored is the SQL Server cache and how efficiently it is being used.

SQL Internals Viewer – a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organized and stored.

Microsoft SQL Server 2000/2005 Management Pack – monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems.

Performance Analysis of Logs (PAL) Tool – tool that reads in a performance monitor counter log (any known format) and analyzes it using complex, but known thresholds (provided).

Microsoft Baseline Security Analyzer – helps small- and medium-sized businesses determine their security state in accordance with Microsoft security recommendations and offers specific remediation guidance

RML Utilities for SQL Server (x86) and (x64) – tools to help database administrators manage the performance of Microsoft SQL Server: Overview

SQLDumper.exe – comes with SQL Server. Installed at ..\Microsoft SQL Server\90\Shared\SQLDumper.exe. Generates a dump file on demand for any Microsoft Windows application.

SQL Server 2005 Partition Management – helps in data loading and extraction from partitions

SQLdiag Utility – a general purpose diagnostics collection utility that can be run as a console application or as a service (comes with SQL Server)

SQL Nexus – analyzes SQLDIAG captures

SQL Server 2005 Express Profiler – a free SQL Profiler for SQL Express

Log Parser 2.2 – provides query access to log files, XML files and CSV files, the Event Log, the Registry, the file system, and AD

Microsoft SQL Server Management Studio Express – apparently a lot of people don’t know this exists. Stripped down version of SSMS

SQL Server 2005 System Views Map – a nice map of all the DMV’s and links between them

SQL Server Web Data Administrator – admin your SQL Server over the web

SQL Server Express Utility – simple interaction with SQL Server

TableDiff.exe – utility that compares 2 tables for differences in data and schema for SQL Server 2000 and 2005

DMVStats – collects, analyzes and reports on SQL Server 2005 DMV performance data

Best practices, analysis, health and performance:-

SQL Server FineBuild – provides one-click install and best-practice configuration of SQL Server 2005.

SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX) – contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 

SQLIO GUI – user interface for SQLIO Disk Subsystem Benchmark Tool

SQLQueryStress -  automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your server

SQLIO Disk Subsystem Benchmark Tool – used to determine the I/O capacity of a given configuration

SQL Server 2005 Best Practices Analyzer – lets you verify the implementation of common Best Practices in SQL Server 2005

SQL Server 2000 Best Practices Analyzer – lets you verify the implementation of common Best Practices in SQL Server 2000

SQL Server Health and History Tool (SQLH2) – collects information from instances of SQL Server to determine how SQL Server is being used much more.

SQL Server Health and History Tool (SQLH2) Performance Collector – optional tool to collect performance counters that are consumed by the SQLH2

SQL Server Health and History Tool (SQLH2) Reports – reports needed to view the data collected by the SQLH2

SQL Server 2005 Performance Dashboard Reports – performance reports that integrate into SQL Server Management Studio

Microsoft SQL Server 2000/2005 Management Pack – monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems

Database Publishing to hosted servers:-

Microsoft SQL Server Database Publishing Wizard – provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers

Microsoft SQL Server Database Publishing Services – deployed by shared hosting providers to enable publishing of SQL Server databases over the Internet

Upgrade and Migration:-

Microsoft SQL Server 2005 Upgrade Advisor – used when upgrading from lower SQL Server version to SQL Server 2005

SQL Server Migration Assistant for Access

SQL Server Migration Assistant for Oracle

SQL Server Migration Assistant for Sybase ASE

SQL Server Analysis Services:-

MDX Script Performance Analyser – allows the user to identify how much each calculated member, analysis Services cube’s MDX script contributes to the overall performance of a given MDX query, name its self show you.

Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 – SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007

 SQL Server Integration Services:-

DTLoggedExec  – allows you to run a Sql Server Integration Services (SSIS) Package 

 SQL Server 2005 BI Development Studio (BIDS):-

BIDS Helper – Add-in for Visual Studio Business Intelligence Development Studio

SQL Server Analysis Services Product Samples

SQL Server 2005 Samples and Sample Databases

MS stuff:-

SQL CLR Project – a tool that allows you to deploy .NET assemblies to SQL Server.

SQL Designer – online SQL Database designer. Contains Importing and Exporting scripts to and from different formats

DbDiff and DbScripting – Compare SQL Server database structures and generate scripts

SQL Accord Community Edition – compares database schema

Quest software’s Comparison Suite for SQL Server

Bypsoft’s DBTYP.NET – compares SQL Server, MySQL and Oracle databases.

SQL DB Tools – SqlDbDiff, SqlDbSearch and SqlDbSize utility

ClearTrace – utility to easier read your saved trace files

SQL Sripter – data export and scripting utility for Microsoft SQL Server

ScriptDb – data export and scripting utility for Microsoft SQL Server

Idera’s Free Tools – SQL Server backup and recovery tool, performance dashboard and logons and permissions etc etc

Posted in SharePoint | Comments Off

 
Follow

Get every new post delivered to your Inbox.