Browse by Tags

• 2000
• 2005
• 2008
• Certification
• Clustering
• DB Mail
• DTS
• Integration Services
• Memory
• Mirroring
• Performance
• Resources
• Security
• Tools
• Webcasts
• Whitepapers
• Windows

• SQL Server and Windows Memory

  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... Posted May 15 2008, 03:02 PM by robcarrol with | with 2 comment(s) Filed under: SQL Server, Windows, Memory

• Oracle Unbreakable... Not a Chance !

  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... Posted Apr 17 2008, 10:33 AM by robcarrol with | with no comments Filed under: SQL Server, Security

• SQL Server 2000 Full-Text Issues After Failover

  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... Posted Mar 12 2008, 06:00 PM by robcarrol with | with 1 comment(s) Filed under: SQL Server, Clustering, 2000

• SQL2K8 Launch Thoughts

  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... Posted Feb 29 2008, 07:41 PM by robcarrol with | with no comments Filed under: SQL Server, 2008

• SQL Server 2005 Bug Report

  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 Posted Feb 21 2008, 07:43 PM by robcarrol with | with no comments Filed under: SQL Server, 2005, Tools

• SQL Server 2008 Certifications

  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... Posted Feb 19 2008, 11:50 PM by robcarrol with | with no comments Filed under: SQL Server, 2005, 2000, Certification

• Indexing Strategies

  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... Posted Feb 16 2008, 12:39 AM by robcarrol with | with 2 comment(s) Filed under: SQL Server, Tools, Performance

• PFE Technical Rollups

  The latest Technical rollup mails from Premier Field Engineering are available here . Posted Feb 15 2008, 12:28 AM by robcarrol with | with no comments Filed under: SQL Server

• Top Tips for SQL Server Clustering

  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 ! Posted Feb 13 2008, 05:10 PM by robcarrol with | with no comments Filed under: SQL Server, 2005, Windows, Clustering

• SQL 2008 Resource Governor

  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... Posted Feb 12 2008, 09:29 AM by robcarrol with | with no comments Filed under: SQL Server, 2008