The Model-View-Controller (MVC) pattern is an architectural design principle that separates the components of a Web application. This separation gives you more control over the individual parts of the application, which lets you more easily develop, modify, and test them.

ASP.NET MVC is part of the ASP.NET framework. Developing an ASP.NET MVC application is an alternative to developing ASP.NET Web Forms pages; it does not replace the Web Forms model.

You can get the most up-to-date version of the ASP.NET MVC framework from the ASP.NET MVC download page. For information about what is new in this release of MVC, see ASP.NET MVC 3 on the ASP.NET web site.

http://msdn.microsoft.com/en-us/library/gg416514%28v=VS.98%29.aspx

If you read any article that involves editing the registry, you will no doubt see ominous warnings telling you that you can destroy Windows and/or your applications if you edit the registry incorrectly and that you should always make a full system backup before performing a registry modification. While these statements may be true, the fact remains that there are things that you can do by editing the registry that you simply cannot do with the GUI. In this article, I want to share with you 10 handy registry hacks for Windows XP and Vista.

Note: This article is also available as a PDF download.

1: Disable AutoPlay

I always find it a bit annoying to insert a TechNet CD and have Windows open Internet Explorer and display a bunch of information I don’t care about. I would rather just be able to navigate through the disc’s file system and go directly to what I need. Fortunately, it’s easy to create a registry setting that disables AutoPlay:

1. Navigate through the Registry Editor to HKLM\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer.
2. Create a DWORD named NoDriveTypeAutoRun.
3. Set the value to 000000FF.

2: Increase the maximum number of simultaneous downloads

As a technical writer, I’m constantly downloading files. Sometimes I need to download a lot of files, and Windows’ limit on the number of files that can be downloaded simultaneously gets in the way. If you’re in the same boat, you can tweak the registry so that Windows will let you download 10 files at a time:

1. Navigate through the Registry Editor to HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings.
2. Create a new DWORD named MaxConnectionsPerServer and assign it a value of 0000000a.
3. Create a new DWORD named MaxConnectionsPer1_0Server and assign it a value of 0000000a.

3: Change the name of the registered user

When you install Windows, you’re prompted to enter a username and a company name. But since it’s fairly common for companies to merge, you may want to change the name of the company Windows is registered to by using this hack:

1. Navigate through the Registry Editor to HKLM\Software\Microsoft\Windows NT\CurrentVersion.
2. Change the values that are assigned to the RegisteredOwner and RegisteredOrganization keys to reflect the new ownership information.

4: Prevent the Recycle Bin from being deleted

If you’ve ever right-clicked on the Windows Recycle Bin, you know there’s a Delete option, which can be used to get rid of it. If you want to prevent the Recycle Bin from accidental deletion, follow these steps:

1. Navigate through the Registry Editor to HKCR\CLSID\{645FF040-5081-101B-9F08-00AA002F954E}.
2. Create a new registry key called Shell.
3. Create a new registry key named Delete and put it beneath the Shell key. The path should look like this: HKCR\CLSID\{645FF040-5081-101B-9F08-00AA002F954E}\Shell\Delete.
4. Modify the Default key and assign it a value of Recycle Bin.

5: Eliminate cached logons

Windows is designed to allow users to log on using cached logins if no domain controller is available to authenticate the request. If you want to make sure that a login request is always authenticated by a domain controller, you could change the number of cached logons that are allowed from 10 to 0 (or you could increase the number of cached logins allowed to 50). To do so, follow these steps:

1. Navigate through the Registry Editor to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\winlogon.
2. Create a new REG_SZ setting named CachedLogonsCount.
3. Assign this new setting a value that reflects how many concurrent cached logins you want to allow.

6: Encrypt and decrypt from a shortcut menu

Normally, when you want to encrypt or decrypt a file in XP Pro or Vista, you just right-click on the file or folder and choose the Properties command from the shortcut menu. When the properties sheet appears, click the Advanced button on the General tab and then use either the Encrypt or the Decrypt option.

If all that seems like a lot of work, you can add those options to the shortcut menu you see when you right-click on a file:

1. Navigate through the Registry Editor to HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced.
2. Create a new DWORD called EncryptionContextMenu and assign it a value of 1.

7: Delay Windows Activation

Typically, when an organization deploys Vista, it will create a master image, run SYSPREP, and deploy the image. The problem is that it might be a while between the time that SYSPREP is run and when Vista is actually deployed.

Microsoft will allow you to extend the activation period by 30 days, but you can do that only three times. You can, however, use a registry hack to get around this limitation:

1. Navigate through the registry to HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\SL.
2. Change the value associated with the SkipRearm key to 1.
3. Open a Command Prompt window and enter the following command: slmgr -rearm.

8: Relocate your offline files

When you use Vista’s Offline Files feature, the offline file cache is automatically placed on your C: drive. But my laptop has two hard drives in it, and I wanted to configure Vista to place my offline files onto my secondary hard drive. I accomplished the task by following these steps:

1. Open the Control Panel and click on the Network and Internet link, followed by the Offline Files link. Windows will display the Offline Files properties sheet.
2. Disable offline files if they are currently enabled.
3. Click OK and reboot the machine.
4. When the computer reboots, open the Registry Editor and navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC.
5. Create a new string value named Parameters.
6. Assign this value to the Parameters key: \??\e:\csc, where e: is the drive letter you want to use.
7. Exit the Registry Editor and reboot the computer.
8. When the machine reboots, enable offline files.
9. Reboot the computer one last time. Now, you can start making folders available offline.

9: Disable User Account Control

One of the things about Vista that seems to irritate a lot of people is the User Account Control feature. In essence, an administrator is treated as a standard user. Administrators who attempt to perform an administrative action receive a prompt asking whether they initiated the action. I think that this prompt is a valuable safeguard against malware, but since a lot of people don’t like it, here’s how to use the registry editor to suppress the prompt:

1. Navigate through the registry editor to HKLM\Software\Microsoft\Windows\CurrentVersion\Policies\System.
2. Change the value of the ConcentPromptBehaviorAdmin key to 00000000.

10: Don’t display the last user who logged in

Windows Vista is designed so that when you press Ctrl+Alt+Delete to log in, it will display the name of the user who logged in most recently. This can be a bit of a problem if multiple users share a common PC. They may forget to check to see who was logged in previously and key in their own password in association with another user’s login name. If they try this enough times, they could lock the other user out. You can get around this problem by using a simple registry tweak to tell Windows not to display the name of the user who was logged in previously:

1. Navigate through the Registry Editor to HKLM\Software\Microsoft\Windows\CurrentVersion\Policies\System.
2. Set the DontDisplayLastName key to a value of 1.

Your turn…

What problems or annoyances have you overcome with the help of a little registry tweak? Share your favorite hacks below

New desktop users can make plenty of mistakes (as can anyone). But knowing which mistakes to avoid, from the start, helps prevent a LOT of frustration. I’ve handled the topic of mistakes new Linux admins make, but never those of desktop users. Here are some of the most common Linux desktop mistakes I see new users make.

Note: This article is also available as a PDF download.

1: Assuming they are using Windows

Although this might seem way too obvious, it’s not. The average user has no idea there are even different operating systems to be had. In fact, most average users couldn’t discern Windows XP from Vista from 7 (unless they are certain Windows 7 was “their idea”). Because of this, new users might believe that everything works (or doesn’t work, as the case may be) as it does in Windows. Make your end users aware that they are using a different operating system — and that it works differently.

2: Trying to make exe files work

Unless you have done your homework and installed WINE, double-clicking those .exe files simply won’t do anything. And when that happens, your end users are going to be upset. I have seen many an end user download an app made for Windows assuming that it will work for Linux. Make it clear to users that Linux, like Windows, will only run applications made for that operating system. This, of course, is tossed out the window when WINE is involved. But new users won’t be using WINE anyway.

3: Choosing the wrong distribution

One of the biggest problems for users is choosing the wrong distribution. Imagine being a new user and selecting Gentoo or Slackware or Fedora! Yes those are all good distributions, but any of them would send a new user running away in fear. If you are in the initial stages of helping a new user out, do yourselves both a favor and choose the distribution carefully. Consider the user’s ability, needs, and hardware before you make that selection. Don’t just jump on board Ubuntu because everyone says you should. A lot of distributions out there are made specifically for new users. Give them all a close examination before making the choice.

4: Not finding software

Because so many new Linux users are migrating from Windows, they think software can be had from the same channels. Most of the time, this is not the case. The new user needs to become familiar with their package management tools right away – especially tools like Synaptic, Packagekit, and Ubuntu Software Center. Each of those tools is a mecca of software where users can most likely find all the applications they need.

5: Sending OpenOffice documents to Microsoft Office users in the default format

I see this so often. New Linux users are proud of the strides they have made but dumbfounded (and sometimes turned back to Windows) because the people they share files with can’t read their formats. Remember, Microsoft products are not good at getting along with other operating systems and other applications. Make sure your new users are saving in file formats that are readable by the Microsoft equivalents.

