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

In SQL Server 2008 Microsoft has introduced new date time data types and functions to help developers. Till SQL 2005 if you need to declare a column as date or time alone you need to use DATETIME data type which inputs both date and time and developers needs to convert or cast function to bring date or time alone. As you know using convert in a large column will slightly affect performance. Considering all these factors MS added the following data types in SQL 2008. Lets discuss on this

Data Types

Time:

This data type will allow you to insert only time, even if the input value contains date it will take only time. Precision is applicable to this data type to get NANO seconds. Maximum and default precision value is 7. Sample is shown in the image below and the precision value is the table

Read more…

SQL Server 2008 Data Type, SQL Server 2008, T-SQL