Browse by Tags

All Tags » SQL Server (RSS)
Sorry, but there are no more tags available to filter with.
Friday, December 16, 2005 12:45 AM

SQL 2000 post SP4 Hotfix 8.00.2162

A SQL Server 2000 Post SP4 hotfix has just been released to the public. Bringing the SQL Server 2000 version number to 8.00.2162 This hotfix is a cumulative hotfix containing: Hotfixes that were built since SP4 shipped Hotfixes that were done for SP3...
Posted by Mike Epprecht | with no comments
Filed under:
Tuesday, November 08, 2005 11:13 PM

Microsoft SQL Server Management Studio Express - CTP - November 2005

Microsoft have been working on a free management tool for SQL Server 2005 Express, and what they were working on during the betas was mostly tossed away in the July timeframe. Now, the CTP for the new tool, Microsoft SQL Server Management Studio Express...
Posted by Mike Epprecht | with no comments
Filed under:
Tuesday, November 08, 2005 11:04 PM

Scalable shared databases are supported by SQL Server 2005

Something that seems to have been added to SQL Server 2005 Enterprise Edition, very late in the development cycle, seems to be on of it's best features. The ability to have one DB, located on SAN, available to multiple SQL Servers at the same time, as...
Posted by Mike Epprecht | 1 comment(s)
Filed under:
Thursday, October 27, 2005 10:11 PM

SQL Server 2005 RTM Released to MSDN

The files just went up for RTM SQL Server 2005 and Visual Studio 2005 on MSDN Subscribers Downloads. A big 2747 MB download for SQL Server. :)
Posted by Mike Epprecht | with no comments
Filed under:
Monday, October 10, 2005 2:22 AM

SQL Server 2005 row level security

Ok, so Microsoft removed row level security from SQL Server 2005 early in the development cycle. Pity, but looks like it was just one of those trade-offs that needed to be made. A bunch of guys from Microsoft Consulting has produced a paper on how to...
Posted by Mike Epprecht | 1 comment(s)
Filed under:
Thursday, September 15, 2005 9:47 PM

SQL Server 2005 - Database Mirroring off the cards for RTM.

So, Database Mirroring will not be "on" in SQL Server 2005 when it releases. From what I have read, it looks like it is not performing up to expectations. You can still enable it, but it's probably going to be one of those "we told you so" scenarios....
Posted by Mike Epprecht | with no comments
Filed under:
Sunday, August 28, 2005 12:09 AM

Windows Task Scheduler (a.k.a Task Scheduler) and SQL Server 2000/2005

After the problems on the SQL Server 2000 cluster with the new hotfix installer, a case was opened with Microsoft Support engineer allocated to us (see article prior to this). Well, after some more looking, SQL Server 2005 will use Windows Task Scheduler...
Posted by Mike Epprecht | 1 comment(s)
Filed under:
Wednesday, August 24, 2005 5:59 PM

SQL Server 2000 post SP4 hotfixes don't install on all nodes of a cluster

