Welcome to MSDN Blogs Sign in | Join | Help

October 2009 - Posts

Thursday, October 29, 2009 9:38 PM

How to use PsGetSid for SQL Server

To translate a SID to a name or vice versa, you can use this tool from sysinternals: PsGetSid v1.43 http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx You can use it to translate the SID in these registry keys into the SQL Domain Groups or
Posted by CindyGross | 0 Comments
Filed under:
Wednesday, October 28, 2009 5:22 PM

Checklist for upgrading to a new version of SQL Server

Here is the basic process for a full version upgrade (such as 2000 to 2008) of the SQL Server engine. The steps will be different for RS or AS. I did not include all the details of variations such as replication, mirroring, log shipping, full-text search,
Posted by CindyGross | 0 Comments
Filed under:
Wednesday, October 28, 2009 2:47 PM

How People Abuse Their SQL Server Transaction Log - Things NOT to Do

Care and Feeding of the Transaction Log Want to learn more about how the transaction log works? Kalen Delaney, celebrated author of SQL Server 2008 Internals and the Inside SQL Server series as well as a world class trainer and performance tuner, is giving
Posted by CindyGross | 0 Comments
Friday, October 23, 2009 4:15 PM

Considerations for installing SQL Server on VMWare

You still need to follow the standard SQL Server best practices, security, and preparation when you install on a VMware VM. Below are some additional considerations with regards to VMware. Key points: ยท You must double check that your combination of VMWare,
Posted by CindyGross | 0 Comments
Friday, October 23, 2009 4:06 PM

Checklist for installing SQL Server 2005 as a clustered instance

Checklist for installing SQL Server 2005 as a clustered instance Windows/Hardware 1) Verify the Windows cluster is set up per basic best practices and that basic failover works. 2) Verify you have the latest patches, especially security patches, for Windows.
Posted by CindyGross | 0 Comments
Thursday, October 22, 2009 1:42 PM

SQL Server and TCP Chimney

If you are using SQL Server or Analysis Services: I suggest you double check that your SNP settings, especially TCP Chimney Offset, are all OFF unless your NIC vendor has verified they support it and you have installed their version of drivers that support
Posted by CindyGross | 0 Comments
Monday, October 19, 2009 2:22 PM

There is still time to register for the 2009 SQL PASS Summit

If you are considering going to SQL PASS this year Nov 2-5 there are several different discounts available for the main conference (Tues, Wed, Thu). You can only use one of the discounts, you can NOT add them together. I will be at PASS, and I hope to
Posted by CindyGross | 1 Comments
Friday, October 16, 2009 4:51 PM

How to automate Update Statistics

For SQL Server 2005 here are some options to update statistics with the default settings that samples the data instead of reading every row: 1) If you are also defragmenting your database with REBUILD and/or REORGANIZE you will want to integrate your
Posted by CindyGross | 0 Comments
Friday, October 16, 2009 4:44 PM

SQL Server with NetApp SAN

If you are planning to use NetApp as the SAN for your SQL Server instance(s), take a look at these documents in addition to the normal SQL Server IO planning best practices documents. TR-3779 Sizing best practice guide. http://media.netapp.com/documents/tr-3779.pdf
Posted by CindyGross | 0 Comments
 
Page view tracker