Email Alerts
-
SQL Server virtualization best practices: A checklist for success
Cloud computing and virtualization have drawn considerable attention in the IT world for their innovation and cost-effectiveness. SQL Server Insider set out to explore the new trends, including basic suggestions and a virtualization checklist by Gart... E-Zine
-
Exploring SQL Azure features and opportunities
Volume 3 of the SQL Server Insider E-Zine offers tips for the SQL Server pro. This volume covers the following topics: "Are We There Yet? The Slow Road to SQL Azure," "Finding Your BI Niche in the Cloud," and "The Three Sides of DACPAC with SQL Serve... E-Zine
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server security in virtual, physical worlds virtually the same
SQL Server security issues in virtualized environments pretty much mirror the challenges in physical environments, experts say. Standard security guidelines apply. Feature
-
SQL Server virtualization is inevitable: Get the right hardware
Buying hardware for SQL Server virtualization hosts entails some specialized shopping skills. Get some expert tips on what to look for. Feature
-
SQL Server virtualization more than a passing trend?
Virtualization may be taking data centers by storm, but what’s behind the trend? In this month’s “SQL in Five,” SearchSQLServer.com asks Microsoft’s Mark Kromer about the benefits and difficulties of virtualizing SQL Server. SQL in Five
-
SQL Server Consolidation Fast Guide
This short guide features resources for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, strategies, best practices and more. Learning Center
-
SQL Server consolidation pros and cons
See if SQL server consolidation is right for you with this checklist, taken from Chapter 1 of our e-book, Consolidate SQL Servers for availability, scalability and cost savings. Checklist
-
Back up SQL Server to SQL Azure? Some have their fingers crossed
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases. News | 12 Jun 2012
-
Ahead of TechEd, Microsoft speaks on SQL Server 2012, Amazon RDS
Mark Kromer gives tips on what he thinks will be the best sessions at Microsoft TechEd 2012, and also comments on SQL Server in the cloud and a recent Amazon announcement. Q&A; | 06 Jun 2012
-
SQL Server virtualization risks: among all the pros, some cons
Virtualization promises big savings for businesses, and few are decrying its influence. But is it always the answer? Are there SQL Server virtualization risks to learn about first? News | 05 Jul 2011
-
Microsoft changes virtualization licensing for SQL Server 2008 R2
The company has put the kibosh on unlimited virtualization rights with SQL Server 2008 R2 Enterprise Edition. News | 05 May 2010
-
Per processor licensing holds up VMware virtualization push
At one Midwestern data processing firm, performance of resource-intensive apps under virtualization isn't the problem –licensing cost is. Article | 14 Dec 2009
-
Making sense of SQL Server 2012 virtual environment licensing
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin. Tip
-
SQL Server virtualization: Not always a good idea
SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider. Tip
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider. Tip
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Tip
-
SQL Server consolidation good -- not checking metrics bad
SQL Server consolidation could save your company big money, writes expert Denny Cherry, but first you’ll need to examine metrics like concurrent connections, buffer pool size and drive space. Tip
-
Virtualizing SQL Server: Myth or reality?
With benefits such as cost savings and high-availability options, SQL Server virtualization is taking the IT world by storm. Here are a few things to keep in mind. Tip
-
Are SQL Server BI systems compatible with virtualization?
As SQL Server BI catches on among small businesses, questions about whether SQL Server virtualization is compatible are bound to follow. Get an expert take on what you need to know for virtualized BI to work. Tip
-
Getting set up for multi-server management with SQL Server 2008 R2
One of SQL Server 2008 R2's most talked-about new features allows DBAs to monitor the performance of multiple instances with a single glance. Tip
-
SQL injection tools for automated testing
Manual testing for SQL injection requires a lot of effort with little guarantee that you'll find every vulnerability. Fortunately, there is a better way. Tip
-
Deploying a SQL Server virtual appliance for Microsoft Hyper-V
Deploying a virtual appliance is simple, and can come in handy when you need to install updates to Microsoft SQL Server. Tip
- See More: Tips on Microsoft SQL Server Consolidation and Virtualization
-
Cloud efforts advance, SQL Server evolves
MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more. Podcast
-
Making sense of SQL Server 2012 virtual environment licensing
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin. Tip
-
Back up SQL Server to SQL Azure? Some have their fingers crossed
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases. News
-
Ahead of TechEd, Microsoft speaks on SQL Server 2012, Amazon RDS
Mark Kromer gives tips on what he thinks will be the best sessions at Microsoft TechEd 2012, and also comments on SQL Server in the cloud and a recent Amazon announcement. Q&A;
-
SQL Server virtualization: Not always a good idea
SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider. Tip
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider. Tip
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server consolidation good -- not checking metrics bad
SQL Server consolidation could save your company big money, writes expert Denny Cherry, but first you’ll need to examine metrics like concurrent connections, buffer pool size and drive space. Tip
-
SQL Server security in virtual, physical worlds virtually the same
SQL Server security issues in virtualized environments pretty much mirror the challenges in physical environments, experts say. Standard security guidelines apply. Feature
-
SQL Server virtualization risks: among all the pros, some cons
Virtualization promises big savings for businesses, and few are decrying its influence. But is it always the answer? Are there SQL Server virtualization risks to learn about first? News
- See More: All on Microsoft SQL Server Consolidation and Virtualization
About Microsoft SQL Server Consolidation and Virtualization
SQL Server consolidation is by no means a new ideology. Database admins and developers have been looking into consolidation as a way to counter SQL Server sprawl for years now. With advancements in virtualization technology, however, the benefits of SQL Server consolidation are greater than ever before. This topic page features best practices and expert advice dealing with SQL Server virtualization and consolidation. Here you'll find info outlining the advantages of consolidating SQL Servers through virtualization, specifically through Microsoft Hyper-V. You'll also learn how enhanced scalability, manageability and performance features included with SQL Server 2008 and Windows Server 2008 help to simplify the consolidation process while at the same time maintaining high availability. Finally, be sure to check out our expert eBook "SQL Server consolidation: Why, when and how to consolidate SQL Servers" for all the basics to get you started.