This is a mirror of official site: http://jasper-net.blogspot.com/

Maintaining High Availability for the Microsoft.com site

| Wednesday, March 17, 2010
image_thumb.png

Wow, some interesting stats here. Check out the technet post at: http://technet.microsoft.com/en-us/library/ff467943.aspx

Read more: Chris Vidotto's Blog

Posted via email from jasper22's posterous

Troubleshooting Snapshot Agent hang

|
I recently got a customer call where the SQL 2008 Snapshot Agent appeared to hang when started from SSMS.

image_thumb.png

As you can see, pop-up status window shows “Starting agent”.  So, looks like its running, but it stays this way forever. Replication Monitor also shows as “Running”.
If I double-click the I can zoom in on Agent details, however all I get is message the makes it sound like the Agent is busy, or maybe hung, but I’m not sure.

So, how can I tell what the Snapshot Agent is doing without all the high-layer status tools getting in the way.

Answer, since the Snapshot Agent is just Windows executable (…100\com\snapshot.exe), I can run it outside of SSMS but starting it from a Windows CMD-line, yes, we still use CMD prompt for troubleshooting.  Here is what I did.

Read more: REPLTalk covers Using and Tuning SQL Replication

Posted via email from jasper22's posterous

Internet Explorer 9

|
HeaderLeft.png


Interested in checking out the new Web platform capabilities of Internet Explorer 9?
Download the Internet Explorer Platform Preview right now

Read more: IE Test Drive

Posted via email from jasper22's posterous

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

| Tuesday, March 16, 2010
This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single batch.

Let us consider the following example of this query.

The following query usually runs on multicore on a dual core machine (please note it may not be the case with your machine).

USE AdventureWorks
GO
SELECT *
FROM Sales.SalesOrderDetail
ORDER BY ProductID
GO

Read more: Journey to SQL Authority with Pinal Dave

Posted via email from jasper22's posterous

How to build your own DropBox personal clone

|
DropBox is a great time saver but it’s very limited in storage space. There seems to be no real other free alternative services (all online storage services don’t do automatic synchronisation and are not seamlessly integrated with the OS explorer). So why not look at opensource solutions ? There seems to be any ready-made one so you have to build it yourself by assembling several systems. fak3r has been experimenting with this; you can read his step by step instructions here though I didn’t test them myself as I don’t have a Linux but a Windows system. Any suggestion for Windows welcome or I will have to setup Linux one day

Read more: Ask Superuser
Instructions: Build DropBox

Posted via email from jasper22's posterous

XPerf Tool – Why Can’t You Live Without It?

|
Israel Burman (Israel is one of the ADPlus creators and the guy who taught me the XPerf tool) and Mario Hewardt told me I should blog about the XPerf tool.
Although I’m new to this tool I decided to follow their suggestions because I believe you’re going to wonder how you could live without using this tool after using it for the first time. J

So, when starting to write this article I decided to browse the internet to see how many articles from Microsoft I could find because I didn’t want to be redundant. As a matter of fact I found several great articles. (Am I late to the party? J) Some of these articles are very didactic and similar to what I had in mind.

That said, I’m not going to be redundant here, likewise I’m going to give you just an overview about the tool and mention those articles that details the configuration and usage of XPerf so you can get the necessary details from these articles without having to research the internet all over again.

WHAT’S XPERF?

-      XPerf is based on ETW (Event Tracing for Windows) which is a very efficient tracing infrastructure.
-      The overhead caused by XPerf is about ~2.5% CPU, in other words, very minimum.
-      The tracing can be dynamically enabled or disabled and it doesn’t require a reboot.
-      XPerf enables you to collect logs, create reports and see charts from the collected data.

Israel Burman (Israel is one of the ADPlus creators and the guy who taught me the XPerf tool) and Mario Hewardt told me I should blog about the XPerf tool.
Although I’m new to this tool I decided to follow their suggestions because I believe you’re going to wonder how you could live without using this tool after using it for the first time. J

