Browse by Tags

SQL Server and Windows Memory
15 May 08 03:02 PM | robcarrol | 2 comment(s)

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve...

Filed under: SQL Server, Windows, Memory

Oracle Unbreakable... Not a Chance !
17 April 08 10:33 AM | robcarrol | with no comments

Good article here comparing the Critical Updates fixes between SQL Server and Oracle and some of the mis-information peddled in the RDBMS world. Highlights include zero SQL Server critical update vulnerabilities since September 2004, which I think is...

Filed under: SQL Server, Security

SQL Server 2000 Full-Text Issues After Failover
12 March 08 06:00 PM | robcarrol | 1 comment(s)

I can't take credit for finding the solution to this as that goes to my colleague, but I thought I'd share a problem we experienced after failing over one of our production clusters last night. This is a SQL Server 2000 SP4 Enterprise Edition active/passive...

Filed under: SQL Server, Clustering, 2000

SQL2K8 Launch Thoughts
29 February 08 07:41 PM | robcarrol | with no comments

Been reading Dan Jones blog post regarding the delay to the launch of SQL Server 2008, and I think he makes some great points. There is obviously dissapointment from some people about the release date slipping back, but as Dan points out, a bad product...

Filed under: SQL Server, 2008

SQL Server 2005 Bug Report
21 February 08 07:43 PM | robcarrol | with no comments

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0

Filed under: SQL Server, 2005, Tools

SQL Server 2008 Certifications
19 February 08 11:50 PM | robcarrol | with no comments

As I am currently preparing for the MCDBA to MCITP 2005 upgrade exam (70-447) it may seem a bit premature to talk about SQL Server 2008 certifications, but there is a webcast available at Trika's blog (from the Microsoft Learning team) below. http://blogs...

Filed under: SQL Server, 2005, 2000, Certification

Indexing Strategies
16 February 08 12:39 AM | robcarrol | 2 comment(s)

I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have...

Filed under: SQL Server, Tools, Performance

PFE Technical Rollups
15 February 08 12:28 AM | robcarrol | with no comments

The latest Technical rollup mails from Premier Field Engineering are available here .

Filed under: SQL Server

Top Tips for SQL Server Clustering
13 February 08 05:10 PM | robcarrol | with no comments

As part of a current project I am working on, I came across this article , which includes a tip for clustering SQL Server workgroup edition using a combination of Windows clustering and virtual server !

Filed under: SQL Server, 2005, Windows, Clustering

SQL 2008 Resource Governor
12 February 08 09:29 AM | robcarrol | with no comments

I came across this post in Andrew Fryer's blog, which has a short demo of the SQL Server 2008 resource governor in action. For me, this will be one of the main drivers for moving to SQL Server 2008. Most of the issues I come across with unresponsive SQL...

Filed under: SQL Server, 2008

Free SQL Server 2008 E-Learning Available
11 February 08 03:32 PM | robcarrol | 2 comment(s)

There are some free e-learning tools available for SQL Server 2008 on the Microsoft E-learning site below: http://www.microsoft.com/learning/sql/2008/default.mspx There's also some free e-learning resourses for Windows Server 2008 here: http://www.microsoft...

Filed under: SQL Server, 2008

Update: Two-thirds of Oracle DBAs don't apply security patches
08 February 08 09:50 AM | robcarrol | 4 comment(s)

This scary article reminded me of a conversation I had with a colleague in the middle of a team meeting recently. This centred around the perceived lack of security of SQL Server compared to Oracle and the Slammer worm was cited as an example. The damage...

Filed under: SQL Server

Error with SQL Server 2005 Database Mail
02 February 08 11:45 PM | robcarrol | with no comments

I was passed an interesting issue with database mail to have a look at on one of our clustered production SQL Server systems earlier this week. We have a large multi-node PolyServe cluster running our SQL Server 2005 64-bit Enterprise Edition platform...

Filed under: SQL Server, DB Mail, 2005, Windows

Dual Database Monitor Tool
02 February 08 11:42 PM | robcarrol | with no comments

I was giving a database mirroring demo last week and needed a way to quickly demonstrate the automatic failover capabilities in SQL Server 2005. I was at a session at TechEd IT Forum last year run by Paul Randal and Kimberley Tripp and remebered seeing...

Filed under: SQL Server, Mirroring, 2005, Tools

DTS Support in SQL Server 2005
02 February 08 11:24 PM | robcarrol | with no comments

Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple...

Filed under: SQL Server, 2005, DTS, Integration Services, Tools