Network World
Wednesday, October 8, 2008
DNSstuff.com
Get information about your IP
IP Information
50+ On-demand DNS and network tools

Author Expert: Ross Mistry

Microsoft Subnet

Navigation

Leveraging the New SQL Server 2008 Activity Monitor Performance Dashboard

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

 

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

FINALLY - SQL Server 2008 RTM Available for Download

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.

Microsoft Says SQL Server 2008 To Ship This Quarter

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

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

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

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

Ross Mistry speaking about SQL Server Security on June 10, 2008 @ Microsoft's San Francisco Office

For those of you in the local San Francisco Bay Area, I will be speaking about hardening a SQL Server 2008 Implementation at Microsoft's San Francisco Office. For more information on the session abstract and directions - read below!!!

Thanks

Ross

San Francisco – Wednesday, June 11 - 6:30 p.m.
Ross Mistry, Partner and Principal Consultant at Convergent Computing, will be talking about “Hardening a SQL Server 2008 Implementation”


Read more

June 5, 2008 - Microsoft Launches SQL Server 2008

Fooled ya...it is just RC0

On June 5th, Microsoft launched SQL Server 2008 Release Candidate 0.  Sorry, it is not the final production version, just RC0.  Anyhow - we are one more step closer to the final release, the product can be downloaded from Microsoft's MSDN website.  You will require MSDN membeship to obtain the download, however, it will be publically available shortly.  The editions supported in RC0 include: Developer, Enterprise, Standard, Web Edition and Workgroup

Read more

Speaking at SQL Server Magazine Connections - Orlando Florida - April 20th to 23rd

It is that time of year again, no not Easter -- SQL  Server Magazine Connections April 20-23, 2008.  Now in its eight year, SQL Server Magazine Connections comes to the Marriott Orlando World Center in Orlando, Florida.  Dive into the release of SQL Server 2008 with Microsoft architects and industry experts to keep your competitive edge.   In addition, interact with and learn from an all-star SQL Server lineup, train with Microsoft architects and top notch industry speakers and also network with your colleagues to build a valuable resource of peers.

Read more

Mainstream SQL Server Support to Expire and Extended Support Could Cost You $50K

With the release of SQL Server 2008 around the corner, mainstream support for SQL Server 2000 will expire by April 8, 2008.  Therefore, start planning your upgrade or migration strategy, otherwise expect to pay up to 50K for an extended support contract on the legacy SQL Server 2000 product. 

For more information on Microsoft's Support Lifecycle for SQL Server 2000 view this link.

 http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=17&y=10

Congratulations Windows Server 2008 Unleashed winners:

Congratulations to the Windows Server 2008 Unleashed winners:

Doug Pounds
Jim Sisneros
John Maddox
Gloria Dornin
Anikka Wattnem
Stephen Hatfield
Shaun Wallner
Kirk Lashbrook
Robert Shullich
Dewey D. Knox
Paul Wagner
Robert Verderame
Nicholas Hunt
Ray Battenfield
Ryan Booth

Read more

SQL Server 2008 February Community Technology Preview (CTP v6) is HERE!!!!

The latest Community Technology Preview of SQL Server 2008 is available.  SQL Server 2008 February CTP aka version 6 can be obtained at the following link.

http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en

This link provides a list of new features and funtionality included with SQL Server 2008 Feb CTP.

Read more

Best Practices for Hardening a SQL Server 2005 Implementation

When working with my customers on SQL Server security, I constantly get the same question, "What are some best practices for hardening my SQL Server implementation?" Over the years, I have come up with specific recommendations based on upon industry best practices and my experience. Following is a summary of best practices for hardening a SQL Server environment:

Read more

Which SQL Server 2008 Authentication Mechanism Should I Choose?

At present, SQL Server 2008 continues to support two modes for validating connections and authenticating access to database resources: (Windows Authentication Mode) and (SQL Server and Windows Authentication Mode) also known as "Mixed Mode".  Both of these authentication methods provide access to SQL Server 2008 and its resources.  Lets first examine the differences between the two authentication modes.

Read more

