Welcome to TechNet Blogs Sign in | Join | Help

May 2008 - Posts

Tuesday, May 27, 2008 5:00 PM

Forthcoming UK SQL User Group Meetings - Leeds, Edinburgh, London

Regional Meetings of the UK SQL Server User Group coming up in the next couple of weeks: LEEDS AREA SQL SERVER USER GROUP: THURSDAY 29TH MAY 18:30 - 21:00 : LEEDS http://sqlserverfaq.com/?eid=116 Martin Bell - Whats New in SQL Server 2008 T-SQL. Martin
Posted by robcarrol | 1 Comments
Filed under:
Monday, May 26, 2008 12:40 AM

Detecting SQL Server 2005 Blocking

Database queries should be able to execute concurrently without errors and within acceptable wait times. When they don't, and when the queries behave correctly when executed in isolation, you will need to investigate the causes of the blocking. Generally,
Posted by robcarrol | 0 Comments
Thursday, May 22, 2008 6:00 PM

SQL Q&A Column in TechNet Magazine

Paul Randall has started a new SQL Q&A column in TechNet magazine, which is definitely worth a read. As expected, there is some great advice regarding Database Mirroring, corruption and database fragmentation. http://www.sqlskills.com/blogs/paul/2008/05/19/InPrintTechNetMagazineJune2008SQLQAColumn.asp
Posted by robcarrol | 0 Comments
Thursday, May 22, 2008 8:30 AM

Open Source Error Opens Big Security Hole

A programming error in an open source security project introduces profound vulnerabilities in millions of computer systems. http://www.technologyreview.com/Infotech/20801/?a=f
Posted by robcarrol | 2 Comments
Filed under: ,
Wednesday, May 21, 2008 4:32 PM

Hyper-V RC1 Released

Hyper-V Release Candidate 1 for Windows Server 2008 was released on the 20th May. This is a full functionality release and provides improvements to security, stability, performance, user experience, forward compatibility of configurations, and the programming
Posted by robcarrol | 0 Comments
Filed under: ,
Monday, May 19, 2008 8:53 PM

Support Webcast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008

A new Level 300 support webcast has been scheduled for Monday the 9th of June, 10:00 AM Pacific Time. The summary of the session is as follows: This Support WebCast focuses on how to plan, implement, and administer a Microsoft SQL Server 2005 failover
Posted by robcarrol | 2 Comments
Sunday, May 18, 2008 8:30 AM

SQL Server Locking

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as by
Posted by robcarrol | 2 Comments
Filed under: , ,
Friday, May 16, 2008 9:00 AM

SQL Server Statistics

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow
Posted by robcarrol | 6 Comments
Thursday, May 15, 2008 3:02 PM

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 by robcarrol | 2 Comments
Thursday, May 15, 2008 1:20 PM

Windows Memory (PAE/AWE/3GB)

PAE (Physical Address Extension) PAE is the added ability of the IA32 processor to address more than 4GB of physical memory. The following OS's can use PAE to take advantage of physical memory beyond 4GB: Microsoft Windows 2000 Advanced Server Microsoft
Posted by robcarrol | 1 Comments
Filed under: , ,
Wednesday, May 14, 2008 11:15 AM

DBCC CHECKDB

DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the
Posted by robcarrol | 0 Comments
Wednesday, May 07, 2008 5:07 PM

Windows Failover Clustering Overview

The host node in the failover cluster performs a "looks alive" check every 5 seconds. An IsAlive check is performed every 60 seconds using SELECT @@SERVERNAME. If this fails the IsAlive retries 5 times and then attempts to reconnect to the instance of
Posted by robcarrol | 1 Comments
 
Page view tracker