6: Avoiding the command line

I can’t, for the life of me, figure out why people completely avoid the command line as if it is the most complex tool there is. I know people who can work absolute magic with Photoshop but can’t seem to type a simple rm command at the command line. Why this is I will never know. New users shouldn’t shy away from the command line. Knowing the command line isn’t essential anymore, but it will make them more capable users.

7: Giving up too quickly

Here’s another issue I see all too often. After a few hours (or a couple of days) working with Linux, new users will give up for one reason or another. I understand giving up when they realize something simply doesn’t work (such as when they MUST use a proprietary application or file format). But seeing Linux not work under average demands is rare these days. If you see new Linux users getting frustrated, try to give them a little extra guidance. Sometimes getting over that initial hump is the biggest challenge they will face.

8: Thinking the Windows directory hierarchy translates to Linux

There is no C:\ in Linux. Nor do you use the “\” character. Nor should you use spaces in filenames. These are common mistakes new users make. Trying to map out Windows to Linux, directory for directory, is impossible. You can get as far as C:\ = / and maybe Default User = ~/, but beyond that you’re out of luck. Make sure new users understand that everything starts at / and their most important directory is their home directory (aka ~/ aka /home/USERNAME/).

9: Skipping updates

I have been burned with Windows updates many times. Need I bother mentioning the update from Explorer 7 to Explorer 8? Very rarely has a Linux update fubar’d a system of mine. In fact, I can’t remember the last time it has. So I am always up to date on my systems… and with good reason. Those updates bring new security patches and features to software and should be applied. Having an installation with a security hole is not what your users need, especially on a machine that houses important information.

10: Logging in as root

I really shouldn’t have to say this. But just in case, be sure to tell your users DON’T LOG IN AS ROOT! But… just in case they must… DON’T LOG IN AS ROOT! Instead, have them open up a terminal window and either “su” to root or use “sudo”. And just in case you didn’t hear me the first time, DON’T LOG IN AS ROOT!

11: Losing windows to the pager

The pager is one of the handiest features of the Linux desktops. But over and over, I’ve seen that new users don’t quite understand what the pager is for and what it does. Because of this, they will “lose” their windows from the desktop. Where did it go? It was there a moment ago! I guess it crashed. No. More than likely, they moved it to another desktop. Another desktop? You see where this is going? Help the new user understand what the pager is and how useful it can be.

12: Ignoring security because it’s Linux

A big part of me still wants to boast and say, “In the 12 years I have used Linux, I have never once had a virus or worm or been hacked.” Although that is true, it doesn’t mean I should ignore security. I have witnessed the effects of a rootkit on a Linux machine. They aren’t pretty and data will be lost. Tell your users that they can’t ignore security just because they’re using Linux. Security is crucial, regardless of the OS

sumber : http://blogs.techrepublic.com.com/10things/?p=1507&tag=nl.e101

Aneh sekali ketika saya baru pake VS 2010 Express ternyata ada masaberlakunya sampai 30 hari untuk mengeggunakan produk ini, hmmm.. padahal banyak fitur yang sudah lama untuk di coba satu persatu, sayang ya! tetapi ternyata setelah saya mencoba untuk melakukan registrasi akhirnya aku dapat serial Numbernya.

Langkah-langkahnya seperti ini :

1. pilih menu help dan pilih Register Product Setelah install vs 2010 Express

2.  Tekan Obtain a registratuin key online, tetapi proses ini harus punya email di hotmail atau windows live.

3. Setelah proses tersebuu diatas selesai maka akan muncul halaman web yang memberikan SN dan bisa di copy mengggunakan perintah CRTL+C

4. Setelah itu bisa di paste kan kembali di vs 2010

5. Nah baru tekan Register Now, gampang kan? setelah itu nanti akan dapat email untuk data serial number dan petunjuk bagaimana cara melakukan proses registrasi

atau bisa bibaca disini

n case you aren’t familiar with Global Catalog Servers, they are simply domain controllers that have been designated to perform the Global Catalog server role. When you create an Active Directory forest, the first domain controller in the forest is automatically assigned the Global Catalog server roll, because every forest requires at least one Global Catalog server.

The Global Catalog server performs a variety of tasks, both for Windows and for Exchange. Since my primary focus in this article is Exchange Server, I don’t really want to get into the Global Catalog server’s Windows related function. I will tell you though, that if a Global Catalog server is not available, then nobody will be able to log into the domain except for the Administrator.

As you can see, the Global Catalog server performs some critical functions at the Active Directory level, but its role in relation to Exchange Server is just as critical. In order for clients to be able to send and receive mail, both the Outlook client and the Exchange Server must be able to query a global catalog server. Without access to a Global Catalog server, Outlook clients will not be able to open the Global Address List or resolve the e-mail addresses of message recipients within the forest.

Global Catalog Server Placement

Now that I have given you an idea of why Global Catalog servers are so important, let’s talk about placement. Given the fact that any domain controller that’s running Windows 2000 or Windows Server 2003 can be designated to act as a Global Catalog server, it might be tempting to just designate every domain controller to act as a Global Catalog server. In most cases this is a bad idea though. Global Catalog servers produce quite a bit of traffic related to the replication process.

Over the years, Microsoft has released several different guidelines for Global Catalog placement, many of which are contradictory. One set of guidelines states that you should place a Global Catalog Server into any site that contains a server that’s running an application that makes use of port 3268 (the Global Catalog lookup port). Exchange Server is such an application, so if you were to follow this rule, then you would want to place a Global Catalog server into any site that contains an Exchange Server.

Another Microsoft document that I read suggested placing a Global Catalog server into each site, regardless of what the site is used for. I tend to think that this is the best approach, given the critical nature of Global Catalog servers, and the fact that clients make use of the global catalog during the logon process. Microsoft does state however, that a site doesn’t need a Global Catalog server if the site does not contain any servers running Global Catalog dependant applications (such as Exchange), contains fewer than 100 users, and is directly connected to a site that does contain a Global Catalog Server.

Keep in mind that this is a generic guideline though. The recommendations change depending on the size and topology of your network. For example, in large organizations with lots of Exchange mailboxes, it is possible for a Global Catalog server to become overwhelmed. To keep that from happening, Microsoft recommends having one Global Catalog Server for every four mailbox servers. Therefore, if a site contained eight mailbox servers, then you would want to place at least two global catalog servers in that site.

Of course not every network is large enough to have multiple sites. If you have a single site, single domain network, then it is safe to go ahead and designate all of your domain controllers to act as Global Catalog servers. In this type of environment, all of the domain controllers contain full copies of the Active Directory anyway, so the additional resource consumption caused by having multiple Global Catalog servers will be minimal.

Summary

Being that Global Catalog servers are so critically important to the Active Directory and to Exchange, it is important to make sure that your network uses them in an optimal manner. In this article, I have provided some general guidelines to Global Catalog server placement.

Just as doctors specialize in a particular field of medicine, cybercriminals often focus on a single area of technical crime, according to Steven R. Chabinsky, FBI Deputy Assistant Director, Cyber Division. During his keynote address at the GovSec/FOSE Conference in Washington, D.C. last March, Chabinsky outlined 10 specializations the FBI typically sees within the world of cyber crime.

They are:

1. Coders or programmers: “who write the malware, exploits, and other tools necessary to commit the crime;”
2. Distributors or vendors: “who trade and sell stolen data, and act as vouchers of the goods provided by the other specialties;”
3. Techies: “who maintain the criminal infrastructure, including servers, bulletproof ISPs, and encryption; and who often have knowledge of common database languages and SQL servers of course;”
4. Hackers: “who search for and exploit application, system, and network vulnerabilities to gain administrator or payroll access;”
5. Fraudsters: “who create and deploy social engineering schemes, including phishing, spamming, and domain squatting;”
6. Hosters: “who provide “safe” hosting of illicit content servers and sites, often through elaborate botnet and proxy networks;”
7. Cashers: “who control drop accounts and provide those names and accounts to other criminals for a fee, and who also typically control full rings of our eighth category, money mules;”
8. Money mules: who complete “money transfers or wire transfers between bank accounts;”
9. Tellers: “who help with transferring and laundering illicit proceeds through digital currency services and between different world currencies;”
10. Leaders: “They’re the “people-people.” They choose the targets; choose the people they want to work each role; decide who does what, when, and where; and take care of personnel and payment issues.” Many according to Chabinsky don’t have any technical skills.

For a more in-depth explanation of each specialization, you can read the complete text of Chabinsky’s keynote on the FBI Web site.

I was recently asked by a customer if you can do Host Networking in Virtual box with Windows. I know the answer is yes, but I had never actually done it myself. I told the customer yes, and then headed to my lab to verify the steps.

