|
|
NEW! - Remote Monitoring & DBA Services
Front Page News
-
|
If you simply search on the error message within the subject then the best point of it is you get many references on how to resolve this issue. Going back to root cause of the problem is that number of people have reported problems using the ActiveX print...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New SQL Server 2005 default instance may not start when...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications How to fix permission issues when moving MSDB database between different instances http://support.microsoft.com/kb/2000274/en-US...
|
-
|
There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning! The above error was presented to me recently when I'm trying to install SQL Server 2005 & 2008 versions on my...
|
-
|
There is much more sayings on the blogs about 64 bit platform issues when you have 32 bit applications, so it bit noise to create there about the common problem that I have seen (virtually anywhere) that SSIS packages will suffer a lot between these platform...
|
-
|
If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;en-us;28151...
|
-
|
Here is the interesting post that I would like to share to my community about free stuff such as courses and software by Andrew Fryer , for your joy http://blogs.technet.com/andrew/archive/2009/06/09/free-stuff-sql-server-courses-software.aspx is the...
|
-
|
As referred on the Pattern and Practices - deprecate and discontinued Transact SQL features we will now look into (my favs) on SQL Server 2008 TSQL features, rather we spotlight on deprecated and discontinued features! IT is one of the best practice that...
|
-
|
The error subject line is caused due to issues with Oracle Client and Networking connection privileges. By default when you have SQL replication setup to an Oracle client then the account under which SQL Server instance runs on the Distributor must be...
|
-
|
It has been a while that I posted any blog in this section and lately there has been problems within the x64 platform. One of them is SSIS packages and another is this "SQL Server Edition Operating System Compatibility Some components of this edition...
|
-
|
The above error message might look familiar for the DBAs who manage 64 bit platforms, it is a simple connection error when SSIS connection (on 64 bit) attempted to Oracle database. In the past I have seen this error when it attempts to connect 32 bit...
|
-
|
It brings me a great joy and actual skill of solving the TSQL challenge posts by fellow MVP Jacob Sebastian and this thime see the Aurelien and Matthieu have fun with TSQL Challenges post which is a mixture of fun & skill of solving the puzzle. For...
|
-
|
The BizTalk ESB Toolkit 2.0 , formerly known as the ESB Guidance 2.0 - is being released June 9th to the web on the new ESB page in the BizTalk Developer Center on MSDN. This toolkit is a collection of tools and libraries that extends BizTalk Server 2009...
|
-
|
Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...
|
-
|
Here is the TSQL script that I received from one of the enthusiastic SQL user Prabhakaran on our site: SET NOCOUNT ON DECLARE @job TABLE ( seq SMALLINT IDENTITY, jobname SYSNAME ) ; -- Declare Table variable to hold job info DECLARE @name SYSNAME, @seq...
|
-
|
When you use variables in update statement and update the columns with the values of varaibles which keep on changing for each row , you can simulate many things that are done using Loop or a Cursor declare @temp table ( product_name varchar ( 100 ),...
|
-
|
Here is the interesting post Cyber Security Bulletin SB09-117 that I found from US-CERT (United States Computer Emergency Readiness Team). Here is the extract about the methods followed to generate the alert: The US-CERT Cyber Security Bulletin provides...
|
-
|
During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology, tools and...
|
-
|
When you talk about Performance problems then fragmentation & database integrity issues are dearest friends of DBA! As data is modified in the databases, the tables and indexes will become fragmented, which means the data is scattered everywhere in...
|
-
|
I had been receiving a good feedback about the solution that has been posted previous about Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008 and inline link for SQL Server 2005 too. In fact...
|
-
|
Here is your chance to win one of 10 great prizes, including a free PASS Summit 2009 registration or 4 nights free hotel at PASS Summit 2009, free Pre/Post-Conference session registration, or a full set of PASS Summit 2008 session recording DVDs. Community...
|
-
|
Here is the update from Microsoft Development team for BizTalk Server 2009, they are located under the “Top Downloads” section in Dev Center page, and they are for the BizTalk Server 2009 Installation and Upgrade Guides , the BizTalk Server 2009 Code...
|
-
|
This bulletin summary lists security bulletins released for May 2009. The full version of the Microsoft Security Bulletin Summary for May 2009 can be found at http://www.microsoft.com/technet/security/bulletin/ms09-may.mspx . With the release of the bulletins...
|
-
|
Common Criteria (CC) Certification is required for any environment and SQL Server is no compromise or exception in this case. I would like to highlight a brief introduction to this requirement (as per my experience), in the recent times many changes to...
|
-
|
It is a great news that Microsoft has re-confirmd about the changing the economic model for delivery of rich Business Intelligence (BI) functionality such as moving the dashboard, score-cards and analytic functionality from the stand alone produce PerformancePoint...
|
|
|
|