Stop using SQL Server path’s work with a SQL Alias

A lot of times i run into customers how started out with one SQL server and run in to problems when these servers have to be upgrade or the databases needs to be migrated to different SQL servers of clusters because of expansion or recourses. Let’s say you have an application that has a specified database connection that I either can’t or don’t want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?

By using an alias! We can keep the application configuration the same, but tell the operating system to look somewhere else for the database. Another plus is that once an alias is created, it is set at the operating system level. That means if we have two applications which connect to MySQLServer on that computer, once the alias is created, both will be re-pointed based on the alias. You can create an alias using one of two utilities:

  1. SQL Server Configuration Manager
  2. SQL Server Client Network Utility

SQL Server Configuration Manager

Let’s start by looking at how to do it using SQL Server Configuration Manager. In the left pane of SQL Server Configuration Manager, if you expand the SQL Native Client Configuration folder, there is a subfolder called Aliases (see Figure 1). If we click on this subfolder, we’ll see any aliases that have been defined for the system shown in the right pane. In most cases, there won’t be any defined. To create a new alias, right-click on Aliases and choose New Alias… from the pop-up menu.

Figure 1:

1620_CreatingAliases_01

A dialog window comes up (Figure 2) which allows us to specify our new alias. In the Alias Name property, you specify the name the application uses. For instance, if it connects to a SQL Server called MyOldServer, that’s what you enter in here. You can also enter an alias that appears to point to a named instance, such as MyOldServer\MyInstance. You can then specify the server where the database really is, to include configuring the protocol, the server name, and the port. Clicking the OK button will create the alias. In the case of Figure 2, I’m creating an alias called MyOldServer which points to my local server’s default instance.

Figure 2:

1620_CreatingAliases_02

You should now see the new alias listed in the right pane (Figure 3).

Figure 3:

1620_CreatingAliases_03

 

The next step is to test the connection. You can do so quickly by either creating and testing a Data Source Name (DSN), or if you have the SQL Server client tools installed, by using SQL Server Management Studio (SSMS). I’ll do so using SSMS. Figure 4 shows the dialog window to open a new connection to a database engine. For Server name:, enter in the alias you specified. In the example we called the alias OldServerName, so that’s what we’ll use here.

Figure 4:

1620_CreatingAliases_04

If the alias is pointed correctly to the new location, a successful connection should be established. In SSMS, I was opening a new connection for Object Explorer. Figure 5 shows that the connection was successfully made using the alias. Note that as far as SSMS is concerned, the server name is the alias.

Figure 5:

1620_CreatingAliases_05

SQL Server Client Network Utility

If you haven’t installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility. This has come installed automatically on every operating system from Windows 2000 on. To bring up the utility, click on Start, then Run, and run cliconfg.exe. To view or create aliases, click on the Alias tab (Figure 6). As you can see from Figure 6, aliases created by SQL Server Configuration Manager can be seen by the SQL Server Client Network Utility. The reverse is also true.

Figure 6:

1620_CreatingAliases_06

 

To create a new alias, click on the Add… button. This will bring up a new dialog window where you can specify your alias (Figure 7). Just as with SQL Server Configuration Manager, the Server alias is what the application will attempt to connect to. You can specify where that alias points to by specifying the network library, the real server name, and any additional configuration parameters. In Figure 7 I’m creating a new alias called MyOldServer2 that also points to the default instance of my local server.

Figure 7:

1620_CreatingAliases_07

 

Click the OK button to create the new Alias. In order for the alias to actually be created, however, you must click the OK button for the SQL Server Client Network Utility, which will create the alias as it closes.

Conslusion

Now that you know how to create an alias to a SQL Server instance look at this option instead of having hard SQL connections to server and run into problems when you want to reinstall or rename your servers. Also some application do not give you the ability to connect to a named instance, so this is another way of connecting without having to use the a default instance.

Windows Server “8” Beta Hyper-V Component Architecture poster

The new Windows Server “8” Beta Hyper-V Component Architecture poster is now available from the Microsoft Download Center.

Windows Server 8 Beta Hyper-V Component Architecture

This poster provides a visual reference for understanding key Hyper-V technologies in Windows Server “8” Beta. This new Hyper-V poster focuses on Hyper-V Replica, networking, virtual machine mobility (live migration), storage, failover clustering and scalability.

If you haven’t seen them previously, the following posters are also available:

Cool new Windows 8 VDI and RDS capabilities!

Windows Server “8” Beta, has a lot of new Remote Desktop Services, VDI and administration capabilities to simplify deploying virtual machine-based and/or session-based desktops or applications. This includes new features related to pooled deployment (single virtual desktop template across many users), personal desktops (one VHD per user), and user profile disks.

Adam Carter has created a brief video to overview the above new features of Remote Desktop Services (not a complete list of all new features) on the Edge Show. A must see video.

Edge Show 16 – Windows Server 8 VDI

Windows 8 Consumer Preview (Desktop and Server) now available for Download

And if you want some videos:

Windows 8 Desktop Consumer Preview ISO files (.iso) are provided as an alternative to using Windows 8 Consumer Preview Setup. If you are on a PC running Windows and want to install the consumer preview on another partition, another PC, or a virtual machine, i recommend you download Windows 8 Consumer Preview Setup and use the built-in tools for converting an ISO image into installation media, such as a DVD or USB bootable flash drive. You can find additional information, including a list of supported upgrades, in the FAQ.

English 64-bit (x64) Download (3.3 GB) Sha 1 hash — 1288519C5035BCAC83CBFA23A33038CCF5522749

English 32-bit (x86) Download (2.5 GB) Sha 1 hash — E91ED665B01A46F4344C36D9D88C8BF78E9A1B39

Product Key: DNJXJ-7XBW8-2378T-X22TX-BKG7J

The next release of Windows Server, Windows Server “8”, offers businesses and hosting providers a scalable, dynamic, and multitenant-aware, cloud-optimized infrastructure. It securely connects across premises and allows IT Professionals to respond to business needs faster and more efficiently. Register to access technical product resources such as forums, solution accelerators, white papers and webcasts at the Windows Server “8” Beta Resource Page.

Download here: Link

Windows Server “8” beta documentation site is updated, here are some links:

Remote Server Administration Tools for Windows 8 Consumer Preview includes Server Manager, Microsoft Management Console (MMC) snap-ins, consoles, Windows PowerShell cmdlets and providers, and command-line tools for managing roles and features that run on Windows Server “8” Beta. In limited cases, the tools can be used to manage roles and features that are running on Windows Server 2008 R2 or Windows Server 2008. Some of the tools work for managing roles and features on Windows Server 2003.

Download here: Link

The Windows 8 Consumer Preview Product Guide for Business provides a detailed look at the many new and improved features in Windows 8. The guide is designed as an accurate source of information that can help businesses understand how Windows 8 enables users to be ready and productive practically anywhere, allows for a personalized user experience, and provides IT with more secure, easy-to-manage intelligent infrastructure.

Download here: Link

Remove Favorites, Libraries and Network from Windows 7 / 2008R2 Common File Dialog (Windows Explorer)

Within Windows Explorer you got the common file dialog (Shown @ the screenshot below). Within this dialog you got a favorite link, a Libraries link and a network link. These links are in some cases a security problem. You don’t want users to use the libraries folder witch contains all users folders when they work on systems that share users for example XenApp servers. Also you don’t want users to browse the network or see auto discovered server names…Here is described how you get rid of it!

You can set these registry settings within the 2008 computer policy’s with the registry but there is a problem with the rights. Standard the system and the administrators don’t have rights to set the settings. You have to change the acl to set the registry keys!

1. To remove the Favorites, the key is:

[HKEY_CLASSES_ROOT\CLSID\{323CA680-C24D-4099-B94D-446DD2D7249E}\ShellFolder]
“Attributes”=dword:a0900100

Changing a0900100 to a9400100 will hide Favorites from Navigation Pane.

2. For Libraries, the key is:

[HKEY_CLASSES_ROOT\CLSID\{031E4825-7B94-4dc3-B131-E946B44C8DD5}\ShellFolder]
“Attributes”=dword:b080010d

Changing b080010d to b090010d will hide Libraries from Navigation Pane.

3. For Network, the key is

[HKEY_CLASSES_ROOT\CLSID\{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}\ShellFolder]
“Attributes”=dword: b0940064

This first part is, in the 32-bit world, the solution for the Windows Explorer ánd the Common File Dialog. But in the 64-bit world you need another registry key edited. This is basically the same key, but in the Wow6432Node ‘folder’ within the registry.
The trick!:

1. To remove the Favorites X64 , the key is:

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{323CA680-C24D-4099-B94D-446DD2D7249E}\ShellFolder]
“Attributes”=dword:a0900100