The virtual box documentation is some of the best documentation that I have read. That being said, it gives a brief paragraph on how to make this work in windows. Quite frankly now that I have gotten it working, the paragraph is crystal clear, but before I figured it out, the directions where of no help. Could be my user error, but since I could not find any other documentation on how to do it, I decided to blog about it.

On your host OS, in my case this is windows 2003 server, you need to navigate to your network settings. Here is a snapshot of what mine looks like.

Next you need to start virtual box, create a virtual machine, and create a new host interface. This is all well documented in the directions. I created one called VirtualBox Host Interface 1. I have attached a screen shot for reference.

At this point your windows networking will have a new interface in it.

Now here comes the part that I missed from the documentation. You need to select both your original ethernet connection and the new connection you just made, and then right click and select bridge. You are going to want to make sure you do this step from the console. You will loose network connectivity to the host when you do this.

Once you select bridge, a wizard will run, and create a new bridge connection. You will need to select this new bridge connection and put the network settings you originally had in your ethernet connection into it. This is why you must do it from the console and why you will loose connectivity to the host. Notice how the network control panel now displays a Network Bridge section.

We can now start our virtual machine and it will come up with a host interface and an IP on the local network.

And then the million dollar question. Can you do multiple? You can. Simple repeat the steps to create another Virtual adapter, I have named mine VirtualBox Host Interface 2. In your network settings, right click on it and select add to bridge.