How to Optimize Windows Server 2008 for Branch Office Communications (PART 1 of 5)

PART 1 of 5 - Organizations’ Branch Office Concerns and Dilemmas when using Windows Server 2003

Read more

Let's Get Reacquainted & How to Optimize Windows Server 2008 for Branch Office Communications (Four Part Series)

I'mmmmm Back!!! 

So it has been a few months since the release of my SQL Server 2005 Management and Administration book and my last blog post.  Since then I have been co-authoring another title with a team of great authors (Rand Morimoto, Michael Noel, Chris Amaris, and Omar Droubi) We have finalized the manuscript of our new book Windows Server 2008 Unleashed - which is ready to ship in the next few weeks. 

Read more

Microsoft to Release Exchange Server 2007 Service Pack 1 on November 30th.

On November 30, you will be able to download Exchange Server 2007 with Service Pack 1. The list of new features in SP1 is long, including new deployment options, new features and improvements for each server role, improved integration with other applications, and even a new, third type of continuous replication.

Read more

How do I Simulate SQL Server 2008 Failover Clustering with Windows Server 2008 on a VMware Server???

So last night I was building a SQL Server 2008 failover cluster in a virtual environment with Windows Server 2008 on the free version of VMware Server.  When building clusters on VMware, I typically add the following additional items on both virtual guest machines; a virtual SCSI bus, virtual hard disks and then mark disk locking to false.    This usually does the trick and you can simulate a shared storage system between the two virtual servers, and then configure failover clustering. 

Read more

High Availability and Disaster Recovery of a Windows Networking Environment

For those who live or work in the San Francisco Bay Area or Sacramento and are interested in learning more about Windows high availability and disaster recovery, I will be co-presenting on High Availability and Disaster Recovery of a Windows Networking Environment along with Rand Morimoto.  We will have three sessions throughout the month of December.  Feel free to swing by for this free seminar.

Read more

SQL Server 2008 November CTP is Now Available for Public Download

Last week Microsoft reached an important milestone by announcing the release of the latest technology preview for SQL Server 2008.  The November CTP of SQL Server 2008 is packed with a myriad of new features and functionality which was not included in the previous CTP release. 

Read more

New Features and Functionality of SQL Server 2008

SQL Server 2008 has been significantly enhanced since the previously released versions. Moreover, the product continues to support Microsoft's data platform vision of mission-critical enterprise data platform, dynamic development, relational data, and business intelligence.

Read more

Selecting the Appropriate Recovery Model for a Database in SQL Server 2005

I frequently receive the same question from my clients and from the audience at my seminars - "Which recovery model should I use on my SQL Server databases?"  Basically, there isn't a right or wrong answer as each recovery model offers benefits and consequences.

Read more

My First Blog Entry - Ross Mistry Introduction

Firstly, let me introduce myself. My name is Ross Mistry and I have recently released a new book called Microsoft SQL Server 2005 Management and Administration.The book is based on SQL Server 2005 Service Pack 2 and addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, high availability and monitoring.

Over the next few months, expect to see blog entries related to SQL Server 2005, SQL Server 2008 and Windows Server 2008 . I am currently co-authoring my latest book, Windows Server 2008 Unleashed and will have the rough cut finalized by the end of next week. With that being said, expect to see blog entries rolling in starting November 1st.

Cheers and stay tuned!!!

Ross Mistry


About Ross Mistry

RSS feed Blog archive.

Ross Mistry, MCSE, MCDBA is a partner and principal consultant for Convergent Computing. As a lead architect he designs and implements SQL Server, Active Directory and Exchange solutions for fortune 500 organizations with a global presence. His SQL Server specialty is designing and implementing high availability, site resilience and disaster recovery solutions. Ross also focuses on SQL Server database administration, database development and Business Intelligence. Ross has also taken on the roles of lead author, co-author, technical writer and contributing writer for a number of books, including SQL Server 2005 Management and Administration and Windows Server 2008 Unleashed. Mistry is also a public speaker and conducts seminars on Microsoft topics around the world on SQL Server, Active Directory and Exchange.

RSS feed Microsoft news RSS feed

Advertisement: