Before you ask, SOT means Slightly Off Topic :-())
Take a look at Hi, I need help on simplyfying this Update query!
I don't even want to count the nested SELECTS, The query is 688 lines long, somehow schadenfreude enters my mind.
-
Categories
-
Archives
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- June 2007
- May 2007
- April 2007
- December 1969
-
Blogroll
-
Meta
I’m really pleased to say that the release candidate of Hyper-V is available for download today. You can read the announcement and Jeff’s more detailed post. This milestone is important to the hundreds of customers and partners in the early adopter programs, and those of you trialing Hyper-V on your own, because it’s feature complete, better performing than the beta, and you’ll have a better experience using it. Reports from the Hyper-V early adopter programs have matched some of the third-party reviews and first looks, with comments such as:
· “External deployments have exceeded Beta coverage goals”
· “External TAP deployments have increased significantly”
Amongst the early adopter customers, the three most common Windows Server 2008 roles run within Hyper-V are IIS, application server and Terminal Services. The four most deployed Microsoft applications are SQL Server 2005 and 2008, Exchange Server and Forefront, while more than half of the customers are running an AV/security application, nearly 50% are running a backup appliance at this point, and around 75% of the customers are running Hyper-V with some attached storage. At the same time we’re starting to see more and more and more ISV partners announce plans to support Hyper-V. So overall we’re seeing good enterprise uptake of Hyper-V.
I was in France and the Nordics two weeks ago attending launch events for Windows Server, SQL Server and Visual Studio. Lots of the attendees had already started testing the beta of Hyper-V. Several people remarked that they were impressed with early testing of the multi-site clustering capabilities for remote disaster recovery. Beyond the technical capabilities, total cost of ownership was another hot topic. Given that Hyper-V is a role within Windows Server 2008 – the beta of Hyper-V was included with Windows Server 2008 – customers attending the launch were looking forward to having these server consolidation and DR capabilities built into Windows Server 2008. I did have to remind several folks that Hyper-V will be available with three, x64 editions of Windows Server 2008 (the versions of Windows Server 2008 without Hyper-V are $28 less). And I often noted our work on cross-platform interoperability with Citrix/Xen, Novell and Sun, and that we’re opening up APIs to the community.
While we’re excited to deliver Windows-based server virtualization to customers and partners, Hyper-V is just one piece that we’ll deliver. Windows Server 2008 also delivered new presentation virtualization capabilities via Terminal Services. TS Gateway, RemoteApp publishing and TS Web Access are just a few of the new features that have been well documented by the Terminal Services team blog.
Systems management is really the essential tool for customers to effectively virtualize their desktops and IT systems. So we’re focused on delivering a single pane of glass for customers to backup, configure, monitor and distribute software and applications – both traditional and virtual – across desktops, devices and servers using one license. Customers repeatedly tell us that their lives of managing virtual and physical systems are becoming more complex because they don’t have a single tool to manage and track everything. Right now, customers are forced to deal with silo’d views of systems management. With the next version of System Center Virtual Machine Manager, we’ll really start to reduce that complexity because SCVMM will manage Virtual Server 2005 R2, Hyper-V and VMware ESX Server (including VMotion). With a subsequent version of SCVMM, customers will be able to manage Xen/XenServer. In the end, customers will have a systems management experience for virtualization that they’ve grown accustomed to with traditional systems.
Changing gears a bit to the desktop, we’ve made a couple key acquisitions over the past few months; notably Calista Technologies and Kidaro. The former should really improve employees’ computing experiences via RDP, while the latter offers an innovative mobile desktop solution to businesses. I’m real happy that we’ll be able to work with the people and software from Kidaro. Not only does it add great value to Microsoft Desktop Optimization Pack customers, it really breathes new life into Virtual PC as a tool for business professionals. Of course this puts a broad smile on my face because I have good memories of my days at Connectix developing VPC. Combined with our other alternative desktop deployment methods like Terminal Services, SoftGrid application virtualization, and Vista Enterprise Centralized Desktop, the Kidaro software will provide customers with ultimate flexibility for desktop provisioning.
So for now download and evaluate Hyper-V. And I hope you’re able to attend either Microsoft Management Summit 2008 or Interop 2008 conference (both in Vegas at the end of April) where you’ll be able to hear more about Microsoft’s virtualization products and plans. Personally, I’m speaking at Interop 2008 on the morning of April 30 with analyst Barb Goldworm. Hope to see you there.
Mike Neil, general manager, virtualization strategy
Like many large organizations, Microsoft has a geographically dispersed work force. With more than 78,000 employees in 78 countries worldwide, Microsoft faces continual challenges with making corporate information easily available to workers from remote locations and with ensuring that important internal company information is as secure as possible.
Although the vast majority of Microsoft employees have individual personal computers available from which to access company resources, the following two situations frequently occur at Microsoft:
These resources may include any of the following:
To meet these requirements, Microsoft maintains a Windows
Although the vast majority of Microsoft employees have individual personal computers available from which to access company resources, the following two situations frequently occur at Microsoft:
- Staff members need to access internal company resources from home or from a remote location.
- Staff members who are involved in meetings or presentations at remote locations require quick access to internal company resources.
These resources may include any of the following:
- Documents that are located on internal servers at Microsoft.
- Internal business programs that are available only from inside the corporate network.
- Personal workstations that contain important files or programs. For example, developers at Microsoft often need to connect to their individual workstations from remote locations to access programming tools or code.
To meet these requirements, Microsoft maintains a Windows
Many have hailed Apple's iPhone as having revolutionized the mobile phone industry, and it has certainly made an impression. Other cell phone vendors are now coming out with devices that include one or more of the features made popular by the iPhone, such as extra-large screens and more support for...
I went to the 6th Annual Financial Services Developer Conference today in New York City. This year’s focus was on High Performance Computing (HPC). I must say that I have enjoyed this conference a lot. It seems that SQL server is very prevalent on the street. The OLAP capabilities of SQL Server are making Sybase slowly disappear from Wall Street.
Financial firms are doing some very interesting stuff; there is a hedge fund which records am earnings call, runs it through some voice stress analysis software and based on the outcome of that will short or long the stock. You should hear the stories of how financial firms handle IT, the innovation is happening in the financial markets. I also saw a couple of very cool WPF applications. Check out the demos from Lab49: http://www.lab49.com/insidethelab/demos Visit http://www.financialdevelopers.com/ to download The Silverlight 2 Retail Financial Services Demonstrator
Carl Franklin from Dotnetrocks recorded a podcast at the event, this podcast was about concurrency and how to handle multi-core programming. You should definitely check it out when it becomes available on dotnetrocks. If you are interested about PLINQ and concurrent programming with .NET then visit this site: http://msdn2.microsoft.com/en-us/concurrency/default.aspx
Tomorrow there are three sessions at the same time that I want to attend
Software Engineering with VSTS
Parallelize you .Net applications with parallel extensions to the .NET framework.
Useful evolution: Programming the New features in SQL Server 2008.
I guess I'll pick the SQL Server one :-)
I have my blackcrackberry with me so if you are attending the event tomorrow then send me an email at FirstName.LastName@dowjones.com and maybe we can discuss about this event during lunch.
Lots happening in Orlando at the Convergence 2008 - the Microsoft Dynamics users' conference. Steve Ballmer and vice president Kirill Tatarinov are speaking and the Dynamics team is making a number of announcements, including a partnership with EDS to extend Microsoft Dynamics CRM deployments, a preview of Dynamics AX 2009 (part of the ERP product portfolio), and more developments in hosted, online services. Also announced - and one of the things Kirill is speaking about in his keynote - is how Windows Essential Business Server and Microsoft Dynamics are an ideal combination for midsized companies.
Essential Business Server provides that reliable platform for line of business applications that is all too often a challenge for midsized businesses to set up. All of the core infrastructure needed - Windows Server, Active Directory, SQL Server, secure remote access, etc. - is ready to go, configured to best practices. And Dynamics solutions will be manageable as "Add In" apps within the Essential Business Server unified administration console, giving IT pros a more efficient way to manage everything in one place.
Software partners such as Citrix, CA, FullArmor, Mimosa Systems, Quest Software, ScriptLogic, Symantec and Trend Micro also plan to provide Add-In software solutions for Windows Essential Business Server. And HP, IBM and Intel will make hardware management Add-Ins.
Microsoft and HP are demonstrating Essential Business Server with Dynamics Add Ins at Convergence, and the EBS team is doing a number of sessions at the show.
Joel Sider
The team behind Windows Essential Business Server 2008 for midsized companies (part of the newly announced Windows Essential Server Solutions family and formerly known as "Centro") has launched a team blog here. Group Program Manager Eric Watson provides the introduction:
In this Blog, key people that design and develop the product will discuss all of those features, the software, tips and tricks, and yes, even shortfalls that we hear from customers. As engineers, we love details, and with 5 products and 15 workloads plus all the ‘can’t get it anywhere else’ software we added, there are plenty of details to talk about.
The Essential Business Server web site is here. A Q&A about the product is here.
Joel Sider
If you are a Volume Licensing customer, you have probably downloaded Windows Server 2008 already or you will be receiving it soon as part of your monthly DVD shipments. As you start testing and getting ready for deployment, one thing you’ll need to plan for is Volume Activation. Since we launched the Windows Server 2008 a couple of weeks ago, we have updated a few resources to help you understand activation better and make it easier to use in your existing environment.
Windows Server 2008 uses the same volume activation technology as Windows Vista, so if you are familiar in how it works for Vista, the same principles apply with some minor changes. For more details, see Volume Activation 2.0 Changes for Windows Server 2008 and Windows Vista SP1. On the other hand, if you are new to volume activation and need to ramp up quickly, there is a new Silverlight overview that goes over the basics and a KMS Setup Demo that you can download. As well, we have updated most of the documents in the Volume Activation 2.0 Technical Guidance Center.
In addition to the new and updated content, we’ve updated the Key Management Service (KMS) for Windows Server 2003 so that you can run a single KMS host which supports volume license editions of both Windows Vista RTM & SP1 and Windows Server 2008. The new KMS will also allow you to run it in a Windows Server 2003 virtual machine -- a big change from the original KMS. If you plan to keep your KMS on WS2003, you’ll need this update right away.
KMS v1.1 for Windows Server 2003 is now available on the Microsoft Download Center at:
X86 (EN-US) - http://go.microsoft.com/fwlink/?LinkId=82964
X64 (EN-US) - http://go.microsoft.com/fwlink/?LinkId=83041
More details about the update are outlined on Michael Greene’s blog and on the download site.
Julius Sinkevicius
07 Mar
SBS myths dispelled…by “Tom”
In the course of talking to many Microsoft partners and customers, the Windows Small Business Server team has learned that there are sometimes misperceptions about the product, in many cases based on experiences with the earlier versions of SBS. In hopes of dispelling some of these "myths," the team has created a video log by an "SBS guru" named Tom. Take a look at some of the first videos, maybe have a few laughs, and play a game of "punch a wizard." Look for new posts, too.
This site discusses some of the SBS myths in a more, shall we say, staightforward way - such as:
I can't add additional servers to a Windows SBS domain
I can't run Terminal Services in the SBS domain.
SBS doesn't scale.
I can't upgrade my current server.
I'm going to outrgrow SBS.
The Exchange mail store limit is too small.
SBS has scaled-down versions of the included applications.
I can't use tools from Windows Server in Windows SBS.
SBS isn't secure.
Channel 9 has a 45 minute video with Dave Campbell about SQL Server Data Services. maybe this video will answer some of the question you might have about SQL Server Data Services
Watch it here: http://channel9.msdn.com/ShowPost.aspx?PostID=388698#388698