This class is for simplifying and accelerating working with SQL,
using this class is very simple; there is a sample below for this class,
which I hope is useful. You can report bugs, opinions and suggestions to me.
<<DONWLOAD>> << dataAccess.vb >>

 Imports System
 Imports System.IO
 Imports System.Text
 Imports System.Data
 Imports System.Data.SqlClient

 Namespace SqlDataProvider

 ''' <summary>
 ''' This class provides a fast and universal method for accessing SQL Server database.This class cannot be inherited.
 ''' </summary>
 Public NotInheritable Class SqlDatabase

 #Region " Local Property Declarations "

 Dim _connectionString As String

 #End Region

 #Region " Constructor "

 ''' <summary>
 ''' Initializes a new instance of the ADO.SqlDatabase class.
 ''' </summary>
 ''' <param name="connectionString">The connection used to open the SQL Server database.</param>
 Public Sub New(ByVal connectionString As String)
 _connectionString = connectionString
 End Sub

 #End Region

 #Region " Public Properties "

 ''' <summary>
 ''' Gets or sets the string used to open a SQL Server database.
 ''' </summary>
 ''' <returns>The connection string that includes the source database name, and other parameters needed to establish the initial connection.</returns>
 Public Property ConnectionString() As String
 Get
 Return _connectionString
 End Get
 Set(ByVal value As String)
 _connectionString = value
 End Set
 End Property

 #End Region

 #Region " Private Methods "

 Private Sub AssignParameters(ByVal cmd As SqlCommand, ByVal cmdParameters() As SqlParameter)
 If (cmdParameters Is Nothing) Then Exit Sub
 For Each p As SqlParameter In cmdParameters
 cmd.Parameters.Add(p)
 Next
 End Sub

 Private Sub AssignParameters(ByVal cmd As SqlCommand, ByVal parameterValues() As Object)
 If Not (cmd.Parameters.Count - 1 = parameterValues.Length) Then Throw New ApplicationException("Stored procedure's parameters and parameter values does not match.")
 Dim i As Integer
 For Each param As SqlParameter In cmd.Parameters
 If Not (param.Direction = ParameterDirection.Output) AndAlso Not (param.Direction = ParameterDirection.ReturnValue) Then
 param.Value = parameterValues(i)
 i += 1
 End If
 Next
 End Sub

 #End Region

 #Region " ExecuteNonQuery "

 ''' <summary>
 ''' Executes a Transact-SQL statement against the connection and returns the number of rows affected.
 ''' </summary>
 ''' <param name="cmd">The Transact-SQL statement or stored procedure to execute at the data source.</param>
 ''' <param name="cmdType">A value indicating how the System.Data.SqlClient.SqlCommand.CommandText property is to be interpreted.</param>
 ''' <param>The parameters of the Transact-SQL statement or stored procedure.</param>
 ''' <returns>The number of rows affected.</returns>
 Public Function ExecuteNonQuery(ByVal cmd As String, ByVal cmdType As CommandType, Optional ByVal parameters() As SqlParameter = Nothing) As Integer
 Dim connection As SqlConnection = Nothing
 Dim transaction As SqlTransaction = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As Integer = -1
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(cmd, connection)
 command.CommandType = cmdType
 Me.AssignParameters(command, parameters)
 connection.Open()
 transaction = connection.BeginTransaction()
 command.Transaction = transaction
 res = command.ExecuteNonQuery()
 transaction.Commit()
 Catch ex As Exception
 If Not (transaction Is Nothing) Then
 transaction.Rollback()
 End If
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) AndAlso (connection.State = ConnectionState.Open) Then connection.Close()
 If Not (command Is Nothing) Then command.Dispose()
 If Not (transaction Is Nothing) Then transaction.Dispose()
 End Try
 Return res
 End Function

 ''' <summary>
 ''' Executes a Transact-SQL statement against the connection and returns the number of rows affected.
 ''' </summary>
 ''' <param name="spname">The stored procedure to execute at the data source.</param>
 ''' <param name="returnValue">The returned value from stored procedure.</param>
 ''' <param name="parameterValues">The parameter values of the stored procedure.</param>
 ''' <returns>The number of rows affected.</returns>
 Public Function ExecuteNonQuery(ByVal spname As String, ByRef returnValue As Integer, ByVal ParamArray parameterValues() As Object) As Integer
 Dim connection As SqlConnection = Nothing
 Dim transaction As SqlTransaction = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As Integer = -1
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(spname, connection)
 command.CommandType = CommandType.StoredProcedure
 connection.Open()
 SqlCommandBuilder.DeriveParameters(command)
 Me.AssignParameters(command, parameterValues)
 transaction = connection.BeginTransaction()
 command.Transaction = transaction
 res = command.ExecuteNonQuery()
 returnValue = command.Parameters(0).Value
 transaction.Commit()
 Catch ex As Exception
 If Not (transaction Is Nothing) Then
 transaction.Rollback()
 End If
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) AndAlso (connection.State = ConnectionState.Open) Then connection.Close()
 If Not (command Is Nothing) Then command.Dispose()
 If Not (transaction Is Nothing) Then transaction.Dispose()
 End Try
 Return res
 End Function

 #End Region

 #Region " ExecuteScalar "

 ''' <summary>
 ''' Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
 ''' </summary>
 ''' <param name="cmd">The Transact-SQL statement or stored procedure to execute at the data source.</param>
 ''' <param name="cmdType">A value indicating how the System.Data.SqlClient.SqlCommand.CommandText property is to be interpreted.</param>
 ''' <param name="parameters">The parameters of the Transact-SQL statement or stored procedure.</param>
 ''' <returns>The first column of the first row in the result set, or a null reference if the result set is empty.</returns>
 Public Function ExecuteScalar(ByVal cmd As String, ByVal cmdType As CommandType, Optional ByVal parameters() As SqlParameter = Nothing) As Object
 Dim connection As SqlConnection = Nothing
 Dim transaction As SqlTransaction = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As Object = Nothing
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(cmd, connection)
 command.CommandType = cmdType
 Me.AssignParameters(command, parameters)
 connection.Open()
 transaction = connection.BeginTransaction()
 command.Transaction = transaction
 res = command.ExecuteScalar()
 transaction.Commit()
 Catch ex As Exception
 If Not (transaction Is Nothing) Then
 transaction.Rollback()
 End If
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) AndAlso (connection.State = ConnectionState.Open) Then connection.Close()
 If Not (command Is Nothing) Then command.Dispose()
 If Not (transaction Is Nothing) Then transaction.Dispose()
 End Try
 Return res
 End Function

 ''' <summary>
 ''' Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
 ''' </summary>
 ''' <param name="spname">The stored procedure to execute at the data source.</param>
 ''' <param name="returnValue">The returned value from stored procedure.</param>
 ''' <param>The parameter values of the stored procedure.</param>
 ''' <returns>The first column of the first row in the result set, or a null reference if the result set is empty.</returns>
 Public Function ExecuteScalar(ByVal spname As String, ByRef returnValue As Integer, ByVal ParamArray parameterValues() As Object) As Object
 Dim connection As SqlConnection = Nothing
 Dim transaction As SqlTransaction = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As Object = Nothing
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(spname, connection)
 command.CommandType = CommandType.StoredProcedure
 connection.Open()
 SqlCommandBuilder.DeriveParameters(command)
 Me.AssignParameters(command, parameterValues)
 transaction = connection.BeginTransaction()
 command.Transaction = transaction
 res = command.ExecuteScalar()
 returnValue = command.Parameters(0).Value
 transaction.Commit()
 Catch ex As Exception
 If Not (transaction Is Nothing) Then
 transaction.Rollback()
 End If
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) AndAlso (connection.State = ConnectionState.Open) Then connection.Close()
 If Not (command Is Nothing) Then command.Dispose()
 If Not (transaction Is Nothing) Then transaction.Dispose()
 End Try
 Return res
 End Function

 #End Region

 #Region " ExecuteReader "

 ''' <summary>
 ''' Sends the System.Data.SqlClient.SqlCommand.CommandText to the System.Data.SqlClient.SqlCommand.Connection, and builds a System.Data.SqlClient.SqlDataReader using one of the System.Data.CommandBehavior values.
 ''' </summary>
 ''' <param>The Transact-SQL statement or stored procedure to execute at the data source.</param>
 ''' <param name="cmdType">A value indicating how the System.Data.SqlClient.SqlCommand.CommandText property is to be interpreted.</param>
 ''' <param name="parameters">The parameters of the Transact-SQL statement or stored procedure.</param>
 ''' <returns>A System.Data.SqlClient.SqlDataReader object.</returns>
 Public Function ExecuteReader(ByVal cmd As String, ByVal cmdType As CommandType, Optional ByVal parameters() As SqlParameter = Nothing) As IDataReader
 Dim connection As SqlConnection = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As SqlDataReader = Nothing
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(cmd, connection)
 command.CommandType = cmdType
 Me.AssignParameters(command, parameters)
 connection.Open()
 res = command.ExecuteReader(CommandBehavior.CloseConnection)
 Catch ex As Exception
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 End Try
 Return CType(res, IDataReader)
 End Function

 ''' <summary>
 ''' Sends the System.Data.SqlClient.SqlCommand.CommandText to the System.Data.SqlClient.SqlCommand.Connection, and builds a System.Data.SqlClient.SqlDataReader using one of the System.Data.CommandBehavior values.
 ''' </summary>
 ''' <param name="spname">The stored procedure to execute at the data source.</param>
 ''' <param name="returnValue">The returned value from stored procedure.</param>
 ''' <param name="parameterValues">The parameter values of the stored procedure.</param>
 ''' <returns>A System.Data.SqlClient.SqlDataReader object.</returns>
 Public Function ExecuteReader(ByVal spname As String, ByRef returnValue As Integer, ByVal ParamArray parameterValues() As Object) As IDataReader
 Dim connection As SqlConnection = Nothing
 Dim command As SqlCommand = Nothing
 Dim res As SqlDataReader = Nothing
 Try
 connection = New SqlConnection(ConnectionString)
 command = New SqlCommand(spname, connection)
 command.CommandType = CommandType.StoredProcedure
 connection.Open()
 SqlCommandBuilder.DeriveParameters(command)
 Me.AssignParameters(command, parameterValues)
 res = command.ExecuteReader(CommandBehavior.CloseConnection)
 returnValue = command.Parameters(0).Value
 Catch ex As Exception
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 End Try
 Return CType(res, IDataReader)
 End Function

 #End Region

 #Region " FillDataset "

 ''' <summary>
 ''' Adds or refreshes rows in the System.Data.DataSet to match those in the data source using the System.Data.DataSet name, and creates a System.Data.DataTable named "Table."
 ''' </summary>
 ''' <param name="cmd">The Transact-SQL statement or stored procedure to execute at the data source.</param>
 ''' <param>A value indicating how the System.Data.SqlClient.SqlCommand.CommandText property is to be interpreted.</param>
 ''' <param name="parameters">The parameters of the Transact-SQL statement or stored procedure.</param>
 ''' <returns>A System.Data.Dataset object.</returns>
 Public Function FillDataset(ByVal cmd As String, ByVal cmdType As CommandType, Optional ByVal parameters() As SqlParameter = Nothing) As DataSet
 Dim connection As SqlConnection = Nothing
 Dim command As SqlCommand = Nothing
 Dim sqlda As SqlDataAdapter = Nothing
 Dim res As New DataSet
 Try
 connection = New SqlConnection(_connectionString)
 command = New SqlCommand(cmd, connection)
 command.CommandType = cmdType
 AssignParameters(command, parameters)
 sqlda = New SqlDataAdapter(command)
 sqlda.Fill(res)
 Catch ex As Exception
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) Then connection.Dispose()
 If Not (command Is Nothing) Then command.Dispose()
 If Not (sqlda Is Nothing) Then sqlda.Dispose()
 End Try
 Return res
 End Function

 #End Region

 #Region " ExecuteDataset "

 ''' <summary>
 ''' Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the System.Data.DataSet with the specified System.Data.DataTable name.
 ''' </summary>
 ''' <param name="insertCmd">A command used to insert new records into the data source.</param>
 ''' <param name="updateCmd">A command used to update records in the data source.</param>
 ''' <param name="deleteCmd">A command for deleting records from the data set.</param>
 ''' <param name="ds">The System.Data.DataSet to use to update the data source. </param>
 ''' <param>The name of the source table to use for table mapping.</param>
 ''' <returns>The number of rows successfully updated from the System.Data.DataSet.</returns>
 Public Function ExecuteDataset(ByVal insertCmd As SqlCommand, ByVal updateCmd As SqlCommand, ByVal deleteCmd As SqlCommand, ByVal ds As DataSet, ByVal srcTable As String) As Integer
 Dim connection As SqlConnection = Nothing
 Dim sqlda As SqlDataAdapter = Nothing
 Dim res As Integer = 0
 Try
 connection = New SqlConnection(_connectionString)
 sqlda = New SqlDataAdapter
 If Not (insertCmd Is Nothing) Then insertCmd.Connection = connection : sqlda.InsertCommand = insertCmd
 If Not (updateCmd Is Nothing) Then updateCmd.Connection = connection : sqlda.UpdateCommand = updateCmd
 If Not (deleteCmd Is Nothing) Then deleteCmd.Connection = connection : sqlda.DeleteCommand = deleteCmd
 res = sqlda.Update(ds, srcTable)
 Catch ex As Exception
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If Not (connection Is Nothing) Then connection.Dispose()
 If Not (insertCmd Is Nothing) Then insertCmd.Dispose()
 If Not (updateCmd Is Nothing) Then updateCmd.Dispose()
 If Not (deleteCmd Is Nothing) Then deleteCmd.Dispose()
 If Not (sqlda Is Nothing) Then sqlda.Dispose()
 End Try
 Return res
 End Function

 #End Region

 #Region " ExecuteScript "

 ''' <summary>
 ''' Executes a SQL query file against the connection.
 ''' </summary>
 ''' <param name="filename">SQL query file name.</param>
 ''' <param>The parameters of the SQL query file.</param>
 Public Sub ExecuteScript(ByVal filename As String, Optional ByVal parameters() As SqlParameter = Nothing)
 Dim fStream As FileStream = Nothing
 Dim sReader As StreamReader = Nothing
 Dim connection As SqlConnection = Nothing
 Dim command As SqlCommand = Nothing
 Try
 fStream = New FileStream(filename, FileMode.Open, FileAccess.Read)
 sReader = New StreamReader(fStream)
 connection = New SqlConnection(ConnectionString)
 command = connection.CreateCommand()
 connection.Open()
 While (Not sReader.EndOfStream)
 Dim sb As New StringBuilder
 While (Not sReader.EndOfStream)
 Dim s As String = sReader.ReadLine
 If (Not String.IsNullOrEmpty(s)) AndAlso (s.ToUpper.Trim = "GO") Then
 Exit While
 End If
 sb.AppendLine(s)
 End While
 command.CommandText = sb.ToString
 command.CommandType = CommandType.Text
 AssignParameters(command, parameters)
 command.ExecuteNonQuery()
 End While
 Catch ex As Exception
 Throw New SqlDatabaseException(ex.Message, ex.InnerException)
 Finally
 If (Not IsNothing(connection)) AndAlso (connection.State = ConnectionState.Open) Then connection.Close()
 If (Not IsNothing(command)) Then command.Dispose()
 If (Not IsNothing(sReader)) Then sReader.Close()
 If (Not IsNothing(fStream)) Then fStream.Close()
 End Try
 End Sub

 #End Region

 End Class

 End Namespace

WITH set [Male] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “M”)’
set [Female] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “F”)’
member Customer.AggMale as ‘Aggregate([Male])
member Customer.AggFemale as ‘Aggregate([Female])

SELECT {[Measures].[SALES($)]} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM [cubename]

WAP Connection Setting

Silakan ikuti petunjuk berikut ini untuk melakukan pengaturan (setting) konfigurasi Koneksi & WAP di ponsel Smart kamu.

