Save not permitted in SQL Server 2008 - Management Studio

I heard too many questions about this issue. As you already know, in Sql Server 2008, the save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created which can be annoying.

Management Studio requires you to re-create the table for the following actions:

  • Adding a new column to the middle of the table
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column

To disable this annoying option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Clear the Prevent saving changes that require the table to be re-created check box.

Microsoft and Intel Demonstrate New Levels of Power, Price and Performance With CRM Scalability Benchmark

Microsoft and Intel Corporation announced performance results today for Microsoft Dynamics CRM that set new enterprise standards for scalability, cost and environmental sustainability. Through a combination of enterprise-class software and the latest Intel® Xeon® processor 5500 series, which can reduce server power consumption by up to 30 percent, Microsoft Dynamics CRM 4.0 scaled to more than 50,000 concurrent users over a high-volume workload — while experiencing subsecond response times.

“Our business strategy is to make CRM technology that is simple, flexible and affordable for companies of all sizes,” said Brad Wilson, general manager of Microsoft Dynamics CRM. “In this benchmark, we’ve proved that Microsoft Dynamics CRM can handle extreme workloads with minimal investment in hardware and a reduced impact to the environment. We’re once again redefining the price-to-value equation in the CRM market, across all deployment models.”

By comparison, an October 2008 performance test for Oracle Siebel Release 8.0 (1) scaled to 14,000 users and 1.6 million daily transactions leveraging Sun hardware that cost more than $150,000. The Microsoft Dynamics CRM benchmark scaled to more than 50,000 users and more than 2.9 million daily transactions — all from hardware that costs less than $35,000 (2), or $0.70 per user. In this comparison, Microsoft Dynamics CRM drove three and a half times more users and almost two times more transactions — while reducing hardware costs nearly 80 percent.

“Intel and Microsoft engineers worked together to optimize Microsoft Dynamics CRM for new Intel® Xeon® processor 5500 series-based servers with intelligent server technology capabilities and Intel Solid State Drives (SSDs),” said Boyd Davis, general manager, Intel Server Platforms Group. “This collaboration led to exceptional economic scalability and responsiveness results, which can enable companies of all sizes to deploy enterprise-class business solutions at a fraction of what these kinds of solutions have traditionally cost.”

Detailed performance tests and production runs were completed on Microsoft Windows Server 2008 and Microsoft Windows SQL Server 2008 for 50,000 concurrent users, 5,000 concurrent users, 2,500 concurrent users, and 1,000 concurrent users. For scenarios with casual users or lower transaction rates per user, higher number of users can be accommodated. An executive summary of the performance and scalability benchmark is available by clicking here, and other white papers that outline the results of each test will be published in the coming weeks at http://crm.dynamics.com.

Common Editor Issues in VS 2010 Beta1

The Visual Studio 2010 Beta 1 has published 2 weeks ago.  In the two weeks since Beta1 was released, users sent tons of feedback that has helped the product group to fix some of the most commonly reported bugs.  Brittany Behrens published a post which details frequently-encountered bugs and their status.

Click here to read the “common editor issues in visual studio 2010 beta 1″.

Microsoft Code Analysis Tool .NET (CAT.NET) v1 CTP - 32 bit Published

CAT.NET is a snap-in to the Visual Studio IDE that helps you identify security flaws within a managed code (C#, Visual Basic .NET, J#) application you are developing. It does so by scanning the binary and/or assembly of the application, and tracing the data flow among its statements, methods, and assemblies. This includes indirect data types such as property assignments and instance tainting operations. The engine works by reading the target assembly and all reference assemblies used in the application — module-by-module — and then analyzing all of the methods contained within each. It finally displays the issues its finds in a list that you can use to jump directly to the places in your application’s source code where those issues were found. The following rules are currently support by this version of the tool. - Cross Site Scripting - SQL Injection - Process Command Injection - File Canonicalization - Exception Information - LDAP Injection - XPATH Injection - Redirection to User Controlled Site.

You can download the CAT.NET v1 CTP here.

Architecting a SQL Server Analysis Services Solution for Business Intelligence

Microsoft Canada has just published some training resources on SQL Server 2008. You can directly access to parts of the training “Architecting a SQL Server Analysis Services Solution for Business Intelligence” from the following links. Also click here for the full list of available trainings.

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 1

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 2

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 3

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 4

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 5

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 6

Architecting a SQL Server Analysis Services Solution for Business Intelligence Part 7

Architecting a SQL Server Analysis Services Solution for Business Intelligence - Live Q & A - Part 8

New 11g Features in Oracle Developer Tools for Visual Studio

The 11g release of Oracle Developer Tools for Visual Studio (ODT) includes a host of powerful new features that make Oracle and .NET development easier and faster. 

Oracle has published a paper which is focused to these features.

PerformancePoint merging with SharePoint

As of April 1, 2009, this server will no longer be available for purchase. When the next version of Microsoft Office is released, the Monitoring and Analytics capabilities will be included with SharePoint Server Enterprise. Microsoft will continue to support PerformancePoint, including “Service Pack 3” later this year.

To learn more, click here to read the detailed Q&A of Kurt DelBene.

Sharepoint 2007 Service Pack 2 Releases Today

In a few hours, service pack 2 of Sharepoint 2007 will be released. All sharepoint related sites will be updated upon release of sp2. 

Download the marketing document here (higher performance, more scalable, ultra available and of couse ie8 thing :) )

Read a technical review (i’d prefer this :))

Also
List of all 2007 Office system Service Pack 2 and Windows SharePoint Services 3.0 Service Pack 2 package

This is the last service pack for sharepoint 2007 before the new rtm: sharepoint 2010.

Sem has published a new open source blog engine

A few days ago, Sem has published a new open source blog engine. I’d like to thank Sem for his effort and commitment to developers community. I’m also planning to move my blog system to his new platform in a short while.

Please visit http://www.semgoksu.com/sem-goksu-acik-kaynak-kodlu-blog-sistemi-yazisi/534.aspx for details and download instructions.

SQL Server 2008 Webcast

Today we delivered a webcast on new features of SQL Server 2008. Thanks to everyone that made it to the live webcast. If you couldn’t make it, the recording will be online at www.microsoft.com/turkey within 2 days. You can download the slides from this link.