Changing a0900100 to a9400100 will hide Favorites from Navigation Pane.

2. For Libraries X64, the key is:

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{031E4825-7B94-4dc3-B131-E946B44C8DD5}\ShellFolder]
“Attributes”=dword:b080010d

Changing b080010d to b090010d will hide Libraries from Navigation Pane.

3. For Network X64, the key is

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}\ShellFolder]
“Attributes”=dword: b080010d

Changing b080010d to b090010d will hide Libraries from Navigation Pane.

New! XenApp 6.5 Available Now!

These are exciting times for desktop virtualization.  The industry is growing and Citrix is leading the charge.  The XenDesktop product line is getting plenty of well-deserved attention, but today Citrix is also announcing exciting new enhancements for XenApp 6.5. Whether included as a component of XenDesktop Enterprise and Platinum or deployed as a standalone product, XenApp has long been recognized as the de-facto standard in on-demand app delivery.  Now with turbo-charged app launches and a seamless multimedia experience over any network, XenApp 6.5 makes the user experience better than ever.

Instant App Access

The XenApp 6.5 feature generating the most excitement among customers is Instant App Access.  Gone are the days when users would have to wait several seconds for the creation of an ICA session before their application launched.  By creating an ICA session immediately upon user log-in to Citrix Receiver, Session Pre-Launch dramatically reduces overall application launch times. Since the ICA session is created even before the user clicks the application icon, the only remaining time to wait is for the application launch itself.  Depending on the application, this can be nearly instantaneous.

Similar technology allows an ICA session to linger after users close their last published app so that the next application launch is just as instantaneous.  While these features do consume a license, the time periods for lingering or pre-launch are configurable by the IT admin.

Seamless multimedia experience with HDX

With only a few exceptions, all of the HDX enhancements seen in XenDesktop 5.5 are also applicable for XenApp 6.5. For example, significant updates to HDX MediaStream for Flash mean that Adobe® Flash® content can be rendered locally over more network conditions than before.  This dynamically takes advantage of computing resources at the end point, resulting in even higher server scalability and a great user experience even at up to 300ms round-trip latency.

Multi-Stream ICA

IT administrators now have the option of delivering XenApp ICA traffic over up to four TCP/IP streams. Now instead of prioritizing the entire ICA pipeline over HTTP traffic, this feature enables more granular control for Quality of Service (QoS) routing.  Now customers can provide superior audio/visual quality for apps delivered over the WAN for example without disrupting other HTTP traffic.

Any Device, Anywhere with Citrix Receiver

XenApp 6.5 takes advantage of new Citrix Receiver enhancements for extreme multi-tasking, faster Windows app performance and advanced Linux device support. Customers can now deliver self-service apps to more than one billion devices, including PCs, Macs, tablets, smartphones, and thin clients – and all major device operating platforms, including new environments like iOS, Android, and Google ChromeOS.   Add it all up and we’re talking about over 1 Billion devices.

Enhanced Desktop Experience

Previously provided as an add-on pack for XenApp 6.0, support for an enhanced desktop experience is now included as an integrated feature of XenApp 6.5. IT can transform the typical server desktop published by XenApp.  This feature enables support for themes, installs accessory apps, and allows for the display of high-res wallpapers.  With a Windows-7 like Start Menu and taskbar, users can enjoy the look and feel of a Windows 7 desktop, while IT can benefit from the server density and locked down image management of a hosted shared desktop

Desktop Director

When end-users need support help with their XenApp delivered apps, help desk support staffs can use the popular Desktop Director console that now includes the integrated capability to assist users with applications delivered by XenApp and with desktops delivered by XenDesktop.

Dynamic Data Center Provisioning

Now XenApp 6.5 deployments can be scaled in record time by creating “controller” or “worker” roles in a XenApp server farm.  Because workers in the farm need to sync much less data, fewer overall database transactions are required.  Plus, these new roles make the process of joining a large number of servers to a XenApp farm faster and easier.

These are just a few of the new features in XenApp 6.5.  For a full list of all features and a comparison to previous versions, you can refer to the new comparative feature matrix.

For a free interactive overview of XenApp 6.5 be sure to check out this new online course.

System Center Virtual Machine Manager Self-Service Portal 2.0 SP1 released