I recently installed a new Windows 2003, SQL Server 2000 cluster. Then added SQL Server 2000 SP4 and applied hotfix 2040 (KB 899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000...
Posted by Mike Epprecht | 7 comment(s)
Filed under:
Tuesday, July 12, 2005 10:52 PM

See you at SQLCON 05

I will be presenting at SQLCON 05 in Mainz, Germany, 20 and 21 September 2005. 2 sessions, “SQL Server 2005 High Availability“ and “SQL Server 2005 in a Secure Financial Environment“. The first one is really focusing on Clustering...
Posted by Mike Epprecht | with no comments
Filed under:
Sunday, June 19, 2005 3:57 PM

The hoxfix is here for AWE!

At last! The hotfix for SQL Server 2000's 32 bit SP4 AWE issue has been released. http://support.microsoft.com/?kbid=899761 It takes the build to 2040. Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft...
Posted by Mike Epprecht | with no comments
Filed under:
Tuesday, June 07, 2005 8:55 PM

The week of 7 November 2005

Yes, it is now public, the week of 7th November 2005 will be the launch of SQL Server 2005 (with Visual Studio .NET 2005). 5 Months of beta testing......and with the June 2005 CTP of SQL Server 2005 on MSDN and Betaplace, if we don't find the bugs now...
Posted by Mike Epprecht | 1 comment(s)
Filed under:
Sunday, May 15, 2005 11:05 PM

Will you be at SQL PASS Community Summit in September?

http://www.sqlpass.org/events/summit05/index.cfm Make sure you get to THE SQL Server conference of the year. Even CELKO will be there, a very rare occurrence, presenting a session. If you don't know who CELKO is, Google for his name in the newsgroups...
Posted by Mike Epprecht | with no comments
Filed under:
Sunday, May 15, 2005 10:59 PM

The cycle of SQL Server 2005

PASS European Conference last week in Munich brought some clarity. The jist of the release cycle is that Microosft can not pass up Tech Ed in June to do a release of a CTP. And after that, there will be another CTP, and then, if everything goes right...
Posted by Mike Epprecht | with no comments
Filed under:
Sunday, May 15, 2005 10:48 PM

Time to write a book

I have been wondering, should I write a book on SQL Server 2005? Not one of those that go on-and-on-and-on about how to learn to read 1'200 pages, with a bit of SQL Server thrown in to make the title valid.. Well, Jens Süßmeyer and I have begun...
Posted by Mike Epprecht | with no comments
Filed under:
Saturday, May 14, 2005 2:40 AM

SQL Server 2000 SP4 problems with AWE

Looks to be a bit of a wild one. SQL Server 2000 SP4 introduced a bug where only 1/2 the RAM can be accessed by SQL Server when AWE is enabled. So, it you have 16GB, SQL Server will only use 8GB. There is a Microsoft KB article # 899761 that describes...
Posted by Mike Epprecht | 1 comment(s)
Filed under:
Friday, May 06, 2005 11:11 PM

SQL Server 2000 SP4

Service Pack 4 for SQL Server 2000 is now available. It has been a long time in beta, but before you install it (especially on production), read the readme that comes with it. There are changes that may affect the way some of your applications behave...
Posted by Mike Epprecht | with no comments
Filed under:
Tuesday, April 26, 2005 11:33 PM

SQL Server 2000 on x64

The question has come up a few times in the newsgroups. Does SQL Server 2000 run on x64? SQL Serrver 2005 supports it already, but SQL Server 2000 does not. Service Pack 4 for SQL Server 2000 was mooted to support it. The answer I got from Microsoft today...
Posted by Mike Epprecht | with no comments
Filed under:
Wednesday, April 20, 2005 10:16 AM

April CTP is 'feature complete'

It is official that what is in the April CTP, is what will, with a 99.999% probability, be in the RTM of SQL Server 2005. Microsoft is saying that it is 'feature complete', so from here onwards, it is bug fixes and performance enhancements only. The letter...
Posted by Mike Epprecht | with no comments
Filed under:
Tuesday, April 19, 2005 11:54 PM

April CTP install is failing

Well, the SQL Server 2005 April CTP is failing on installing the database components. In the Beta newsgroups, more people are popping up with the same issue, mostly Express Editions. Some of the error: Product : SQL Server Database Services Error : SQL...
Posted by Mike Epprecht | 3 comment(s)
Filed under:
Tuesday, April 19, 2005 12:51 AM

SQL Server 2005 Beta 2, April CTP Ships

So, the long awaited April CTP for SQL Server 2005 went up on MSDN downloads today. VS.NET 2005 Beta 2 went up on Friday. The SQL Server install requires Windows Installer v3.0 (Windows XP SP2 and Windows Server 2003 SP1 have it already, other platforms...
Posted by Mike Epprecht | with no comments
Filed under:
More Posts Next page »