Archive

Archive for November, 2007

Sydney SSUG Meeting (Nov 2007)

Sydney SQL Server User Group Meeting for November 2007

Victor Isakov will be presenting at the Sydney SQL Server User Group for November 2007.

Session 1: SQL Server 2005 Locking Architecture

Performance problems can be related to concurrency issues, as opposed to hardware/resource issues. Consequently it is important for both the developer and the DBA to understand how locking works. In this session Victor will examine SQL Server’s locking architecture and how to configure and troubleshoot locking.

Session 2: SQL Server 2005 DBA Best Practices

In the second session Victor is going to draw from his expertise in the field and present a number of best practices in the areas of database engine configuration, database configuration, database consistency checks and disaster recovery. A very practical session for DBAs of all levels.

Categories: SQL Server User Group

SQL Server 2005 PHP Driver

SQL Server 2005 Driver for PHP Community Technology Preview (October 2007)

Microsoft has released a new SQL Server 2005 Driver for PHP.

The SQL Server 2005 Driver for PHP Community Technology Preview (CTP) download is available to all SQL Server users at no additional charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2000.

SQL Server 2005 Driver for PHP Community Technology Preview (October 2007)

Categories: Downloads

-T1118

Trace Flag -T1118

Lorem ipsum.

Trace flag -T1118 applies to SQL Server 2000 SP4 and SQL Server 2005.

Categories: Trace Flag

8 April 2008

Mainstream Support for SQL Server 2000 Retires on 8 April 2008

Time is running out…

Lorem ipsum

According to Microsoft mainstream support for SQL Server 2005 will be retired on the 8th April 2008.

 

Products Released

General Availability

Mainstream Support Retired

Extended Support Retired

SQL Server 2000
64-bit Edition

30 November 2000

8 April 2008

9 April 2013

SQL Server 2000
Developer Edition

30 November 2000

8 April 2008

9 April 2013

SQL Server 2000
Enterprise Edition

30 November 2000

8 April 2008

9 April 2013

SQL Server 2000
Standard Edition

30 November 2000

8 April 2008

9 April 2013

SQL Server 2000
Workgroup Edition

1 June 2005

8 April 2008

9 April 2013

SQL Server 2000
Windows CE Edition 2.0

16 December 2002

8 January 2008

8 January 2013

The following table describes the difference between Mainstream and Extended Support:

 

Support Provided

Mainstream Support Phase

Extended Support Phase

Paid support
(per-incident, per hour, and others)

X

X

Security update support

X

X

Non-security hotfix support

X

Requires extended hotfix agreement, purchased within 90 days of mainstream support ending.

No-charge incident support

X

 

Warranty claims

X

 

Design changes and feature requests

X

 

Product-specific information that is available by using the online Microsoft Knowledge Base

X

X

 

X

X

Furthermore, Microsoft does not issue further service packs during the Extended Support Phase.

Categories: Uncategorized

The Little Computer Running SQL Server

The Little Computer Running SQL Server Underneath the Receptionist’s Desk…

I am continually surprised by the "lack of respect" or "lack of awareness" by organizations when it comes to SQL Server and the solutions they have implemented based on its technology. Surely the most important component of any organization is their data, their intellectual property. Which invariably is kept inside a database. And more often than not, in a SQL Server database.

So why don’t companies proactively ensure that these databases are "performant", are available, have been configured to industry best-practice? Why have there been no disaster recovery plan designed in the case of hardware failure or accidental data deletion? Why have they not evaluated the cost of implementing a high-availability solution versus the cost to the business if that "little computer running SQL Server underneath the receptionist’s desk" fails?

Organizations have no problems with insuring against fire or ensuring that their computers and telephones work efficiently. They have no problems with engaging a fire inspector to make sure that the fire extinguishers work. Or invest in soft skills training to ensure their sales team performs well. Yet they do not seem to want to ensure that their backup plans work, or that their databases perform well.

Furthermore, they are generally quite happy to let any contractor who puts "have experience with SQL Server" on their resume to configure and maintain their SQL Server environment. They certainly would not let anyone inspect a fire extinguisher! Nor let anyone who put "I can sell" coach their sales staff. I would hope ;o)

Let me illustrate my point by two engagements that I performed very recently.

In the first instance I was asked to troubleshoot performance problems for an international transport company. They had a SQL Server based solution that was being used across Australia, running on a quad-processor system with 8GB of RAM. Performance had been degrading over the last couple of months, to the point that they had to reboot the server every so often, typically during production hours, as it had simply "hung". (I might briefly add that they had not kept the error log files after each reboot, thus deleting vital troubleshooting information.) Otherwise the processor utilization maxed out at 100% consistently from 11AM to 2PM during week days. This amounted to a substantial loss in productivity and ultimately, I suspect a poor customer experience.

My initial reaction was "Why have we gotten to this stage? These problems could have been solved a month earlier, upon the problems first materializing."

In the second instance, I was asked to perform a "health-check", as they are commonly called, for a national media company. What had precipitated this health-check? Well as I discovered in the preliminary meeting, someone had accidentally deleted some data. When the IT staff attempted to perform a restore they discovered that their backups had "inexplicably stopped working" 3 months prior. Subsequently there was no confidence in how any of their SQL Server instances had been configured, how the backup strategy had been implemented, and so on.

Again, my initial reaction was "Why did it take such an occurrence for the organization to ensure that their SQL Server solution was optimal and robust?”

It would seem that the industry generally does not have a "healthy respect" or "awareness" of SQL Server’s technology and how to best implement a solution based on that technology. Have Microsoft lulled us into a false sense of security by espousing how easy SQL Server is to maintain and how well it performs "out of the box"? As I have often stated, Sybase DBAs seem to know Sybase better, and Oracle DBAs seem to know Oracle better compared to SQL Server DBAs. SQL Server has the lion’s share of the database engine market, and a corresponding demand for SQL Server "experts". The natural consequence of this demand is potentially hiring junior SQL Server DBAs by organizations (or forgoing them altogether) due to a lack of senior DBAs, or SQL Server DBAs not having enough time to skill themselves up in the latest technology or best practices.

Perhaps the Australian mantra "She’ll be right mate" (or your local equivalent) will suffice, until that "little computer running SQL Server underneath the receptionist’s desk" fails!

Categories: Editorial

SQL Server 2005 SP2 Cumulative Update 5

Cumulative Update Package 5 for SQL Server 2005 Service Pack 2

Microsoft has announced cumulative update package 5 for SQL Server 2005 Service Pack 2. It "will be released in the December 2007 timeframe".

http://support.microsoft.com/kb/943656

Categories: Patches

Exploits of a Mom

Thanks to boB Taylor…

Categories: Uncategorized