SQL PASS 2008

cgross@microsoft.com — Thu, 13 Nov 2008 16:09:47 GMT

I hope to see you at PASS this year!

Thursday, Nov 20, 2008

3p-415p

New book from Kalen Delaney!

cgross@microsoft.com — Wed, 22 Oct 2008 19:48:10 GMT

Kalen's new book is ready for pre-ordering!

Microsoft® SQL Server® 2008 Internals

http://sqlblog.com/blogs/kalen_delaney/archive/2008/10/23/SQL-Server-2008-internals-is-orderable.aspx

SQL Server 2008 CU1 available

cgross@microsoft.com — Tue, 23 Sep 2008 03:54:03 GMT

The first cumulative update is available for SQL Server 2008. I’ve compiled the link for the cumulative update plus some other SQL Server 2008 links that you may find useful.

How to change the collation of a SQL Server 2005 database

cgross@microsoft.com — Thu, 11 Sep 2008 04:03:40 GMT

Sometimes you need to change the collation of a database after you have created it and populated it with objects and data. So how do you change the collation?

SQL Injection attacks

cgross@microsoft.com — Wed, 25 Jun 2008 00:09:22 GMT

This year SQL injection attacks are being stepped up and even automated against SQL Server. While SQL injection attacks can occur against any DBMS, my blog will only address SQL Server.

How to estimate disk space needed for SQL Server

cgross@microsoft.com — Tue, 24 Jun 2008 15:44:58 GMT

So how do you estimate the amount of disk space needed for a server that runs SQL Server? My assumption in answering this is that you already know approximately how big the data/indexes/logs will be but need to know how much total disk space to request on the server. The information below is for SQL Server itself, not for Analysis Services or Reporting Services. My answer is really a list of questions, because once you answer the questions for your environment you'll have a good idea of how much space you need. This is an art, not a science, so there is no one right answer.

T-SQL Debugger

cgross@microsoft.com — Mon, 23 Jun 2008 23:18:30 GMT

Many people have asked where the TSQL debugger is for SQL Server 2005.

Boise SQL Server User Group - Kalen Delaney speaking June 25 at 530pm!

cgross@microsoft.com — Mon, 23 Jun 2008 15:44:19 GMT

This week at the Boise Library in the William F. Hayes Auditorium at 5:30pm on June 25:

Kalen Delaney, of Inside SQL Server fame, is looking forward to meeting local SQL Server enthusiasts and sharing some of her vast SQL Server knowledge with us. Kalen is currently the director of training for SQLTuners.net, and has recently published her first SQL Server training

SQL Server 2008 RC0

cgross@microsoft.com — Thu, 12 Jun 2008 18:09:45 GMT

SQL Server 2008 release candidate 0 (RC0) is now available for public download. Use the links below to download SQL Server, Books Online, the Feature Pack, and more.

Where to find SQL Server hotfixes, service packs, and cumulative updates

cgross@microsoft.com — Tue, 13 May 2008 17:43:06 GMT
Finding out which build is the latest or what fixes are included in a particular build can be difficult. These links should make that job easier.

How to test connectivity from a UDL

cgross@microsoft.com — Wed, 30 Apr 2008 21:31:16 GMT
A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services connectivity issues.

SQL Server Memory - Lock Pages in Memory

cgross@microsoft.com — Mon, 28 Apr 2008 13:53:33 GMT
Microsoft has recently revised the documentation on the below message due to our recent history with troubleshooting the warning:
A significant part of sql server process memory has been paged out.

SQL Server 2005 Service Broker References

cgross@microsoft.com — Mon, 14 Apr 2008 19:04:41 GMT

Have you heard about the new Service Broker functionality in SQL Server but don't know where to start with installing, understanding, or troubleshooting it? These links will help you get started.

Should new installations of SQL Server be on 64bit or 32bit?

cgross@microsoft.com — Wed, 09 Apr 2008 15:03:11 GMT

The switch from 32-bit to 64-bit systems can seem overwhelming. I have summarized the major changes and differences to help make your transition a bit smoother.

Become a SQL Hero

cgross@microsoft.com — Wed, 26 Mar 2008 23:30:22 GMT

http://blogs.msdn.com/sqlheroes/

Should SQL and AS share a machine?

cgross@microsoft.com — Mon, 24 Mar 2008 19:59:23 GMT

Do you put SQL and AS on the same machine or different machines? How do you configure memory on an AS box to avoid conflicts with other applications?

How to set MAX DOP

cgross@microsoft.com — Fri, 21 Mar 2008 16:37:08 GMT

It can be difficult to know how to configure the maximum degree of parallelism statement on each SQL Server instance. These guidelines will help you determine the best configuration for your environment. There may be exceptions to the rules below, but they will work in the majority of cases.

Using SysInternals tools to troubleshoot SQL Server

cgross@microsoft.com — Thu, 20 Mar 2008 15:31:38 GMT
Some SQL Server troubleshooting and investigation requires checking operating system configuration, security settings, and currently running processes. These tools can help you in those sorts of issues. They are free downloads available from TechNet.

Partitioning in SQL Server 2005 - Compilation of References

cgross@microsoft.com — Mon, 18 Feb 2008 16:56:40 GMT

Compilation of SQL Server 2005 Partitioning references.

Troubleshooting and Tips - Cindy Gross

SQL Server 2005 SP3 + SP3 CU1 are available!

SQL PASS 2008

New book from Kalen Delaney!

SQL Server 2008 CU1 available

How to change the collation of a SQL Server 2005 database

SQL Injection attacks

How to estimate disk space needed for SQL Server

T-SQL Debugger

Boise SQL Server User Group - Kalen Delaney speaking June 25 at 530pm!

SQL Server 2008 RC0

Where to find SQL Server hotfixes, service packs, and cumulative updates

How to test connectivity from a UDL

SQL Server Memory - Lock Pages in Memory

SQL Server 2005 Service Broker References

Should new installations of SQL Server be on 64bit or 32bit?

Become a SQL Hero

Should SQL and AS share a machine?

How to set MAX DOP

Using SysInternals tools to troubleshoot SQL Server

Partitioning in SQL Server 2005 - Compilation of References