Are your datacenter costs rising? Does your current infrastructure make it difficult to scale up or down quickly to respond to the changing needs of your organization? To meet these challenges, you need a more cost-effective, agile way to provide IT services—quickly, efficiently, and on demand.

System Center Virtual Machine Manager Self-Service Portal 2.0 SP1 is a free, partner-extensible solution that allows you to dynamically pool, allocate, and manage datacenter resources. Using the Self-Service Portal, you can reduce IT costs, while increasing agility for your organization. The Self-Service Portal works with products and technologies you know and trust, like Windows Server and the System Center product suite. This solution delivers:

  • Automated web portals and a workload provisioning engine that integrates with System Center.
  • Tested guidance and best practices to help configure and deploy private cloud infrastructures.
  • Guidance to help partners easily extend functionality.
  • Localization in three languages: Japanese, Traditional Chinese, and Simplified Chinese.

Self-Service Portal Technology Partners

The Self-Service Portal includes powerful extensibility features for Microsoft technology partners. Independent software and hardware vendors can customize different virtual machine actions (create, delete, stop, start, shut down, connect, pause, and so on) to take advantage of the unique characteristics of their infrastructure.

Citrix

Citrix Integration Pack for Self-Service Portal

The integration pack integrates Essentials for Hyper-V with System Center by automatically provisioning the storage whenever a virtual machine is commissioned though the Self-Service Portal.
Learn more >

Compellent

Compellent Solution Pack for Self-Service Portal

Utilizing Windows PowerShell® with the Compellent Storage Center SAN, Compellent’s Solution Pack enables the integration and support for self-service provisioning of data storage resources with Virtual Machine Manager and Windows Server Hyper-V™ through the Self-Service Portal.
Learn more >

f5

F5 Solution for Self-Service Portal

The F5 solution for Virtual Machine Manager Self-Service Portal adds the option for traffic management by the BIG-IP application delivery controller (ADC) within the service role section of a user request. Executing this option automatically configures the BIG-IP for the request of VMs as they come online.
Learn more >

HP

HP Services Using the Self-Service Portal

Accelerate your journey to the private cloud with HP’s Converged Infrastructure and HP Technology Consulting services. Begin with a short assessment, then continue to implementation based on HP’s deep experience in the datacenter. HP uses pre-developed scripts, portals, and cmdlets to integrate into your environment and build a self-service infrastructure.
Learn more >

Intel

Intel Cloud Builder Guide: Cloud Design and Deployment on Intel Platforms

The Intel reference architecture will assist organizations that require their cloud data and assets to reside on premises and those that need to support a new business domain with a separate IT infrastructure that is scalable and flexible.
Learn more >

NetApp

NetApp ApplianceWatch PRO 2.1.1

Accelerate virtual machine provisioning, and increase storage efficiencies in private cloud implementations managed by the Self-Service Portal with the integration scripts and PowerShell cmdlets included in ApplianceWatch PRO 2.1.1 that enable rapid provisioning of space-efficient VMs using NetApp FlexClone technology.
Learn more >

VKernel

VKernel Chargeback with Hyper-V

VKernel Chargeback with Hyper-V enables private clouds to automatically map virtualization costs to applications and customers by reporting on allocated costs and by measuring and expensing the actual consumption of server and storage resources by cloud customers.
Learn more >

Internet Explorer 9 is here!

Microsoft has launched the much anticipated IE9.

To start experiencing a more beautiful web with IE9 and to visit a small set of the top 250 web-sites globally that have created a more beautiful experiences for all of us with IE9, go to http://beautyoftheweb.com/experience.

Internet Explorer 9 has now been downloaded 2.35 million times in the first 24 hours since its Monday night release. That is over 27 downloads every second, or over 240 downloads every 9 seconds. Wow!.

They want to thank everyone around the world for downloading IE9 and the enthusiastic reception. 2.3 million downloads in 24 hours is over double the 1 million downloads we saw of the IE9 Beta and four times that of the IE9 RC over the same time period.

In case you missed it, check out the collection of videos from the SxSW launch event. Ze Frank’s demo of Star.ME is one not to be missed!

You can see all of the demos and the complete launch event by clicking play below. And to download Internet Explorer 9 for yourself, visit http://www.beautyoftheweb.com.

Ze Frank’s demo of Star.ME is one not to be missed!

You can see all of the demos and the complete launch event by clicking play below. And to download Internet Explorer 9 for yourself, visit http://www.beautyoftheweb.com.