Sign In
Action plans and problem solving
Hello, my name is John Daskalakis and in this blog I will be gathering all the action plans and troubleshooting steps I am using in my daily work. Plus the occasional errors I encounter and how to deal with them. Cheers, John
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
"Unable to load client print control"
[Microsoft][ODBC SQL Server Driver] Timeout Expired
0x080004005 reporting services 2008
0x80090016 windows 2003 2000 scheduled task
17052 Access Violation ole32.dll
database mirroring sql server 2008
DCOM ports firewall
drop partition sql 2005
event viewer profiler SCOM SQL 2005 2007
FCS 0x800106ba 2147942526
GPO Deny Group Policy
iis .net 3.5 migration
iis rewrite module file
IIS site port certificate SSL
lodctr unlodctr sqlctr.ini perfmon counters sql
MOSS SPS Version identify
MSDTC icon red
ORA-12154 DTS SSIS
project 2007 loading grid hang error
recovery complete phase sql database
replication sql performance latency
Resource Governor SQL server 2008
sql 2008 analysis audit
sql 2008 authentication mode logon
sql 2008 compression backup
Archive
Archives
July 2010
(1)
February 2010
(15)
January 2010
(5)
December 2009
(6)
November 2009
(2)
October 2009
(5)
July 2009
(8)
June 2009
(1)
May 2009
(6)
April 2009
(14)
March 2009
(10)
February 2009
(6)
January 2009
(6)
December 2008
(12)
November 2008
(37)
February, 2009
MSDN Blogs
>
Action plans and problem solving
>
February, 2009
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Action plans and problem solving
What data should you backup from your SQL Server cluster?
Posted
over 3 years ago
by
JODASK
4
Comments
Many administrators believe that if they take a backup of their user databases, they are on the safe side. Indeed, on a disaster recovery scenario they can rebuild Windows, they can then rebuild the Windows Cluster and they can reinstall the SQL Server...
Action plans and problem solving
Useful T-SQL queries for a SQL Server 2008 administrator
Posted
over 3 years ago
by
JODASK
2
Comments
Some database administration queries you can use for SQL Server 2008 in order to identify possible problems. I have not written all of these queries myself -- Identify all processes that are blocked for more than 10 seconds SELECT * FROM sys.sysprocesses...
Action plans and problem solving
How to manage SQL Server 2008 by creating and using Policies
Posted
over 3 years ago
by
JODASK
1
Comments
A nice new feature of SQL Server 2008 is Policy-based Management. This whole new feature means that you can enforce certain policies on your SQL Server 2008 whether your users (or the DBAs) like it or not. This feature is 'Enabled' by default when you...
Action plans and problem solving
How to use the resource governor in SQL server 2008
Posted
over 3 years ago
by
JODASK
0
Comments
Starting with SQL Server 2008, a new feature called Resource Governor is introduced in the SQL Server family. The Resource Governor gives you the ability to allocate Processor and Memory resources to a specific workload. These resource limits can even...
Action plans and problem solving
How to remove (drop) the partitioning of a SQL Server 2005 table
Posted
over 3 years ago
by
JODASK
1
Comments
You have decided to remove or recreate the partitioning. If you try to drop either the partition schema or the function you will get errors like these: - The partition scheme "XXXXXXXXXXXXX" is currently being used to partition one or more tables....
Action plans and problem solving
How to configure DCOM to listen to a specific ports range
Posted
over 3 years ago
by
JODASK
1
Comments
In order to allow DCOM to operate efficiently you need to open these ports in the firewall: - Port 135 TCP and UDP - The ports range: 1024-5000 UDP Some network admins won't be happy to do these changes and some might even refuse to open their firewall...
Page 1 of 1 (6 items)