So, when starting to write this article I decided to browse the internet to see how many articles from Microsoft I could find because I didn’t want to be redundant. As a matter of fact I found several great articles. (Am I late to the party? J) Some of these articles are very didactic and similar to what I had in mind.

That said, I’m not going to be redundant here, likewise I’m going to give you just an overview about the tool and mention those articles that details the configuration and usage of XPerf so you can get the necessary details from these articles without having to research the internet all over again.

WHAT’S XPERF?

-      XPerf is based on ETW (Event Tracing for Windows) which is a very efficient tracing infrastructure.
-      The overhead caused by XPerf is about ~2.5% CPU, in other words, very minimum.
-      The tracing can be dynamically enabled or disabled and it doesn’t require a reboot.
-      XPerf enables you to collect logs, create reports and see charts from the collected data.


WHEN SHOULD YOU USE XPERF?

-      When you need to isolate performance problems.
-      To get a better understanding of the Operating System.
-      Probably other scenarios where you can benefit for tracing the Windows components.

WHEN SHOULD YOU USE XPERF?

-      When you need to isolate performance problems.
-      To get a better understanding of the Operating System.
-      Probably other scenarios where you can benefit for tracing the Windows components.

Read more: Debugging Toolbox

Posted via email from jasper22's posterous

Announcing the Release of the Open XML SDK 2.0

|
Today, I am really excited to announce the worldwide availability of the Open XML SDK 2.0 for Microsoft Office! The Open XML SDK plays an integral part in creating Office document solutions that work on the client or server. The Open XML SDK allows you to create, consume, and manipulate Open XML files without needing to automate Office client applications. Combining the power of Office Services and the Open XML SDK enables even more scenarios, such as rich server-side document assembly solutions. No longer will you need to pay special attention to one of Office's most popular knowledge base articles that talks about how automating Office client applications on the server is not supported (http://support.microsoft.com/kb/257757).

Development of the Open XML SDK 2.0 spanned almost two years and involved the release of four Technical Previews in addition to the final release announced today. Your feedback via the blogs, MSDN forums, www.openxmldeveloper.com forums, and Microsoft Connect site helped shape the overall design of the SDK. Thank you so much for your support and feedback! Please feel free to continue sending us feedback with respect to the Open XML SDK.

Learn More about the Open XML SDK

Over the past year and a half, I have shown you guys a lot of real world scenarios/solutions that are built with the SDK. Here is a summary of links that will help you learn more about the Open XML SDK:


Read more: Brian Jones & Zeyad Rajabi: Office Solutions
Download: OpenXML

Posted via email from jasper22's posterous

Установка Windows 7 с флешки, правка дистрибутива Windows 7 с MDT

|
Для начала давайте подготовим наш дистрибутив. Начиная с ОС Windows Vista для правок дистрибутива используется WAIK, это очень мощный продукт, с помощью которого можно провести множество манипуляций, но он не очень простой в использовании. В большинстве случаев рядовому пользователю не нужны все все функции WAIK, именно поэтому было создано приложение MDT которое удобнее и проще чем WAIK. Итак приступим.
Подготовка среды

Чтобы следовать инструкциям этого руководства, вам необходимо настроить следующую среду (или подобную):

   * Контроллер домена для домена contoso.com.
   * DHCP сервер с настроенным границами для аренды адресов клиентским компьютерам.
   * Рабочий компьютер с установленными MDT 2010 и Windows AIK 2.0.

В моей тестовой среде один компьютер под управлением Windows Server 2008 R2 Enterprise x64 выполняет все эти роли.
Создание ресурса установки (Deployment Share)

Открываем Deployment Workbench на рабочем компьютере, правой клавишей нажимаем на узле Deployment Shares и выбираем опцию создания нового ресурса установки New Deployment Share. Запускается мастер создания нового ресурса установки. Нажимаем кнопку Обзор (Browse) и создаем папку под названием DeploymentShare$ в корне диска

Read more: Microsoft User Group Винница

Posted via email from jasper22's posterous

Open Source Android Applications for developers

|
As an Android apps developer, the best case study may be the open source android applications or samples. Below is my memo of open source android applications which I have found in the Internet, hope this will be useful for you.

