Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tricks   (RSS)

Reporting Services Staaaarrrrrtttt Up

Posted Friday, November 09, 2007 4:01 PM by sqlblog
I hear the complaint a lot that after a time period of no calls to Reporting Services, the first call to the Reporting Services instance is very slow. This is totally expected because the application pool generally gets spun down and we need to restart Read More...
0 Comments

Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases...

Posted Tuesday, November 06, 2007 3:23 PM by sqlblog
An Analysis Services 2005 query against a calculation on a cell may report the error: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." This may be because there are simply more underlying cells in Read More...
0 Comments

General network errors (GNEs), Timeout expired, SQL Server not found or Access Denied…

Posted Thursday, September 06, 2007 9:17 AM by sqlblog
Many times, the key to solving these errors is a network packet trace. The problem is that these errors are often thrown intermittently. This can obviously make it problematic to capture a network trace. Network Monitor 3 (AKA Netmon3) solves this problem Read More...
0 Comments

Tools of the Trade: Part IV – WinDbg & AdPlus (I)

Posted Tuesday, September 04, 2007 10:50 AM by sqlblog
In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. In this article, Enamul Khaleque starts down the Read More...
0 Comments

SQL Server Support FAQ

Posted Thursday, August 16, 2007 12:15 AM by sqlblog
How often should I expect to hear from my Support Engineer? This will vary based on the issue and its impact to your business. If you have specific preferences for frequency of contact, time of day, or method (prefer phone vs. e-mail), please discuss Read More...
2 Comments

Tools of the Trade: Part III – Kerberos (I)

Posted Monday, April 16, 2007 2:57 PM by sqlblog
In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. In this article, Adam Saxton starts down the long Read More...
1 Comments

Tools of the Trade: Part II – The Repro

Posted Monday, April 16, 2007 2:52 PM by sqlblog
In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. This post might seem like a bit of a stretch. For Read More...
0 Comments

SQL 2005 SP2 is available now!

Posted Monday, February 19, 2007 1:14 PM by sqlblog
Finally, after rounds of CTPs (Community Technology Previews) and great feedback from customers, we have officially released Service Pack 2 (SP2) for SQL 2005. Download SP2 You can download it by visiting the Microsoft website here . Enhancements in SQL Read More...
0 Comments

PART II - Data security enhancements in SQL Server 2005

Posted Friday, February 16, 2007 11:50 AM by sqlblog
In the previous edition ( Data security enhancements in SQL Server 2005) , we talked about data encryption/decryption in general. In this installment, let’s talk about key maintenance. It is important to ensure that we can decrypt our data, even in case Read More...
1 Comments

Tools of the Trade: Part I – Universal Data Link Files

Posted Friday, February 16, 2007 11:21 AM by sqlblog
The other day I was working on an issue with one of our customers. I had been having him run several different tests using a few of the tools that we use on the SQL Developer team on a daily basis. After about the third or fourth diagnostic we ran, he Read More...
4 Comments

SQL Server 2000/2005 and DST changes

Posted Monday, January 29, 2007 10:39 AM by sqlblog
Background In August of 2005 the United States Congress passed the Energy Policy Act, which changes the dates of both the start and end of daylight saving time (DST). When this law goes into effect in 2007, DST will start three weeks earlier (2:00 A.M. Read More...
1 Comments

How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

Posted Wednesday, December 06, 2006 3:16 PM by sqlblog
Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers. In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes. To learn about these enhancements, Read More...
0 Comments

Tracking License Information in SQL 2005

Posted Friday, November 10, 2006 6:44 PM by sqlblog
SQL 2005 no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup doesn’t put licensing information in the registry during setup as in SQL 2000. This is Read More...
13 Comments

Help! All of my reports fail with an authentication failure!

Posted Sunday, October 08, 2006 10:47 AM by sqlblog
Have your Reporting Services 2005 reports started failing recently with the error message? Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Check your Unattended Execution Account (UEA). Read More...
5 Comments

MSDTC and SQL Server on a cluster

Posted Friday, October 06, 2006 12:46 PM by sqlblog
Through this blog, we will try to address commonly asked questions about MSDTC and SQL Server on a cluster. All this information is available in BOL and KB articles, but we will summarize it here for your convenience. Do I need to install MSDTC on my Read More...
4 Comments
More Posts Next page »
 
Page view tracker