Skip Links

Network World

Ross Mistry

A first look at Microsoft SQL Server 2008 R2

Prepare for SQL Server 2008 R2
Submitted by Ross Mistry on Fri, 07/24/09 - 8:49pm.

A first look at Microsoft SQL Server 2008 R2

At TechEd North American 2009, Microsoft announced that its next release of SQL Server - codenamed Kilimanjaro - will now be dubbed SQL Server 2008 R2.

Although IT professionals and the general public are used to seeing R2 at the end of Microsoft product releases, many of them still want clarification on what it means for SQL Server.

Read more

WEBINAR - HOW TO CREATE A COST EFFECTIVE SQL SERVER 2008 FAILOVER CLUSTER - STEP BY STEP

Step by Step Intructions on Implementing a SQL Server 2008 Failover CLUSTER
Submitted by Ross Mistry on Thu, 07/16/09 - 1:30pm.


HOW TO CREATE A COST EFFECTIVE SQL SERVER 2008 FAILOVER CLUSTER

Read more

Troubleshooting a Failed SQL Server 2008 Installation

SQL Server 2008
Submitted by Ross Mistry on Wed, 07/08/09 - 5:39pm.

Troubleshooting a failed SQL Server 2008 installation

SQL Server 2008 introduces significant enhancements that make installation even easier and more seamless compared to its predecessors.

The SQL Server 2008 Installation Center offers solutions providers a tremendous number of options for planning, installing, upgrading and maintaining a SQL Server implementation.

However, even with these new tools and features, an installation may fail, and solutions providers must understand how to troubleshoot these installations.

Read more

I am a PC, I am a MVP and I love Windows 7

Submitted by Ross Mistry on Fri, 03/06/09 - 1:47pm.

It sounds like I am drinking the MS cool aid huh?  I just returned from the Microsoft MVP Summit in Seattle and had a spectacular time.  There was approximately 1500 to 2000 MVPs from all over the world present at the summit.  As a SQL Server MVP, I had the opportunity to network with my SQL colleagues and attend sessions on what's new for SQL Server 11, what's new for Windows Server 2008 R2 and Windows 7.  In addition, there was plenty of interactive sessions and round table discussions which allowed us to directly influence the feature sets of the new technologies.

Read more

SQL Server 2005 Service Pack 3 available via Microsoft Update

Submitted by Ross Mistry on Mon, 01/26/09 - 10:30pm.

SQL Server 2005 Service Pack 3 available via Microsoft Update

FYI…SQL Server 2005 SP3 has been available on the Microsoft Download Center
since 12/15/2008.  However, as of tomorrow SQL Server 2005 Service Pack 3 will be available via Microsoft Update.  Therefore, watch for the download if you have configured automatic updates.

Read more

Reduce IT Spending While Still Upgrading to SQL Server 2008

Submitted by Ross Mistry on Wed, 01/14/09 - 5:19pm.

With the economy taking a dive many IT managers are concerned over spending and not too sure if they should upgrade their database applications to SQL Server 2008.  The latest features and functionality included out-of-the-box with SQL Server 2008 will allow IT managers to save a tremendous amount of money and at the same time reduce management costs, hence it is worth the investment and you should upgrade to SQL Server 2008. 

Read more

Global Knowledge training, and Microsoft library giveaway winners

Submitted by Microsoft Subnet on Tue, 01/13/09 - 6:45pm.

Microsoft Subnet is happy to announce our next round of winners for our monthly giveaways. Manisha Palsana, a sales CRM/BI administrator for Recall Corp. won the grand prize of a free Microsoft training course of her choosing, worth up to $2,995 from Global Knowledge.

Read more

Happy New Year!!! Microsoft SQL Server 2008 Management and Administration Book Released

Submitted by Ross Mistry on Thu, 01/01/09 - 2:11pm.

Happy New Year!!!  SQL Server 2008 Management and Administration Book Released

Read more

Introduction and Best Practices for IT Managers and Implementers

Submitted by Ross Mistry on Thu, 12/18/08 - 11:05am.

I wanted to reintroduce myself to both the audience at Networkworld.com and the IT Manager Community Hub on TechNet. My name is Ross Mistry; I am a consultant, author and SQL Server MVP specializing in designing and implementing solutions with Microsoft technologies. Typically I have been requested to blog on networkworld.com when I release a new book. Although, my latest title (SQL Server 2008 Management and Administration) will be shipping in the next few days, I plan on sticking around and blogging for a bit longer.

Read more

High-availability options in SQL Server 2008

Submitted by Ross Mistry on Thu, 10/30/08 - 8:14pm.

Databases are the backbone of every organization. They're used to run Internet and intranet applications, line-of-business systems, human resources applications and business intelligence solutions.

Read more

