Welcome to MSDN Blogs Sign in | Join | Help

March 2009 - Posts

Monday, March 30, 2009 12:34 PM

You have just installed SQL Server 2008. So now, how do you logon to the instance you just installed?

When you are installing SQL Server 2008, you are asked to specify which authentication mode SQL Server will use when the setup finishes. There are only two options: 1. Windows Authentication Mode You can use only a Windows user account to logon to SQL
Posted by John Daskalakis | 3 Comments
Thursday, March 26, 2009 1:38 PM

How Annotations in tiff images work, between different versions of Windows and Office

Recently, someone had difficulties with the annotations you can create or edit in a tiff image. Until recently he was using the Windows 2000 "Kodak Imaging Tool" to create and edit tiff images. All his document processing corporate activities were based
Posted by John Daskalakis | 3 Comments
Filed under:
Thursday, March 19, 2009 3:50 PM

How can you add a SQL Server 2008 linked server to SQL Server 2000

In order to add a linked SQL Server 2008 to SQL Server 2000, you may execute this query on SQL Server 2000: EXEC sp_addlinkedserver @server=' linked_server_name ', @srvproduct='', @provider='SQLOLEDB', @datasrc=' instance_name ' You only need to give
Posted by John Daskalakis | 1 Comments
Thursday, March 19, 2009 11:11 AM

How can you audit a SQL Analysis Server 2008 for any database role changes

For a SQL Server 2008 Database Engine, there are two events you could capture in a profiler trace: - Audit Add Role Event Class - Audit Database Principal Management Event Class Unfortunately these events do not exist in an Analysis Server profiler! So
Posted by John Daskalakis | 0 Comments
Wednesday, March 18, 2009 3:37 PM

How can you stop a specific GPO from getting applied on an Organizational Unit?

Let’s face it... Not all Group Policies are welcome by all of the users you administer. Sometimes you will not want a specific GPO to be applied to a certain Organizational Unit. So what can you do? One easy way is to create a security filter for these
Posted by John Daskalakis | 2 Comments
Tuesday, March 17, 2009 11:06 AM

How can you audit SQL Server 2008 by using the new “SQL Server Audit” feature?

In previous versions of SQL Server, database administrators used to audit via a server-side trace or a with a profiler trace constantly running in a logged on user’s session. SQL Server 2008 however provides a new auditing feature called “SQL Server Audit”.
Posted by John Daskalakis | 2 Comments
Monday, March 16, 2009 1:36 PM

How to use SPARSE columns in SQL Server 2008 and why?

One new feature of SQL Server 2008 are SPARSE columns. So what is a SPARSE column? - Any column that has many NULL values is a good candidate for a SPARSE column. - A SPARSE column saves you space when it has many NULL values. - The tradeoff is that some
Posted by John Daskalakis | 0 Comments
Monday, March 16, 2009 9:48 AM

How to use compressed backups in SQL Server 2008 and why?

Starting with SQL Server 2008 you can use compressed backups. There are however some restrictions: - Only the Enterprise Edition of SQL Server 2008 can capture these compressed backups. - You can restore a compressed backup using any Edition of SQL Server
Posted by John Daskalakis | 1 Comments
Friday, March 13, 2009 12:45 PM

SQL 2005 Service Pack 3 fails to install on a SQL Cluster with error: 29515

Recently we faced a problem installing Service Pack 3 on a SQL 2005 cluster. In the hotfix logs the error that was reported was: MSP Error: 29515 SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL
Posted by John Daskalakis | 0 Comments
Tuesday, March 03, 2009 1:25 PM

What is FILESTREAM for SQL Server 2008 and how to use it?

FILESTREAM is a whole new feature to SQL Server 2008, which allows you to store varbinary large objects (BLOB) directly on the NTFS filesystem of Windows. You can then use T-SQL to manage these objects (like INSERT & UPDATE) just as if they were normal
Posted by John Daskalakis | 3 Comments
Filed under:
 
Page view tracker