Cindy Gross: SQL Server + Big Data

Cindy Gross - SQL Server and Big Data Troubleshooting + Tips

Previous blogs on SQLCommunity.com

Previous blogs on SQLCommunity.com

  • Comments 3

Want to provide feedback on any Microsoft product? Want access to the latest CTPs (sometimes known as betas)?

 

Create an account on http://connect.microsoft.com/ and you can file bugs or wishes and vote on what other people have submitted. You can also find CTPs and evaluation editions of various products. For example, to get the CTP of SQL Server 2008 SP1 go to http://connect.microsoft.com/SQLServer.  From the same page you can access the SQL Server feedback section as well as the SQL Server discussion forums. Please vote on your favorite bugs/requests/wishes as this increases the chance they will change for a future version of SQL Server.

SPNs: What They Are and How SQL Server 2000/2005 Uses Them for Kerberos Authentication

SPNs: What They Are and How SQL Server 2000/2005 Uses Them

Agenda

·         Overview

·         Vocabulary

·         When SQL Server Uses an SPN

·         What a valid SQL Server SPN Looks Like

·         Define a Valid SQL or OLAP SPN

·         How to Check an SPN

·         SPN Ownership

·         Prerequisites

·         How to Set an SPN

·         Troubleshooting

·         SQL 2008

·         References

When you choose to open a file in SQL Server Management Studio (SSMS) it opens a new query window. Sometimes you would prefer to open the file in an existing window to add it to other code or to avoid entering the connection information again.

This is the best description I’ve seen of how to do disk alignment. It’s not really specific to SQL Server, it applies to any Windows server.

 

SQL Server 2005 SP3 + SP3 CU1 are available!

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

Kalen's new book is ready for pre-ordering!
 
Microsoft® SQL Server® 2008 Internals
 

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?

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.

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.

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

SQL Server 2008 RC0

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

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

A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services connectivity issues.

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

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.

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.
Page 1 of 1 (3 items)
Leave a Comment
  • Please add 6 and 1 and type the answer here:
  • Post