Welcome to MSDN Blogs Sign in | Join | Help

January 2009 - Posts

Friday, January 23, 2009 9:51 AM

SQL Server 2008 and Processors

Consider this scenario: - You want to migrate your current database solution to SQL Server 2008 - You want to make the maximum use of multiprocessing and multithreading - You want to know about how SQL Server 2008 makes use of multiple processors So the
Posted by John Daskalakis | 3 Comments
Thursday, January 22, 2009 11:37 AM

When you cannot connect to an instance of SQL Server

...you should first check these factors: o The SQL Server service might not be started. o The network protocols allowed might have benn disabled. o The network configuration of windows might be incorrect: - Try to ping the SQL Server using its windows
Posted by John Daskalakis | 1 Comments
Tuesday, January 20, 2009 10:20 AM

How to prevent local and domain administrators from accessing SQL Server?

The question most people ask is why someone who is local administrator of a machine where SQL Server is installed, they automatically have administartive access to SQL Server? The answer is: "due to the BUILTIN\administrators login". By default when the
Posted by John Daskalakis | 1 Comments
Monday, January 19, 2009 1:07 PM

Which Authentication Mode should I choose for my SQL Server?

When setting up your SQL Server you are given the option to choose the Authentication Mode. The modes are: o Windows Authentication: With this option whenever a user tries to connect to SQL Server he has to use a Windows user account. The SQL Server validates
Posted by John Daskalakis | 3 Comments
Friday, January 16, 2009 10:24 AM

SQL Server Replication performance and Network Latency

Replication over a slow network can be a real problem. There are however some actions you can perform to improve replication performance over a slow network: - Make sure the retention of the replication is low (usually 72 hours or less will be fine).
Posted by John Daskalakis | 1 Comments
Thursday, January 15, 2009 10:09 AM

Key points for setting up database mirroring in SQL Server 2008

Some key points to consider for Database Mirroring in SQL Server 2008 are: - The database that will be mirrored must be in the Full Recovery Model. - Both the Principal and Mirror instances must be of the same edition e.g. both are Enterprise edition
Posted by John Daskalakis | 1 Comments
 
Page view tracker