Making developer edition of SQL Server act/look like Standard Edition

Recently I assisted my colleague answer the question of making SQL Server Developer edition act/look like Standard Edition instead of its default behaviour which is to be the same as Enterprise Edition. Basically the answer to this question is that there is NO switch/setting/configuration to make developer edition act/look like standard edition. So how does…

4

Migrate from MySQL/Access to SQL Azure or SQL Server with ease!

Microsoft announced today the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4.2 release. SQL Server Migration Assistant for MySQL is the newest migration toolkit, others include Oracle, Sybase, Access,…

4

Administering the Cloud database using your browser–Silverlight style :)

The SQL Azure Labs site recently made available CTP1 of Project Houston. Through this Silverlight enabled site you can manage a SQL Azure database. You can create objects tables, stored procs, write TSQL queries and view results. So if you are looking for a way to administer a SQL Azure database and currently your organisation…

2

Master Data Services first cumulative update is now available!

A cumulative update for Master Data Services has been released. It addresses a number (30+) of issues that weren’t addressed before the release of SQL Server 2008 R2 RTM release.  If you are looking at using MDS, then this update is a MUST for you. It also fixes the issue of publishing business rules which…

2

Master Data Services–Business Rule Activation error and its fix

While preparing for a demonstration of SQL Server 2008 R2 Master Data Services – vanilla build – my colleague Lee Theofanis from Decision Resources came across an issue regarding business rule activation. The Issue After creating a business rule through the Master Data Manager portal, and then trying to activate it results in the following…

2

SQL Server 2008 R2 Best Practices Analyser

Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server 2008 or 2008 R2 instances. The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions: Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance…

2

SQL Server virtualisation improvements with SLAT in Intel and AMD

Recently I had query around documentation that discusses the benefits of running SQL Server in a virtualised environment on modern hardware with SLAT or second level address translation. The below graph shows that (see the solid red line) the relative throughput for hardware with SLAT & Windows Server 2008 R2 (required for SLAT support) degrades…

2

Incorporating Reporting Services Reports in Word and PowerPoint

My colleague Alan Eldridge, BI Technology Specialist at Microsoft, put together a great post on incorporating Reporting Services reports in Word and PowerPoint. With his permission I am making it available to you. This post talks about incorporating the report into Office/PowerPoint as opposed to exporting to these formats. The report information is positioned at…

7

Just like the fine Sydney weather today, some great announcements about our SQL Azure Cloud offering

SQL Azure Extends to 50 GB SQL Azure database is now extending from 10GB to 50GB size of database storage capacity. With 50 GB capacity now available, customers can have much broader use of the SQL Azure highly available, relational database service for many of their LOB business applications, taking full advantage of the SQL…

2

June 2010 Sydney SQL Server User Group: Come see my session on Master Data Services, details below

This month we have two sessions: Master you data with Master Data Services (Shashank Pawar) Why use PowerShell (Siraj Jamdar) | Venue: Mechanics’ School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) 6:00PM – 8:00PM | Session | On: Tuesday, 8 June 2010 Please register so I…

2