SQL Server Cast
Tune into SQL Server Troubleshooting and Tools
After 4 years working in Microsoft Support, I have decided to change gears and move into the PFE...
Date: 05/19/2011
Database Transaction Log Cannot be Shrunk Because it is Marked as “REPLICATION” (and Replication has not been Configured)
This week I got involved in a case where a Microsoft Dynamics AX database log could not be reduced...
Date: 03/09/2011
Please, refer to this link for the first part of this post. In this part we will start with the same...
Date: 12/08/2010
There are situations where a SQL Server DBA needs to keep two different tables in sync. Usually, the...
Date: 12/07/2010
Today I want to post about my findings on a case involving a linked server between two SQL Server...
Date: 11/30/2010
I did find this error on a Windows Server 2008 and SQL Server 2008 installation but as you will see...
Date: 11/28/2010
Last week I worked with one of my co-workers from the Windows Platform Support group in a...
Date: 11/25/2010
“The IP Address 'x.x.x.x' is already in use. To continue, specify a different IP address” SQL Server 2008 cluster setup error
Today I want to talk about my experience with one of the most strange setup errors installing SQL...
Date: 11/21/2010
“OnlineThread: SQL Cluster shared data upgrade failed” error (ID 19019) installing Cumulative Update in SQL Server cluster
Last week I was working with a customer on this obscure SQL Server error right after installing...
Date: 10/14/2010
If you have ever try to setup firewall rules in your network to manage access to SQL Server you have...
Date: 10/05/2010
SQL Server Maintenance Plans bring an easy way to DBAs to quickly setup routine maintenance...
Date: 02/04/2010
“The domain group cannot be validated for the service SQL Server” SQL Server 2005 cluster SP3 setup error
Here again I am trying to shed some light on another SQL Server 2005 setup error that you may...
Date: 11/19/2009
I think it could be interesting to share this SQL Server 2005 setup error since the message written...
Date: 11/12/2009
This case taught me a very useful lesson about how impersonation works when executing a SQL Server...
Date: 10/19/2009
Some weeks ago I received a call from one of our customers concerning the SP3 installation on SQL...
Date: 09/07/2009
After installing a new SQL Server 2008 instance on my Windows 7 laptop I find myself unable to logon...
Date: 08/25/2009
You probably have heard about Cluster Server Recovery Utility before, a nice Windows utility that...
Date: 07/13/2009
I worked last day on an very tricky SQL Server 2008 setup problem and think it is worth the time...
Date: 05/28/2009
Working at Microsoft Customer Support Services (CSS), we are frequently asked by our customers to...
Date: 01/21/2009
During a recent work with one of our customers I did notice that it is not always clear what tools...
Date: 01/19/2009
"Unable to create computer account on DC" error installing SQL Server 2005 cluster on Windows Server 2008
Windows Server 2008 introduces significant changes to the Windows Cluster Service. The new Windows...
Date: 10/01/2008
There are times where all the SQL Server knowledge in the world won't help us to find a solution to...
Date: 07/27/2008
This week I has been working on a case about the installation of a certificate on a SQL Server...
Date: 02/19/2008
This time I want to discuss a support case that took me some days to get fixed. This case may be of...
Date: 02/12/2008
This is the Spanish version of this other post. Esta vez sólo deseo anunciar que mi...
Date: 01/11/2008
This time I just wanted to announce that my colleague Ignacio Alonso Portillo (aka "Nacho") and...
Date: 01/01/2008
Update (1st. January): CA has released a new eTrust definitions update that corrects the error...
Date: 12/31/2007
According to Books Online reference "SQL Server Configuration Manager is a tool to manage the...
Date: 12/27/2007
Some weeks ago a colleague from another company called me for help in fixing a database performance...
Date: 12/16/2007
I have been asked this question several times: Is there a tool in SQL Server where I can easily...
Date: 12/09/2007