No.1: Android SDK Samples: The best way to learn how things are done is to look at some code.

Website: http://developer.android.com/resources/samples/index.html

To help Android developers get started quickly, the Android SDK includes a variety of sample code and tutorials that illustrate key concepts and techniques of Android application development. The list below provides a summary of the sample applications that are available with the Android SDK:

1. API Demos
A variety of small applications that demonstrate an extensive collection of framework topics.

2. Bluetooth Chat
An application for two-way text messaging over Bluetooth.

3. BusinessCard
An application that demonstrates how to launch the built-in contact picker from within an activity. This sample also uses reflection to ensure that the correct version of the contacts API is used, depending on which API level the application is running under.
(more...)

Read more: cute androind

Posted via email from jasper22's posterous

Visual Guide to NoSQL Systems

|

There are so many NoSQL systems these days that it's hard to get a quick overview of the major trade-offs involved when evaluating relational and non-relational systems in non-single-server environments. I've developed this visual primer with quite a lot of help (see credits at the end), and it's still a work in progress, so let me know if you see anything misplaced or missing, and I'll fix it.

Without further ado, here's what you came here for (and further explanation after the visual).

Note: RDBMSs (MySQL, Postgres, etc) are only featured here for comparison purposes. Also, some of these systems can vary their features by configuration (I use the default configuration here, but will try to delve into others later).

Read more: Nathan Hurst’s Blog

Posted via email from jasper22's posterous

Using TCP for Low-Latency Applications

|
Last week I ran into a nasty little problem while implementing an application with soft real-time requirements. I was aiming at 1 ms or less for a TCP-based request-response roundtrip on a local network. Should be trivial, but why did my tests indicate that I wasn’t even getting close?

The scenario was simple: A server (my part) gets a request from a client. Before it can answer, it has to ask a backend system for some information. The backend system listens on a TCP port and answers in a query-response fashion (processing time is far below 1 ms). Both query and response typically fit in a single TCP segment. The response may sometimes be larger, which is one reason why TCP was an adequate choice for the backend system.

As a first optimization I used a TCP connection pool to get around TCP’s three-way handshake (SYN, SYN ACK, ACK) and thus cutting down latency. However, tracing showed response times around 40 ms on the local network. Actually worse than without the connection pool! Admittedly, the conventional use for connection pools is to circumvent TCP’s slow start mechanism. But still, something was very wrong.

Read more: Unmaintainable

Posted via email from jasper22's posterous

Microsoft(R) Silverlight™ 4 SDK RC

|
The Microsoft® Silverlight™ 4 SDK RC contains online documentation, online samples, libraries and tools for developing Silverlight 4 applications.
Usage of the SDK is subject to the SDK License (included in the package).    <-- it doesn't have 'Go-Live' license !

Read more: MS Download

Posted via email from jasper22's posterous

Operator Overload

|
נניח שיש לכם את המחלקה הבאה:

class Dolar
{
   public double Value { get; set; }

   public Dolar(double value)
   {
       Value = value;
   }
}

וב - main


Dolar d1 = new Dolar(10);
Dolar d2 = new Dolar(20);

if (d1.Value > d2.Value)
{
}

לכאורה הקוד היה יותר קריא לו יכולנו לכתוב כך


if (d1 > d2)
{
}

כדי לעשות את זה צריך להוסיף למחלקה את הקוד הבא

public static bool operator >(Dolar d1, Dolar d2)
{
   return d1.Value > d2.Value;
}

public static bool operator <(Dolar d1, Dolar d2)
{
   return d1.Value < d2.Value;
}

Read more: שלמה גולדברג

Posted via email from jasper22's posterous

Silverlight at Windows Phone 7

|
image_3B9D260D.png

Microsoft announced today, that new Windows Phone 7 Series will support Silverlight as one of 2 development frameworks. Second development framework will be XNA (will blog about it later).

So, what’s new for Silverlight developers there?