NOKIA 2685 & 6275
1. Ketik *#2769737#
2. Pilih Gateway settings
3. Pilih Server address
4. Pada pilihan IP address 1 ketik 010.017.027.250:08080 kemudian klik OK
5. Pada pilihan IP address 2 ketik 010.017.027.250:09201 kemudian klik OK
6. Silakan keluar dari halama setting ini dengan menekan pilihan “back” atau
tombol lain.
7. Tekan “0? untuk beberapa saat atau pilih menu Mini Browser atau Mobile Web
8. Untuk pertama kali biasanya kamu akan menerima error. Abaikan hal tersebut.
9. Pilih Menu
10. Pilih Advanced
11. Pilih Settings
12. Pilih Homepage
13. Ketik URL: http://wap.smartwap.net kemudian pilih Save.
14. Konfigurasi selesai. Sekarang kamu bisa mengakses dan membuka WAP
Smart Telecom dengan cara menekan “0? untuk beberapa saat atau pilih
menu Mini Browser atau Mobile Web.

Recently, we’ve jumped into the world of multi-dimensional OLAP.  We’re currently using SQL Server Analysis Services which has been great to create the data cubes and Microsoft Sharepoint with Business Scorecard Manager to render the cubes.  The database and cube work wonderfully.  We have had issues with Scorecard Manager 2005 though (namingly, it doesn’t render well to Firefox and since one of our clients is Indiana University who supports Firefox, this becomes an issue for us).

‘*******************************************************************************

http://technet.microsoft.com/en-us/evalcenter/cc442495.aspx?ITPID=wtcfeed

Banyak yang sudah tidak sabar menunggu keluarnya Windows 7 (W7), penerus Windows Vista. Tidak seperti biasanya, Microsoft banyak merahasiakan fitur-fitur baru W7, tetapi semiua kerahasiaan ini telah berakhir, Microsoft memberikan banyak pengembang bocoran-bocoran tentang W7 di PDC. Tehcnologizer yang berkesempatan mencoba W7 mengatakan bahwa kelihatannya OS ini… benar-benar cukup prospektif!

Pertama, Anda harus tahu bahwa W7 tidak akan memiliki perubahan drastis dari segi arsitektur perangkat lunak seperti Vista dari XP — Microsoft sendiri sudah berjanji bahwa pengguna yang meakukan upgrade dari Vista tidak akan menemui masalah kompatibilitas. Karena W7 tidak banyak berubah di belakang layar, Microsoft dapat memfokuskan pengembangan pada pengalaman pemakaian OS itu sendiri dan bukan pada berbagai aspek teknis lain seperti keamanan dan stabilitas.

Sebagian besar perubahan yang dikemas W7 berusaha untuk meningkatkan kemudahan dan kenyamanan pengguna, dan di bawah ini adalah beberapa dari fitur-fitur baru W7 yang sudah terlihat di demonstrasi PDC Microsoft.

2. Taskbar

Mendapat perubahan terbesar sejak pertama kali debut di Windows 95. Windows 7 sudah tidak akan lagi menampilkan ikon aplikasi kecil lengkap dengan nama aplikasi melainkan hanya ikon berukuran besar mirip dengan Mac OS X. Daftar jendela yang ditampilkan saat menempatkan tetikus di atas ikon aplikasi juga diganti dengan user interface (UI) “ribbon” yang menampilkan thumbnail jendela yang terbuka secara menyamping.

Alat-alat lain yang terhubung ke komputer seperti kamera juga akan muncul di taskbar bersama jendela aplikasi. Secara keseluruhan fitur ini membuat Windows 7 tampil menarik.

3. System Tray

Secara resmi dinamakan sebagai “Notification Area,” Microsoft akhirnya memungkinkan pengguna alat-alat untuk menata area desktop yang sering berantakan ini. Pengguna dapat memiliki ikon apa saja yang ditampilkan di System Tray, mengubah posisi ikon dan apakah mereka diperbolehkan menarik perhatian pengguna dengan notifikasi.

4. Jump List

Menu jump list akan muncul di Start Menu atau saat pengguna melakukan klik di salah satu aplikasi Taskbar, memberikan beberapa pilihan pada pengguna untuk melakukan berbagai aksi yang didukung aplikasi. Gambar di bawah ini memperlihatkan jump list Windows Media Player (WMP) yang memberikan opsi pada pengguna untuk memutar lagu, melihat lagu-lagu terakhir yang diputar dan banyak lagi.

5. User Account Control (UAC) yang Lebih Baik

UAC merupakan salah satu fitur yang paling dibenci pengguna Windows Vista. Kini selain pilihan “On” dan “Off,” pengguna dapat memilih agar UAC hanya muncul saat instalasi aplikasi atau saat sebuah aplikasi mengubah konfigurasi Windows saja. Belum diketahui apakah perubahan ini cukup untuk menjadikan UAC dari musuh menjadi teman, tetapi perubahan ini setidaknya akan menjadikan UAC Windows lebih ramah.

6. Kinerja

Microsoft mengatakan bahwa mereka banyak melakukan perubahan untuk meningkatkan kinerja dan stabilitas Windows 7 seperti mengurangi waktu boot dengan mengaktifkan beberapa aplikasi secara parallel, metode manajemen memori baru dan banyak lagi. Saat ini masih terlalu dini untuk membicarakan kinerja, kita harus menunggu datangnya versi yang sudah hampir rampung untuk mendapatkan benchmark yang berarti, tetapi menurut Technologizer, Windows 7 terasa sangat cepat dioperasikan di laptop Dell yang dipinjamkan Microsoft — dan bersih dari bloatware.

7. Device Stage

Fitur baru ini mengumpulkan semua hal yang berhubungan dengan peripheral di satu tempat untuk memudahkan pengguna seperti konfigurasi, fitur, dokumentasi bahkan layanan pembelian tinta printer dan lain-lain.

8. Libraries

Apabila Anda sudah mengenal konsep library untuk lagu seperti yang dimiliki iTunes, konsep library di Windows 7 juga tidak akan asing bagi Anda. Fitur ini mengumpulkan semua file dalam PC Anda berdasarkan tipe ke dalam library masing-masing untuk memudahkan manajemen media. Sebagai contoh, semua foto dari semua PC dan jaringan akan dikumpulkan di sebuah library foto yang dapat diakses di satu tempat seperti gambar di bawah ini.

9. HomeGroups

Windows 7 memperkenalkan fitur jaringan baru bernama HomeGroups yang bertujuan untuk memudahkan beberapa komputer satu jaringan untuk saling berbagi file dan peripheral — seolah-olah semua itu terletak pada satu PC yang sama. Walaupun fitur-fitur Windows Networking sejak dulu selalu bertujuan sama, pada kenyataannya konfigurasi untuk menggunakan printer jaringan masih tetap terlalu sulit untuk sebagian besar pengguna.

10. “Peeking” (Mengintip)

Fitur peeking pada Windows 7 memudahkan pengguna untuk dengan cepat membaca konten dalam satu jendela tanpa perlu berinteraksi dengan jendela tersebut. Menempatkan tetikus di atas thumbnail jendela di Task Bar akan mengubah semua jendela yang terbuka menjadi transparan kecuali jendela yang dipilih. Selain dapat “mengintip” jendela aplikasi tertentu pengguna juga dapat mengintip desktop Windows.

11. Sidebar Tidak Lagi Digunakan

Jika dibandingkan dengan widget Mac OS X yang dapat ditempatkan di desktop, perbedaan paling mencolok dari gadget Microsoft adalah peletakannya pada sidebar di sebelah kanan layar. Di W7, sidebar tersebut dihilangkan karena dianggap terlalu banyak menggunakan tempat yang ada dan gadget kini dapat diletakkan langsung di desktop. Walaupun hal ini juga sebenarnya dapat dilakukan di Vista.

12. Kompatibilitas iTunes

WMP kini mendukung dua format media favorit Apple: AAC untuk audio dan H.264 untuk video. WMP ini juga dapat menemukan library iTunes yang ada pada jaringan dan memutar isinya. Fairplay DRM Apple tidak didukung, tetapi entah kenapa memutar sebuah video podcast yang beresolusi lumayan terlihat buruk di WMP.

13. WMP Minimalis

Ketika Anda melakukan klik kanan pada sebuah file media di Windows Explorer dan menggunakan WMP untuk memutarnya, WMP akan muncul dalam mode minimalis yang tidak mendominasi desktop Anda. Anda juga bisa memutar media pada preview pane Windows Explorer tanpa perlu meluncurkan WMP sama sekali.

14. Streaming Multimedia

W7 menambahkan fitur pengiriman file media dari PC ke berbagai alat yang mendukung streaming seperti sistem musik Sonos melalui jaringan. Microsoft mengatakan bahwa W7 akan mengubah file ke dalam format sehingga dapat diputar oleh pemutar media Anda. Hal ini juga berarti Microsoft sudah selangkah lagi mendekati cita-cita Bill Gates menjadikan Windows pusat media di rumah. Versi Media Center dari Windows 7 juga mendapatkan upgrade besar.

15. Pengaturan Jendela Otomatis

