Welcome to MSDN Blogs Sign in | Join | Help

August 2008 - Posts

Friday, August 29, 2008 4:25 PM

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different
Posted by psssql | 7 Comments
Friday, August 29, 2008 4:08 PM

How It Works: Creating An EndPoint Adds An Entry To SysLogins

My SQL Server does not have individual windows users established as separate logins.   Instead it has the Domain\SQLUsers group established as a WINDOWS GROUP login.  You can review your mappings using the following DMVs. select * from
Posted by psssql | 1 Comments
Filed under: ,
Thursday, August 28, 2008 6:54 PM

SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained...

Many of you may have read my post about dependencies with Visual Studio 2008 SP1 and the .Net Framework 3.5 SP1 and SQL Server 2008. I have some related information to provide to you about SQL Server 2008 Express. If you are a user of SQL Server 2008
Posted by psssql | 5 Comments
Wednesday, August 27, 2008 10:18 PM

Using Locking Like Synchronization Object

This post is more of a T-SQL trick and NOT a recommendation practice, but since I addressed this in a recent customer case I thought I would share it. Problem:   Application needs to lock a row for the duration of the transaction and ensure no data
Posted by psssql | 2 Comments
Filed under: ,
Tuesday, August 26, 2008 8:17 PM

Why you should read the Release Notes for SQL Server 2008

Do the release notes really ever contain anything that can help you with your deployment of a product? Well in the case of SQL Server 2008, the answer is YES. Here are the following benefits for using the Releases Notes which can be found at the following
Posted by psssql | 1 Comments
Filed under:
Monday, August 25, 2008 4:51 PM

IsNumeric Returns (1/TRUE) and I Expected (0/FALSE)

The string '100,200,300' has fooled many a customer and support engineer alike. select cast('100,200,300' as bigint) Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to bigint. One might argue that this is a bigint value.  However,
Posted by psssql | 2 Comments
Filed under:
Tuesday, August 19, 2008 9:18 PM

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page
Posted by psssql | 2 Comments
Filed under: , ,
Tuesday, August 19, 2008 2:12 PM

Timeouts when connecting to Named Instances

When connecting to a SQL Named Instance, you may encounter a Timeout error when trying to connect to it if the client is Vista or Windows 2008 with the client Firewall enabled. This particular issue is only present if you are running the SQL 2008 Browser
Posted by psssql | 1 Comments
Monday, August 18, 2008 5:15 PM

Is it really the released version of SQL Server 2008?

The following is a question we have received from a few folks who were concerned after installing SQL Server 2008 that they did not have the final released build. When you use SQL Server Management Studio and select the Help/About menu choice to see what
Posted by psssql | 4 Comments
Filed under:
Monday, August 11, 2008 10:31 PM

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained....

PLEASE NOTE: This blog post has been updated from its original posting to clarify other details about installation of SQL Server 2008 and Visual Studio 2008 SP1. I must say that I'm personally proud to see our release of SQL Server 2008. I've been involved
Posted by psssql | 22 Comments
Filed under: ,
 
Page view tracker