Leveraging the New SQL Server 2008 Activity Monitor Performance Dashboard

Submitted by Ross Mistry on Wed, 09/03/08 - 12:25pm.

The SQL Server Activity Monitor is one of the first tools a DBA should leverage when there is need to gain a quick overview of a SQL Server 2008 system's performance.  Activity Monitor has been completely rewritten in SQL Server 2008 and compared to its predecessors it is no longer limited to displaying Processes, Locks by Object, and Locks by Process.  Activity Monitor introduced a newly redesigned performance dashboard with intuitive graphs, performance indicators with drill down and filtering capabilities.  The new tool's look and feel is very similar to the Resource Monitoring tool found in Windows Server 2008; however, the information captured and presented is broken do

Read more

USING HIGH-AVAILABILITY OPTIONS IN EXCHANGE 2007

Submitted by Ross Mistry on Mon, 08/11/08 - 11:40am.

 

Email is typically one of the most mission-critical applications for a company. So it makes sense that your customers are striving for high availability within their messaging infrastructure. To get them there, you need to fully comprehend the high-availability options in Microsoft Exchange Server 2007. There are four basic options. We break them down to help you determine which makes the most sense for a particular customer.

Read the rest of this tip based on the article I wrote.

Read more

SQL Server 2008 arrives -- SQL Server resources from Microsoft Subnet

Submitted by Microsoft Subnet on Wed, 08/06/08 - 7:13pm.

The big news today for Microsoft's enterprise customers is that the much delayed SQL Server 2008 has finally arrived. Microsoft Backoffice blogger Ross Mistry says that the English version is available via download to anyone who has an MSDN subscription. The release of SQL Server 2008 includes a myriad of new features such as Policy Based Management, Resource Governor, spatial data support, reworked Reporting Services and much more... Here are some SQL Server resources to help you prepare for this major release:

Read more

FINALLY - SQL Server 2008 RTM Available for Download

Submitted by Ross Mistry on Wed, 08/06/08 - 5:44pm.

After months of delays, speculation that the release would take place towards the end of september, maybe pushed to Q4...SQL Server 2008 RTM is finally here!!!

English Downloads are available now for those who have an MSDN subscription.

SQL Server 2008 Installation Strategies and Best Practices - Part 2 of 5. New Installation, Upgrade or Transition?

Submitted by Ross Mistry on Thu, 07/24/08 - 1:35am.

SQL Server 2008 Installation Strategies and Best Practices

Part 2 of 5 

Read more

SQL Server 2008 Installation Strategies and Best Practices - Part 1 of 5

Submitted by Ross Mistry on Fri, 07/18/08 - 12:47am.

SQL Server 2008 Installation Strategies and Best Practices

Part 1 of 5

Read more

Microsoft Says SQL Server 2008 To Ship This Quarter

Submitted by Ross Mistry on Thu, 07/10/08 - 7:42pm.

Many have been speculating that Microsoft will not ship SQL Server2008 this quarter.  However, Microsoft obliquely announced at its Worldwide Partner Conference this week in Houston that SQL Server 2008 is on pace for a release this 3rd quarter. 

 I am assuming the product will ship on the final day of the 3rd quarter - so speculating end of September. 

Thoughts?  Do you believe MS will be ready or will SQL Server 2008 ship towards the end of this year?

 

Discontinued Database Engine Functionality in SQL Server 2008

Submitted by Ross Mistry on Sat, 07/05/08 - 7:35pm.

I am currently working on my latest book - SQL Server 2008 Management and Administration.  As I am writing the installation chapter, I thought it would be beneficial to share some thoughts as many folks only discuss new features.  Not only it is it essential to understand the new features and functionally associated with SQL Server 2008's Database Engine Services, however, it is equally important to understand older elements which have been depreciated in SQL Server 2008.  The following links display a list of depreciated elements which are no longer supported or associated with Database Engine Services.

Read more

Teredo Tunneling Pseudo-Interface Errors when Implementing SQL Server 2008 Failover Clustering on WIndows Server 2008

Submitted by Ross Mistry on Wed, 06/18/08 - 6:09pm.

So last weekend I was working on my latest book, SQL Server 2008 Management and Administration and was finalizing the SQL Server 2008 chapter on Failover Clustering and ran into a few issues. 

Read more

Windows Server 2008 High Availability Alternatives - Failover Clusering & Network Load Balancing

Submitted by Ross Mistry on Mon, 06/16/08 - 3:04pm.

Many of my clients frequently ask me to explain the high availability alternatives included in Windows Server 2008.  Basically, you are looking at either Failover Clustering or Network Load Balancing.  Anyhow, I wrote an article about the topic and it can be found at the following link.

Enjoy!!!

Searchsystemchannel.com

Failover clustering & Network load balancing Drive High Availability

Read more