First, we have familiar tools: Windows Phone applications with Silverlight will be developed either with Visual Studio 2010, either with new “express” version called Visual Studio 2010 Express for Windows Phone. This “express” version will enable development with both frameworks (Silverlight and XNA).

Full Visual Studio 2010 will also get new project types to develop with both frameworks.

Read more: DevCorner

Posted via email from jasper22's posterous

SQL Express is not installed properly. Steps to be taken before reinstall again

|
To verify the SQL Server Express instance installed, you could use Microsoft SQL Server 2008 Setup Discovery Report. For more information, please see http://blogs.msdn.com/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

If the Setup Discovery Report doesn’t list the SQL Server Express instance, try the following steps to reinstall it:
1. Make sure you have administrative rights on the computer
2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
3. Backup the registry.
4. Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
7.  Rename all the SQL Server folders in the computer.
8.  Download and install Windows Cleanup Utility:
http://support.microsoft.com/?id=290301
Run the utility and remove any SQL Server components that you find.
9. Reboot the machine
10. Download and install Microsoft .Net Framework 3.5 SP1:
http://www.microsoft.com/downloads/details.aspx?FamilyId=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en
11. Download and install Windows Installer 4.5. (Windows 7 has Windows Installer 4.5)
http://support.microsoft.com/kb/942288
12. Check if the computer has Visual Studio 2008.  If so, you need to install Visual Studio 2008 SP1. For more information, please see http://support.microsoft.com/kb/956139
13. Download  SQL Server 2008 Express Edition Service Pack 1 and install it:
http://www.microsoft.com/downloads/details.aspx?familyid=01AF61E6-2F63-4291-BCAD-FD500F6027FF&displaylang=en

If it still fails, please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft sql server\100\Setup bootstrap\Log\ folder. For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx.

Read more: Nice things inside SQL Server

Posted via email from jasper22's posterous

GBackupSolution - Visual Studio Extension VSX 2008/2010

|
Contents

   * Introduction
   * Features
   * Using the code
         o Create a basic add-in
         o Create a setting class to store your settings
         o Create options page form
         o Create class for backup purpose
         o Getting all item files of a solution
         o Compress all to the backup file.
         o The end.
   * Download and Installation
   * Summary
   * History

Introduction

When searching a way to backup my source code, I found a great application at CodeProject to do this kind of job:

   * Backup2Gmail: Backup Project Files to Gmail

I love the idea of an automated, daily, off-site backup and then send the backup file to Gmail for storing with their amazing services. But I think it’s dangerous to backup your source codes to Gmail without password, and it will save out times more than if this tool were written as an extension of Visual Studio then we can backup any time we want. Therefore, I began to find an add-in which can do the same but the pity is that there’s no add-in like that. BTW, I found some great projects in backing-up your solution to store locally:

   * ProjectZip 1.6: Zip up the source code for your latest CodeProject article
   * ZipStudio: Zip up a Visual Studio solution directly from the Visual Studio Solution Explorer window.
   * SolutionZipper: VS 2005 Add-in Cleans and Zips a Solution in One Step.

In the other hand, one of them does not have some options or features that I usually use for my job so I decided to make a new one. And I also show you how to create an add-in for Visual Studio step-by-step.

Read more: Codeproject

Posted via email from jasper22's posterous

איי הבתולה הבריטיים (BVI – British Virgin Islands)

| Monday, March 15, 2010
איי הבתולה הבריטיים (BVI – British Virgin Islands)


איי הבתולה הבריטיים (BVI – British Virgin Islands) הם קבוצת איים בים הקריבי, אשר שייכים לבריטניה והינה חלק מארכיפלג איי הבתולה. איי הבתולה הבריטיים כוללים 4 איים עיקריים ועוד כ- 50 איים קטנים. אוכלוסיית האיים מונע כ- 22,000 איש ועיר הביה רואוד טאון שוכנת באי הגדול טורטולה.

כלכלה:

איי הבתולה הבריטיים (BVI – British Virgin Islands) הם אחת מקבוצות האיים המשגשגות ביותר. שני מקורות ההכנסה העיקריים ב- BVI הם תיירות ושירותים פיננסיים. 50% מההכנסות של המדינה, מקורם בתעשיית האופשור Offshore ומגיעים מאגרות שונות של רישום חברות זרות הרשומות באי ונהנות מהטבות מס כתוצאה מהיותו של האי אחד ממקלטי המס הנפוצים בעולם  לרישום חברות זרות.

רישום חברות זרות:

צורת הרישום של חברה באיי הבתולה הבריטיים הינה "חברה עסקית בינלאומית" (IBC – International Business Company) ומעוגנות תחת חוק החברות הבינלאומי משנת 1984 וחוק הבנקים והנאמנויות משנת 1990. הליך הרישום של חברות זרות ב- BVI מחייב נציג מקומי וכתובת רשומה בתוך האיים.
שם החברה:


נאסר על החברה להשתמש בשם זהה או דומה לשם של חברה קיימת. יש איסור על שימוש במילים הבאות בשם החברה, למעט בקיום רשיון או הסכמה רשמית של ממשלת איי הבתולה הבריטיים: בנק, נאמנות, נאמנים, ביטוח, ביטחון, ביטוח משנה, בניית הקהילה, חסכונות, הלוואות, לשכת המסחר, אוניברסיטה, קרן עירונית, קרן השקעות ניהולית או כל מילה מקבילה בשפה אחרת.

בעלי מניות:

לחברות זרות ישנה דרישה של לפחות בעל מניות אחד. בעל המניות יכול להיות יחיד או חברה. ב- BVI ישנו חסיון על בעל המניות והוא אינו מופיעה ברשם החברות, כלומר, המידע אינו נגיש לציבור. הרישום של  בעל המניות יופיע רק אצל הנציג המקומי.

דירקטורים:

ישנה דרישה של לפחות דירקטור אחד. הדירקטור אינו חייב להיות מקומי והוא יכול להיות יחיד או חברה.

דו"חות כספיים:

אין צורך בהגשת דוחו"ת כספיים

מיסוי:

חברות זרות הרשומות באיי הבתולה הבריטיים (BVI – British Virgin Islands) נהנות ממס של 0% על הכנסות שמקורם מחוץ לאיים. דיבידנדים וריבית המשולמים לתושבי חוץ פטורים מניכוי מס במקור. אין מס על רווחי הון, על מתנות ומס עזבון. ל- BVI קיימות אמנות מס עם בריטניה, יפן ושוויץ.

ביטויים רלבנטים – הקמת חברה באיי הבתולה,הקמת חברת BVI, רישום חברת

Posted via email from jasper22's posterous

gpkcs11

|
What Is gpkcs11?
It is an implementation of the PKCS #11: Cryptographic Token Interface Standard, that you may freely download and distribute.

This software is only available in source code and is distributed under the GNU Lesser General Public License (LGPL). The source code package also includes an interactive shell that is released under the GNU General Public License (GPL). Please refer to the file README for further explanations. Please note that this software is aimed at developers of applications with cryptographics functions and requires programming expertise to make use of. gpkcs11 is still in development and may lead to loss of data and has potential security holes. TC TrustCenter is not liable to any damages, direct or indirect, that arise through the use of the software.

PKCS#11 defines an interface for the communication of arbitrary applications with systems that perform cryptogrphic operations, like en- and decryption, signing and verifying. These systems, called token, may be Chipcards (with appropriate reader), discrete hardware systems or pure software implementations.

gpkcs11 provides support functions to make the development of support for new tokens easier and contains a complete software token, as well as an automated testing environment. In a later version this software token will be usable as complete and secure tool for cryptographic applications. In this phase gpkcs11 may serve as a testing tool in the development of new applications that contain cryptographic support.

Here you may download the latest version. The code was tested on Solaris 2.5.1/SPARC and successfully compiles on Linux 2.0.36/i386 as well. It should run on other UNIX platforms as well. Only the creation of shared libraries may cause problems. The libtool is used in order to help solve those problems on plattforms where it is supported. Unfortunately we do not have acces to other plattforms, but would be very interested in any reports on your experiences. The development is being done on Windows NT in parallel, and is buildable on it as well.

