By Cindy Gross on
Monday, December 15, 2008 6:52:49 PM
SQL Server 2005 service pack 3 (SP3) is now available! There’s also a new version of the feature pack and of BOL.
· SP3 itself contains all fixes from SP2 based CU1-CU9 but it does not include most CU10 or CU11 fixes due to the timing of when the CTP (beta) of SP3 started. This pure SP3 version is 9.00.4035. If you want to have al
Read More »
|
By Cindy Gross on
Thursday, November 13, 2008 9:09:47 AM
I hope to see you at PASS this year!
Thursday, Nov 20, 2008
3p-415p
|
By Cindy Gross on
Wednesday, October 22, 2008 12:48:10 PM
Kalen's new book is ready for pre-ordering!
Microsoft® SQL Server® 2008 Internals
Read More »
|
By Cindy Gross on
Monday, September 22, 2008 8:54:03 PM
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.
Read More »
|
By Cindy Gross on
Wednesday, September 10, 2008 9:03:40 PM
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?
Read More »
|
By Cindy Gross on
Tuesday, June 24, 2008 5:09:22 PM
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.
Read More »
|
By Cindy Gross on
Tuesday, June 24, 2008 8:44:58 AM
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.
Read More »
|
By Cindy Gross on
Monday, June 23, 2008 4:18:30 PM
Many people have asked where the TSQL debugger is for SQL Server 2005.
Read More »
|
By Cindy Gross on
Monday, June 23, 2008 8:44:19 AM
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
Read More »
|
By Cindy Gross on
Thursday, June 12, 2008 11:09:45 AM
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.
Read More »
|
By Cindy Gross on
Tuesday, May 13, 2008 10:43:06 AM
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.
Read More »
|
By Cindy Gross on
Wednesday, April 30, 2008 2:31:16 PM
A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services connectivity issues.
Read More »
|
By Cindy Gross on
Monday, April 28, 2008 6:53:33 AM
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.
Read More »
|
By Cindy Gross on
Monday, April 14, 2008 12:04:41 PM
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.
Read More »
|
By Cindy Gross on
Wednesday, April 09, 2008 8:03:11 AM
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.
Read More »
|
By Cindy Gross on
Wednesday, March 26, 2008 4:30:22 PM
http://blogs.msdn.com/sqlheroes/
Read More »
|
By Cindy Gross on
Monday, March 24, 2008 12:59:23 PM
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?
Read More »
|
By Cindy Gross on
Friday, March 21, 2008 9:37:08 AM
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.
Read More »
|
By Cindy Gross on
Thursday, March 20, 2008 8:31:38 AM
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.
Read More »
|
By Cindy Gross on
Monday, February 18, 2008 9:56:40 AM
Compilation of SQL Server 2005 Partitioning references.
Read More »
|