SQL-Articles

New article on “Policy Based Management” is posted in our main website. Check the article from the link given below.

This article discusses the new feature named Policy Based Management in SQL Server 2008. Policy Based Management is an extensive management configuration that can be used to manage servers, databases and objects. Policy Based framework provides a way to define policies that apply to servers, databases and objects. With Policy based Management framework, you can enforce consistent policies across all servers.

Policy Based Management - SQL Server 2008

SQL Server 2008 Administration, SQL Server 2008

In previous versions of SQL Server we have used sp_makewebtask procedure to generate HTML output for a query. From SQL Server 2008 MS has depreciated web assitant procedures. You can find this option under surface area configuration (SAC) in SSMS 2008 however if you enable this option for SQL Server 2008 you will be thrown with the below error message.

TITLE: Microsoft SQL Server Management Studio
——————————

This method cannot be called on the server version 10. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.UnsupportedVersion&LinkId=20476

——————————
BUTTONS:
OK
——————————

This parameter is provided in SSMS 2008 for backward compatibility. i.e If you connect to SQL 2005 and then you can use this option.

Ok Now comes the question. How can I generate HTML output in SQL Server 2008 without using web assistant stored procedure?
The only option is to use reporting services to generate HTML output in SQL Server 2008. As an alternate you can also write your own T-SQL statements to print HTML tags while generating the output thereby creating a HTML page.

SQL Server 2008 SQL Server 2008, T-SQL

After the release of CU1 for SQL 2008 a month ago now SQL Server team has released the next cumulative update for SQL Server 2008 on November 19, 2008. To know more about cumulative update 2 for SQL Server 2008 check the link “http://support.microsoft.com/default.aspx/kb/958186/en-us“. This build of the cumulative update package is also known as build 10.00.1779.00.

APPLIES TO

• Microsoft SQL Server 2008 Analysis Services
• Microsoft SQL Server 2008 Community Technology Preview
• Microsoft SQL Server 2008 Developer
• Microsoft SQL Server 2008 Enterprise
• Microsoft SQL Server 2008 Express
• Microsoft SQL Server 2008 Express with Advanced Services
• Microsoft SQL Server 2008 Reporting Services
• Microsoft SQL Server 2008 Standard
• Microsoft SQL Server 2008 Standard Edition for Small Business
• Microsoft SQL Server 2008 Web
• Microsoft SQL Server 2008 Workgroup

SQL Server 2008 Administration, SQL Installation, SQL Server 2008

I’ve posted a new article in our website on Filtered Index topic. You can check the article in the link “Filtered Index - SQL Server 2008” and provide your feedback.

SQL Server 2008 Administration, SQL Server 2008

I was reading PSS MSDN blogs and found an useful information about SQL 2008 installation and thought of sharing this with you. There is a know issue with SQL 2008 setup (refer KB article http://support.microsoft.com/kb/957453/) and they have fixed this in cumulative update 1. Lets see how to use CU1 to fix this installation issue.

• Before Installing SQL 2008 from CD \ DVD, download cumulative update 1(http://support.microsoft.com/kb/956717) and install it in the machine, this will install the newly updated setup support files alone with the version 10.00.1763.0.

• Once this is done, you can now proceed with SQL 2008 installation. When the installation starts it will use the newly installed setup support files bypassing the know issue with the KB article 957453.

• After successful installation of SQL 2008 you need to re-run cumulative update 1 to update all SQL 2008 components.

That’s it you have done with the installation!!

To know more on this topic you can refer this PSS blog link “How to fix your SQL Server 2008 Setup before you run setup…“.

SQL Server 2008, Troubleshoot Administration, SQL Installation