Starting with version 0.5.6 for the the workspace and project files for Microsofts Visual C++ 6.0 are included. This is a kind of trial balloon. The whole system is not buildable without manual intervention (e.g. you still need the seperate OpenSSL library). But the projects should help build gpkcs11 on Win32.

Read more: gpkcs11

Posted via email from jasper22's posterous

SWIG

|
SWIG is a software development tool that connects programs written in C and C++ with a variety of high-level programming languages. SWIG is used with different types of languages including common scripting languages such as Perl, PHP, Python, Tcl and Ruby. The list of supported languages also includes non-scripting languages such as C#, Common Lisp (CLISP, Allegro CL, CFFI, UFFI), Java, Lua, Modula-3, OCAML, Octave and R. Also several interpreted and compiled Scheme implementations (Guile, MzScheme, Chicken) are supported. SWIG is most commonly used to create high-level interpreted or compiled programming environments, user interfaces, and as a tool for testing and prototyping C/C++ software. SWIG can also export its parse tree in the form of XML and Lisp s-expressions. SWIG may be freely used, distributed, and modified for commercial and non-commercial use.

Read more: SWIG

Posted via email from jasper22's posterous

PKCS Standards and .NET Framework

|
This article will introduce the reader to the Public Key Cryptography Standards (PKCS). The emphasis will be on what is standardized in the PKCS (Public Key Cryptographic Standards) standards and the implementation in .NET 1.1 Framework. This tutorial assumes that the reader is familiar with basic terms in cryptography such as Public Key cryptography, Secret Key cryptography and Message Digest algorithms.

PKCS Standards

The PKCS standards are specifications that were developed by RSA Security in conjunction with system developers worldwide (such as Microsoft, Apple, Sun etc.) for the purpose of accelerating the deployment of public key cryptography. The goal is to facilitate early adoption of these standards by vendors.

These standards are used everywhere in the e-security realm. Any application developer choosing to implement security into his/her application would stumble upon these standards at some point of time. Applications ranging from web browsers to secure email clients depend on the PKCS standards to interoperate with one another. PKCS is defined for both Binary and ASCII messages in an abstract manner giving complete specifications. The representation format for the encoded messages is a preferred format. (The companion documents are ASN.1 = Abstract Syntax Notation 1, BER = Basic Encoding Rules, DER = Distinguish Encoding Rule).

Standards Description

PKCS # 1 The RSA encryption standard. This standard defines mechanisms for encrypting and signing data using the RSA public key system.
PKCS # 3 The Diffie-Hellman key-agreement standard. This defines the Diffie-Hellman key agreement protocol.
PKCS # 5 The password-based encryption standard (PBE). This describes a method to generate a Secret Key based on a password.
PKCS # 6 The extended-certificate syntax standard. This is currently being phased out in favor of X509 v3.
PKCS # 7 The cryptographic message syntax standard. This defines a generic syntax for messages which have cryptography applied to it.
PKCS # 8 The private-key information syntax standard. This defines a method to store Private Key Information.
PKCS # 9 This defines selected attribute types for use in other PKCS standards.
PKCS # 10 The certification request syntax standard. This describes syntax for certification requests.
PKCS # 11 The cryptographic token interface standard. This defines a technology independent programming interface for cryptographic devices such as smartcards.
PKCS # 12 The personal information exchange syntax standard. This describes a portable format for storage and transportation of user private keys, certificates etc.
PKCS # 13 The elliptic curve cryptography (ECC) standard. This describes mechanisms to encrypt and sign data using elliptic curve cryptography.
PKCS # 14 This covers pseudo random number generation (PRNG). This is currently under active development.
PKCS # 15 The cryptographic token information format standard. This describes a standard for the format of cryptographic credentials stored on cryptographic tokens.

Note: PKCS #2 and #4 do not exist anymore because they have been incorporated into PKCS #1.

Read more: Codeproject

Posted via email from jasper22's posterous