Geser jendela mendekat tepi kanan atau kiri maka jendela tersebut akan langsung berubah ukuran menjadi setengah layar. Hal ini ditujukan untuk memudahkan Anda menyusun dua jendela secara berdampingan (seperti browser atau dokumen Word) agar Anda dapat dengan mudah bekerja pada kedua jendela sekaligus.

16. Mencari Semua Tempat Sekaligus

Fitur W7 bernama “Search Federation” memungkinkan Anda untuk mengikutkan berbagai komputer, media penyimpanan jaringan dan situs ke dalam pencarian Windows 7.

17. Tema

Microsoft sudah sangat lama sekali tidak mengantarkan perubahan besar pada fitur kustomisasi tema di Windows. Di W7 Microsoft menyediakan sebuah pemilih tema baru yang lebih baik dengan fitur preview dalam ukuran asli dan memungkinkan Anda untuk menyimpan tema kustom hanya dengan dengan beberapa klik. Microsoft juga berencana untuk mengganti namanya dari Themes menjadi Styles.

18. Windows Live

Secara resmi Microsoft memiliki mengemas sedikit sekali aplikasi pada W7, tidak seperti Vista. Aplikasi Photo Gallery, Movie Maker dan email telah dijadikan unduhan gratis yang disebut Windows Live Esentials, walaupun Microsoft tetap berharap berbagai vendor PC tetap akan mengemas Windows Live Essentials ke dalam komputer yang mereka jual.

19. Paint Baru

Windows Paint yang sudah banyak terlupakan mendapatkan upgrade besar, kini tampil dengan UI ribbon dari Office 2007 yang sekarang telah menjadi standar di berbagai aplikasi Microsoft. Walaupun masih banyak yang menganggap Paint.net sebagai alternatif pengganti Paint yang lebih baik.

20. Fitur Layar Sentuh

Windows 7 adalah versi Windows pertama yang mendukung multi-touch yang memungkinkan Anda mengendalikan OS ini dengan kedua tangan. Masih banyak yang ragu apakah multi-touch akan merevolusi dunia PC sebagaimana ia merevolusi dunia ponsel. Saat ini hampir tidak ada PC yang beredar di pasar yang mendukung fitur layar sentuh selain TouchSmart dari HP dan Latitude XT dari Dell. (via Technologizer)

http://udaramaya.com/berita/4657/0/20_Fitur_Baru_Windows_7

1. World-Class Web and Application Platform
   A secure, easy-to-manage platform for developing reliable hosting applications and services.
2. Improved Networking Performance
   Take full advantage of today’s multi-gigabit networks, and secure and control the flow of network traffic.
3. Enhanced Security and Compliance
   Developed from the ground up for security, helping you adhere to the strictest IT compliance standards. Plus, Network Access Protection helps ensure that any computer connecting to the network meets corporate policy for “healthy” requirements.
4. Maximized OS Cycle
   By migrating to Windows Server 2008 now, you can maximize the operating system cycle and take full advantage of the financial and technical benefits of the new functionality.
5. Control Over Your Remote Infrastructure
   Streamline the management of your remote infrastructure with enhancements to Active Directory, including Read-Only Domain Controllers and administrative role separation.
6. Simplified Server Management
   The Server Management Console provides a single, unified tool for managing your server’s configuration, displaying status, and managing roles.
7. Superior Scripting and Task Automation
   Automate common tasks and easily control system administration.
8. Presentation Virtualization
   Secure access to internal applications through firewall-friendly ports.
9. Windows Server 2008 with Hyper-V
   Hyper-V virtualization technology helps you increase system availability for production server consolidation, disaster recovery, and end-to-end management of dynamic data centers. You can also run a legacy OS, such as Windows 2000, on the latest platforms as a virtual instance to avoid compatibility issues.
10. The Power of Windows Vista^®
    Windows Server 2008 and Windows vista share a number of technologies across networking, storage, security, and management.

http://www.dell.com/content/topics/global.aspx/sitelets/solutions/main/10_reasons_for_ws2008?c=us&cs=555&l=en&s=biz

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42

Virus
Inilah istilah yang sering dipakai untuk seluruh jenis perangkat lunak yang mengganggu computer. Bisa jadi karena inilah tipe malware pertama yang muncul.
Virus bisa bersarang di banyak tipe file. Tapi boleh dibilang, target utama virus adalah file yang bisa dijalankan seperti EXE, COM dan VBS, yang menjadi bagian dari suatu perangkat lunak. Boot sector juga sering dijadikan sasaran virus untuk bersarang. Beberapa file dokumen juga bisa dijadikan sarang oleh virus.
Penyebaran ke komputer lain dilakukan dengan bantuan pengguna komputer. Saat file yang terinfeksi dijalankan di komputer lain, kemungkinan besar komputer lain itu akan terinfeksi pula. Virus mencari file lain yang bisa diserangnya dan kemudian bersarang di sana.
Bisa juga virus menyebar melalui jaringan peer-to-peer yang sudah tak asing digunakan orang untuk berbagi file.

Worm
Worm alias cacing, begitu sebutannya. Kalau virus bersarang pada suatu program atau dokumen, cacing-cacing ini tidak demikan. Cacing adalah sebuah program yang berdiri sendiri dan tidak membutuhkan sarang untuk menyebarkan diri.
Hebatnya lagi, cacing bisa saja tidak memerlukan bantuan orang untuk penyebarannya. Melalui jaringan, cacing bisa “bertelur” di komputer-komputer yang terhubung dalam suatu kerapuhan (vulnerability) dari suatu sistem, biasanya sistem operasi.
Setelah masuk ke dalam suatu komputer, worm memodifikasi beberapa pengaturan di sistem operasi agar tetap hidup. Minimal, ia memasukkan diri dalam proses boot suatu komputer. Lainnya, mungkin mematikan akses ke situs antivirus, menonaktifkan fitur keamanan di sistem dan tindakan lain.

Wabbit
Istilah ini mungkin asing, tapi memang ada malware tipe ini. Seperti worm, wabbit tidak membutuhkan suatu program dan dokumen untuk bersarang.
Tetapi berbeda dengan worm yang menyebarkan diri ke komputer lain menggunakan jaringan, wabbit menggandakan diri secara terus-menerus didalam sebuah komputer lokal dan hasil penggandaan itu akan menggerogoti sistem.
Kinerja komputer akan melambat karena wabbit memakan sumber data yang lumayan banyak. Selain memperlambat kinerja komputer karena penggunaan sumber daya itu, wabbit bisa deprogram untuk memiliki efek samping yang efeknya mirip dengan malware lain. Kombinasi-kombinasi malware seperti inilah yang bisa sangat berbahaya.

Keylogger
Hati-hati kalau berinternet di warnet. Bisa saja pada komputer di warnet itu diinstall suatu perangkat lunak yang dikenal dengan istilah keylogger yang mencatat semua tekanan tombol keyboard.
Catatan yang disimpan dalam suatu file yang bisa dilihat kemudian itu lengkap. Di dalamnya bisa terdapat informasi seperti aplikasi tempat penekanan tombol dilakukan dan waktu penekanan. Dengan cara ini, seseorang bisa mengetahui username, password dan berbagai informasi lain yang dimasukkan dengan cara pengetikan.
Pada tingkat yang lebih canggih, keylogger mengirimkan log yang biasanya berupa file teks itu ke seseorang. Tentu saja itu dilakukan tanpa sepengetahuan si korban. Pada tingkat ini pula keylogger bisa mengaktifkan diri ketika pengguna komputer melakukan tindakan tertentu.
Misalnya begini. Ketika pengguna komputer membuka situs e-banking, keylogger aktif dan mencatat semua tekanan pada keylogger aktif dan mencatat semua tekanan pada keyboard aktif dan mencatat semua tekanan pada keyboard di situs itu dengan harapan nomor PIN dapat dicatat.
Keylogger ini cukup berbahaya karena secanggih apa pun enkripsi yang diterapkan oleh suatu website, password tetap dapat diambil. Pasalnya, password itu diambil sebelum sempat dienkripsi oleh system. Jelas dong. Keylogger merekam sesaat setelah password diketikkan dan belum diproses oleh system.

Browser Hijacker
Browser hijacker mengarahkan browser yang seharusnya menampilkan situs yang sesuai dengan alamat yang dimasukkan ke situs lain.
Itu contoh paling parah dari gangguan yang disebabkan oleh browser hijacker. Contoh lain yang bisa dilakukan oleh pembajak ini adalah menambahkan bookmark, mengganti home page, serta mengubah pengaturan browser.
Bicara mengenai browser di sini boleh yakin 100% browser yang dibicarakan adalah internet explorer. Selain karena internet explorer adalah buatan Microsoft, raksasa penghasil perangkat lunak yang produknya sering dijadikan sasaran serangan cracker, internet explorer adalah browser yang paling banyak digunakan orang berinternet. Tak heran, internet explorer telah menyatu dengan Windows, sistem operasi milik Microsoft yang juga banyak diserbu oleh cracker.

