Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

November 2008 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

November 2008 - Posts

[OT] UK Government Helps You - Beware its a SPAM*

Wednesday, November 26, 2008 1:33 AM 

UK Government Helps You - Beware its a SPAM*

With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are targeting the vulnerable users to obtain their personal details. Here I would like to present the email that you may get:


----- Original Message -----
Sent: Saturday, November 22, 2008 5:11 AM
Subject: UK Government Helps You

  Hello ,
UK Government has decided to help you .Ministry of Finance  has decided to return some of
the taxes payed by you during the time. Has decided that every man aged between 30 and 55 years
to receive 450 pounds for family maintenance . The requirement is to be married and to have a job.
For those who have children will be given an additional 200 pounds .All you have to do to take
possession of money is to fill our form for our SQL Server database.
Make a click on the link below to be redirected to our form :
Thank you !
UK Government & Ministry of Finance
To give you headsup on the link given on the email [http://www.DirectGov.gov/tax/refund/helps.html]  will not get you any page with regard to
UK Government & Ministry of Finance department and it will originate to a phishing site.The web browsers IE and Firefox will have the Phishing filter to enable that can warn with similar message below:
Reported Web Forgery!
      Reported Web Forgery!
This web site has been reported as a web forgery and has been blocked based on your security preferences.
Web forgeries are designed to trick you into revealing personal or financial information by imitating sources you may trust.
Entering any information on this web page may result in identity theft or other fraud.
As my default browser setup is Firefox which contains the built-in phishing and malware protection has warned about the above page, so I would like to let you know that whenever you click on any weblink that is referred through any documentation or email please make sure to check the correct web address that must refer to the subject.
Be safe and be vigilent, don't let spammers get your personal information with a few clicks!


Posted by ssqa.net | with no comments

Kilimanjaro - code name release for SQL Server

The News is out for next SQL Server release!!

During the Keynote presentation by Ted Kummert at PASS conference, Microsoft announced future capabilities for application and multi-server management as part of the SQL Server code-name “Kilimanjaro” release. This release is concentrated on multi-server management to reduce the complexity and ambiguity around developing, deploying, and managing applications across the application lifecycle. A new application model and management point development within this release to discover and manage SQL Server instances and define deployment policies to simplify database management, optimize resources, streamline collaboration, and help efficiently manage at scale.

For more information on this news visit the SQL Server PressPass site.

Cumulative Update Package 2 for SQL Server 2008

Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008.

Earlier posting on Cumulative Update Package 1 for SQL 2008 one of the user asked me how to find out how many update packages were released after SQL Server 2008 RTM is released, the answer is refer to this KBA956909 for more information.

 As per the notes on the KBA958156 :

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.

If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package

A few hotfixes that were important for me on this CU2 are:








958792 FIX: You cannot rebuild an index by using the REBUILD argument together with the ALTER TABLE statement or the ALTER INDEX statement if the table uses Sparse Columns as defined in SQL Server Management Studio



There are many more and for such information refer to the KBA958156 article above, a piece of advice before closing is you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.


RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to hear that Microsoft Development team developed an update for the RML Utilities which now includes support for SQL Server 2008 product too.

Not only that there are few intertesting stuff surrounding this support to 2008 version and all those facts & figures can be obtained from PSSQL RML-Utilities blog post.

So make sure you download them to test and use it wisely when any issues crops up within your SQL Server 2008 environment.