Never ever set up a Database Mirroring session across different SQL Server Editions (SKU)

Even though it might work, never attempt to do that. As the documentation clearly states: it is unsupported. In topic Prerequisites, Restrictions, and Recommendations for Database Mirroring, Books Online shows a Prerequisites section where it mentions the following: Prerequisites Before you can set up database mirroring, you must perform the following: For a new mirroring…

3

What’s in Enterprise only? (Online Restore)

If you want to have the possibility to restore data on a database while it is already online (i.e. whenever its primary filegroup is online) you can do so only if you are running the Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The…


What’s in Enterprise only? (Database Tuning Advisor support for recommending Indexed Views)

If you want to leverage the ability provided by SQL Server Database Engine Tuning Advisor to evaluate what would be the benefit of creating indexed views as an additional physical structure, you can select either of the two tuning options available for such purpose: “Indexed views” and “Indexes and indexed views”. However, those two advanced…


What’s in Enterprise only? (SQL Server Audit)

Beginning with SQL Server 2008 you can set the database engine to automatically audit at several levels. All the tools and processes required to easily and successfully configure such flexible and comprehensive level of auditing, so that your system complies with whatever government or standard requirements your installation must adhere to, are available out of…


What’s in Enterprise only? (Fuzzy Grouping Transformation in Integration Services)

Fuzzy Grouping is a component which, when used as part of a data flow in an SSIS (SQL Server Integration Services) package, enables you to identify groups of records in a table where each record in the group potentially corresponds to the same real-world entity. The grouping is resilient to commonly observed errors in real…


What’s in Enterprise only? (Resource Governor)

You may have faced situations where you’d have wished you could avoid a run-away query consuming most or all CPU or memory shared resources of the server resources, or avoid the execution of unpredictable workload, or simply prioritize workloads so that resources are granted in a way that one workload is allowed to proceed faster…


What’s in Enterprise only? (Large Memory Pages)

SQL Server leverages Windows Memory Manager’s Large-Page support which is particularly beneficial in 64-bit OSs with important amounts of physical memory (RAM). The idea behind this mechanism provided by the OS is to reduce TLB misses when accessing frequently used data structures. The Windows APIs that let an application use large pages impose their own…


What’s in Enterprise only? (Soft-Numa configuration)

Much has been written about SQL Server’s support for Soft Numa since even before the first release which supported that concept (SQL Server 2005) was released. Among the list of interesting posts about it, I propose you to read these: A new platform layer in SQL Server 2005 to exploit new hardware capabilities and their…


Understanding the value of the Enterprise Edition, one feature at a time

This is something I planned to start a while ago and never found the time to do it properly. The idea behind this series of posts is to highlight what are all those benefits which are only available in the Enterprise Edition. Not only the ones well renown and advertised by our marketing folks, but…