Trojan Horse
Kuda Troya adalah malware yang seolah-olah merupakan program yang berguna, menghibur dan menyelamatkan, padahal di balik itu, ia merusak. Kuda ini bisa ditunggangi oleh malware lain seperti seperti virus, worm, spyware. Kuda Troya dapat digunakan untuk menyebarkan atau mengaktifkan mereka.

Spyware
Spyware adalah perangkat lunak yang mengumpulkan dan mengirim informasi tentang pengguna komputer tanpa diketahui oleh si pengguna itu.
Informasinya bisa yang tidak terlampau berbahaya seperti pola berkomputer, terutama berinternet, seseorang sampai yang berbahaya seperti nomor kartu kredit, PIN untuk perbankan elektronik (e-banking) dan password suatu account.
Informasi tentang pola berinternet, telah disebutkan, tidak terlampau berbahaya. Situs yang dikunjungi, informasi yang kerap dicari, obrolan di ruang chat akan dimata-matai oleh si spyware.
Selanjutnya, informasi itu digunakan untuk menampilkan iklan yang biasanya berupa jendela pop-up. Iklan itu berhubungan dengan kebiasaan seseorang berinternet. Misalnya kerap kali seseorang mencari informasi mengenai kamera digital. Jendela pop-up yang muncul akan menampilkan, misalnya situs yang berdagang kamera digital. Adware adalah istilah untuk spyware yang begini.
Penyebaran spyware mirip dengan Trojan. Contohnya, flashget. Ketika flashget yang dipakai belum diregister, flashget bertindak sebagai spyware. Coba saja hubungkan diri ke internet, jalankan flashget yang belum diregister, cuekin computer beberapa saat, pasti muncul jendela internet explorer yang menampilkan iklan suatu situs.

Backdoor
Sesuai namanya, ini ibarat lewat jalan pintas melalui pintu belakang.
Dengan melanggar prosedur, malware berusaha masuk ke dalam sistem untuk mengakses sumber daya serta file. Berdasarkan cara bekerja dan perilaku penyebarannya, backdoor dibagi menjadi 2 grup. Grup pertama mirip dengan Kuda Troya. Mereka secara manual dimasukkan ke dalam suatu file program pada perangkat lunak dan kemudian ketika perangkat lunak itu diinstall, mereka menyebar. Grup yang kedua mirip dengan worm. Backdoor dalam grup ini dijalankan sebagai bagian dari proses boot.
Ratware adalah sebutan untuk backdoor yang mengubah komputer menjadi zombie yang mengirim spam. Backdoor lain mampu mengacaukan lalu lintas jaringan, melakukan brute force untuk meng-crack password dan enkripsi., dan mendistribusikan serangan distributed denial of service.

Dialer
Andaikata komputer yang digunakan, tidak ada hujan atau badai, berusaha menghubungkan diri ke internet padahal tak ada satu pun perangkat lunak yang dijalankan membutuhkan koneksi, maka layaklah bercuriga. Komputer kemungkinan telah terjangkit oleh malware yang terkenal dengan istilah dialer.
Dialer menghubungkan computer ke internet guna mengirim kan informasi yang didapat oleh keylogger, spyware tahu malware lain ke si seseorang yang memang bertujuan demikian. Dia dan penyedia jasa teleponlah yang paling diuntungkan dengan dialer ini.

Exploit dan rootkit
Kedua perangkat ini bisa dibilang malware bisa pula tidak. Kenapa begitu? Penjelasannya kira-kira begini.
Exploit adalah perangkat lunak yang menyerang kerapuhan keamanan (security vulnerability) yang spesifik namun tidak selalu bertujuan untuk melancarkan aksi yang tidak diinginkan. Banyak peneliti keamanan komputer menggunakan exploit untuk mendemonstrasikan bahwa suatu sistem memiliki kerapuhan.
Memang ada badan peneliti yang bekerja sama dengan produsen perangkat lunak. Peneliti itu bertugas mencari kerapuhan dari sebuah perangkat lunak dan kalau mereka menemukannya, mereka melaporkan hasil temuan ke si produsen agar si produsen dapat mengambil tindakan.
Namun begitu exploit kadang menjadi bagian dari suatu malware yang bertugas menyerang kerapuhan keamanan.
Berbeda dengan exploit yang secara langsung menyerang system, rootkit tidak demikian. Rootkit dimasukkan ke dalam komputer oleh penyerang setelah computer berhasil diambil alih.
Rootkit berguna untuk menghapus jejak penyerangan, seperti menghapus log dan menyembunyikan proses malware itu sendiri. Rootkit juga bisa mengandung backdoor agar di hari depan nanti, si penyerang bisa kembali mengambil alih system.
Rootkit ini sulit di deteksi, pasalnya rootkit ditanam pada system operasi di level kernel, level inti sistem operasi.
Cara terbaik yang bisa diandalkan untuk mendeteksi ada tidaknya rootkit di komputer adalah dengan mematikan komputer dan boot ulang tidak dengan harddisk melainkan dengan media lain seperti CD-ROM atau disket USB. Rootkit yang tidak berjalan tak dapat bersembunyi dan kebanyakan antivirus dapat mengidentifikasikannya.
Produsen perangkat keamanan biasanya telah mengintegrasikan pendeteksi rootkit di produknya. Meskipun rootkit di menyembunyikan diri selama proses pemindaian berjalan, antivirus masih bisa mengenalinya. Juga bila rootkit menarik diri dari system untuk sementara, antivirus tetap dapat menemukannya dengan menggunakan deteksi “sidik jari” alias byte unik dari rootkit.
Rootkit memang cerdik. Dia bisa menganalisis proses-proses yang sedang berjalan. Andai ia mencurigai suatu proses sebagai tindak tanduk antivirus, ia bisa menyembunyikan diri. Ketika prose situ selesai, ia aktif kembali.
Ada beberapa program yang bisa dipakai untuk mendeteksi adanya rootkit pada system. Rootkit detector kit, chkrootkit dan Rkhunter adalah contoh yang bisa digunakan.

Goblok.. jadi :
begitu liar,
begitu berani,
begitu indah,
begitu natural,
begitu wajar,
begitu PINTAR??? tuk diungkap…

Resensi Buku Best Seller “Guru Goblok ketemu Murid Goblok”
Harian Jawa POS. Minggu, 13 Juli 2008
Judul buku : Guru Goblok Ketemu Murid Goblok Hikmah Pembakar Jiwa
Entrepreneur dan Investor
Penulis: Iman Supriyono (M33, buku ke-7)
Penerbit: SNF Consulting, Surabaya
( www.snfconsulting. com )
Cetakan: I, Mei 2008
Cetakan II, Juli 2008
Tebal : 264 Halaman
Resensi oleh: Abd. Sidiq Notonegoro

GOBLOK, ENJOY AJA!
Sangat banyak di negeri ini orang yang sesungguhnya pantas disebut sebagai orang goblok, tetapi tidak pernah mau untuk mengakui kegoblokannya. Apalagi sampai dengan menyadari bahwa dirinya benar-benar goblok. Mengapa demikian? Memang sangat memerahkan telinga dan pasti ingin melakukan tindakan-tindakan yang benar-benar
”goblok”– apabila ada yang menyematkan identitas pada diri dengan panggilan ”orang goblok”.

Meskipun demikian, di balik sangat banyaknya orang goblok yang emoh disebut sebagai orang goblok, masih ada sebagian kecil orang yang sudi untuk mengakui dan menyadari bahwa dirinya memang goblok. Bahkan mereka tampak enjoy untuk menyebut dan disebut sebagai orang goblok.
Mengapa pula demikian? Karena dengan memproklamasikan diri sebagai ”orang goblok”, mereka mampu melapangkan jalan kesempatan yang luas dan panjang untuk selalu belajar dan belajar.

Salah satu manusia langka yang tidak malu untuk mendeklarasikan diri sebagai ”orang goblok” adalah Iman Supriyono (dan gurunya, Abdul Rachim). Dengan kesadarannya yang sangat dalam sebagai orang goblok, akhirnya buku Guru Goblok Ketemu Murid Goblok ini pun lahir. Hebatnya lagi, buku Iman Supriyono yang (merasa) goblok ini merupakan karya buku ke-7. Hebat kan, orang goblok bisa menulis buku, sampai tujuh lagi. Padahal yang selama ini mengaku ”pinter” saja banyak yang tidak mampu menggoreskan satu pun kalimat bermakna, dan selalu marah kalau dipanggil ”goblok”.

Tapi Iman Supriyono dan gurunya bukanlah orang ”goblok” yang sembarang goblok. Mereka adalah jenis manusia ”goblok” khusus. Menurutnya, kegoblokan manusia itu dapat dipilah menjadi tiga tingkatan. Yakni, orang goblok yang masih menyadari bahwa dirinya goblok. Goblok tingkat pertama ini bahkan menurut Iman Supriyono merupakan goblok yang disarankan. Seseorang boleh saja (dan bahkan harus) merasa goblok. Syaratnya, masih menyadari bahwa dirinya goblok dan kemudian mau belajar terus. Bahkan setiap saat kita harus merasa goblok. Maksudnya? Setiap saat merasa ada sesuatu yang kita ingin bisa tetapi belum bisa. Tindak lanjutnya dengan belajar hingga bisa.
Begitu bisa, segera temukan apa lagi yang belum bisa. Temukan satu kegoblokan lagi. Demikian seterusnya. Selalu goblok (hlm. 83). Inilah yang disebut sebagai ”goblok dinamis” atau goblok yang beruntung.

Sedangkan tingkatan kedua, orang goblok yang tidak menyadari bahwa dirinya goblok. Orang goblok jenis ini tidak akan pernah berkembang (stagnan). Inilah yang juga bisa disebut dengan ”goblok statis”, karena membiarkan diri untuk tetap goblok dalam satu hal selamanya.

Dan, tingkatan ketiga, orang goblok yang tidak merasa dirinya goblok dan bahkan suka menggoblok-goblokka n orang lain. Inilah jenis manusia yang terjangkiti penyakit goblok total, goblok sempurna, goblok absolut. Orang goblok absolut ini bila dinasehati tentang kegoblokannya, serta merta ia menolak. Bahkan merasa dirinya lebih pintar dari orang yang menasehatinya. Inilah jenis manusia yang merasa pintar padahal goblok. Karena itu, Iman Supriyono mewanti wanti agar kita tidak termasuk golongan orang yang goblok jenis ini.
Bahaya !!! (hlm. 84).

Tetapi, untuk menjadi ”goblok dinamis” pun membutuhkan kecerdasan yang berlipat. Untuk belajar menumbuhkan kesadaran sebagai orang goblok, dibutuhkan seorang guru yang bisa mendidik untuk bisa merasa goblok. Nah, guru jenis ini pun ternyata juga sangat langka. Sebab yang banyak ialah guru yang menuntut muridnya pintar dan cenderung menyisihkan murid yang bergaya goblok. Sang guru kerapkali juga tidak mau dikalahkan oleh muridnya, sehingga dia sendiri pun kemudian menjadi sok pintar dan keminter.

Karena itulah, Iman Supriyono pantas merasa bersyukur karena bisa bertemu dan mendapatkan guru yang sudi mendidiknya untuk bisa merasa goblok. Lebih dari itu, Pak Rohim –yang diklaimnya sebagai guru (dalam buku ini) rela untuk menggoblokkan dirinya yang tidak pernah bosan untuk mendidik dan bahkan memberi kepercayaan terhadap murid-muridnya yang goblok.

Dengan tempaan guru gobloknya, akhirnya Iman Supriyono yang saat ini merupakan konsultan senior di SNF Consulting tidak pernah berhenti untuk terus merasa goblok. Salah satu bukti kesadaran akan kegoblokan
dirinya ialah tentang mimpinya untuk bisa membuat kantor konsultan yang bisa dipercaya perusahaan-perusaha an kelas dunia. Akan tetapi hingga saat ini belum tercapai. Belum bisa. Goblok. Dan, karena itu, ia tidak akan pernah berhenti untuk mengentaskan diri dari ambisi goblok tersebut hingga mimpinya jadi kenyataan.

Memperhatikan semangat Iman Supriyono yang meledak-ledak untuk membakar jiwa entrepreneur dan investor ini, maka kehadiran buku perlu menjadi pegangan wajib bagi mereka yang ingin melepaskan diri dari kegoblokan statis dan bahkan kegoblokan absolut. Bahkan tidak hanya bagi mereka yang sedang ingin mengembangkan usaha bisnis jasa
saja, tetapi juga para pendidik (guru dan dosen) yang selalu merasa sok lebih pandai dari murid atau mahasiswanya. Teladan Pak Rohim yang selalu merasa sebagai guru goblok perlu diwarisi para pemegang kunci gerbang duni akademis.

Ada banyak kelebihan dari buku ini. Bahasa yang digunakan sangat mengalir dan enak untuk dibaca saya seperti sedang membaca sebuah novel. Selain itu, sentilan-sentilan pedas tidak justru membuat kita marah dan menutup buku. Tapi sebaliknya, justru kian bernafsu untuk menuntaskannya. Tidak ada kata lain untuk memuaskan rasa penasaran di balik judul buku yang terkesan ”melecehkan’ ‘ itu, kecuali membaca isinya. Karena hanya orang-orang goblok absolut saja yang pasti enggan untuk menikmati buku ini. (*)

The CODE
This article is based on SQL Server 2008 CTP 3. Some of the information may change by the time the product is finally released.

Before we create a Function or Stored Procedure that accepts a TABLE variable, we need to define a User Defined TABLE Type. SQL Server 2008 introduced a new User defined TABLE type. A TABLE type represents the structure of a table that can be passed to a stored procedure or function.

So the first step is to create a User Defined TABLE type. The following TSQL code creates a User defined TABLE type named “ItemInfo”.

1 CREATE TYPE ItemInfo AS TABLE
2 (
3 ItemNumber VARCHAR(50),
4 Qty INT
5 )

You can use the system view SYS.TYPES to see the type that you have just created. The following query returns all the types defined in the system.

1 SELECT * FROM SYS.TYPES
2
3 /*
4 If you just need to find information about the TABLE types, you could find it from
5 the following TSQL query.
6 */
7
8 SELECT * FROM SYS.TYPES WHERE is_table_type = 1
9
10 /*
11 There is another view, which is handy to find information about TABLE types.
12 */
13
14 SELECT * FROM SYS.TABLE_TYPES

We have created a TABLE type that we need. Now let us see how it works. Let us create a variable of type “ItemInfo” and try to insert a few records to it. Then lets query the table variable to see if the information is correctly inserted. [code]

1 /*
2 Let us declare a variable of type ItemInfo which is a TABLE Type
3 */
4 DECLARE @items AS ItemInfo
5
6 /*
7 Insert values to the variable
8 */
9
10 INSERT INTO @Items (ItemNumber, Qty)
11 SELECT '11000', 100 UNION ALL
12 SELECT '22000', 200 UNION ALL
13 SELECT '33000', 300
14
15 /*
16 Lets check if the values are correctly inserted or not
17 */
18 SELECT * FROM @Items
19
20 /*
21 OUTPUT:
22
23 ItemNumber Qty
24 -------------------------------------------------- -----------
25 11000 100
26 22000 200
27 33000 300
28 */

Now let us create a stored procedure that accepts a TABLE variable. Let us create a very simple stored procedure which accepts a TABLE variable and SELECTs contents of the table.

1 CREATE PROCEDURE TableParamDemo
2 (
3 @Items ItemInfo
4 )
5
6 AS
7
8 SELECT *
9 FROM @Items

Well, this would generate the following error:

1 /*
2 Msg 352, Level 15, State 1, Procedure TableParamDemo, Line 1
3 The table-valued parameter "@Items" must be declared with the READONLY option.
4 */

A table variable that is passed to a stored procedure or function should be marked as READONLY. The "callee" cannot modify the table being passed into it. Here is the correct code.

1 CREATE PROCEDURE TableParamDemo
2 (
3 @Items ItemInfo READONLY
4 )
5
6 AS
7
8 SELECT *
9 FROM @Items

Now let us execute the stored procedure we just created. Run the following code.

1 /*
2 declare the variable
3 */
4 DECLARE @items AS ItemInfo
5
6 /*
7 Insert values to the variable
8 */
9
10 INSERT INTO @Items (ItemNumber, Qty)
11 SELECT '11000', 100 UNION ALL
12 SELECT '22000', 200 UNION ALL
13 SELECT '33000', 300
14
15 /*
16 Execute the procedure
17 */
18 EXECUTE TableParamDemo @Items
19
20 /*
21 OUTPUT:
22
23 ItemNumber Qty
24 -------------------------------------------------- -----------
25 11000 100
26 22000 200
27 33000 300
28
29 */

You cannot modify the TABLE parameter passed into the stored procedure. If you try to do so, you will get an error as shown in the following example.

1 CREATE PROCEDURE TableParamDemo
2 (
3 @Items ItemInfo READONLY
4 )
5
6 AS
7
8 SELECT *
9 FROM @Items
10
11 INSERT INTO @Items (ItemNumber, Qty)
12 SELECT '1001', 20
13
14 /*
15 OUTPUT:
16
17 Msg 10700, Level 16, State 1, Procedure TableParamDemo, Line 11
18 The table-valued parameter "@Items" is READONLY and cannot be modified.
19 */

Conclusions
The support for TABLE variables is very interesting. While working with User Defined TABLE Type, please note that you cannot use it as a column of a table. Please also note that, once created, you cannot alter the structure of the TABLE.